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
Explain differences between web edition and business edition?
Explain what is it unwise to create wide clustered index keys?
How to change a login name in ms sql server?
Explain trigger and trigger types?
How do you migrate data from mssql server to azure?
Can sql servers linked to other servers like oracle?
What is data set in report?
What is report rendering ?
Why do we need normalization?
What is triggers and its types?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How do I find the sql server database version?
How sql server enhances scalability of the database system?