SQL Server: Understanding and Using DBCC Commands
Course info



Course info



Description
There are many DBCC commands available to database administrators and developers. Some are for the greater good; others can wreak havoc in a production environment.
In this course, SQL Server: Understanding and Using DBCC Commands, you'll explore DBCC commands that are useful and relevant, whether you're a DBA or a developer (this course is for SQL Server 2005 and up).
What you will learn in this SQL Server course:
- First, you'll cover the most basic commands and the informational commands--when to use them and how, in order to minimize impact on the solution.
- Next, you'll learn about the maintenance commands and how to recognize when a DBCC command has been superceded by a Dynamic Management Object, along with examples of how to use them.
- Finally, you'll learn about undocumented DBCC commands and go through scenarios on when to use them.