As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?

Answer Posted / swapna

DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the instances when triggers are appropriate?

618


How to list all field names in the result set using mssql_field_name()?

613


What are various aggregate functions that are available?

589


How to check parameter value in stored procedure sql server?

561


How do I determine how many instances of sql server are installed on a computer?

618






What is report snapshot?

113


What do you know about system database? : SQL Server Architecture

572


How exceptions can be handled in sql server programming?

624


What command would you use to add a column to a table in sql server?

857


How many types of cursor type are there?

664


What is the synonym of join?

603


What is “asynchronous” communication in sql server service broker?

635


How to get the definition of a stored procedure back?

615


How do you manipulate data?

585


What are magic tables in sql server?

702