Explain some DBCC commands?

Answer Posted / swapna

DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc. But there are a whole load of DBCC commands
which are very useful for DBAs.

Is This Answer Correct ?    16 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

To which devices can a backup be created and where should these devices be located? : sql server management studio

571


Do I need a report server to run reports in my application?

106


how will add additional conditions in sql?

576


What is indexing a document?

559


What is the difference between osql and query analyzer?

547






Explain time data type in sal server 2008?

552


Define tool Manage Statistics in SQL Server 2000 query ?

528


Write a program using SQL queries to find a unique entry in a table.

550


What do you understand by integration services in sql server?

559


What samples and sample databases are provided by microsoft?

578


Does a full backup include transaction log?

485


What are the parts of a function?

523


State the difference between local and global temporary tables?

570


What are the mathematical functions supported by sql server 2005?

555


Is foreign key a primary key?

513