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
how to use DTS package in 2000,2005,2008 in sql server
What is blocking?
How to provide default values to function parameters?
What are the disadvantages of using the stored procedures?
Find first and last day of current month in sql server
how would you troubleshoot blocking? : Sql server database administration
What are the dis_advantages of stored procedures, triggers, indexes?
Explain what are page splits? : SQL Server Architecture
Write down the syntax and an example for create, rename and delete index?
What is a coalesce function?
What is a scheduled job or what is a scheduled task?
Explain about system database?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is policy based management (pbm)? : sql server database administration
Explain what is use of dbcc commands?