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
What is the difference between executequery () and executeupdate ()?
How to enter date and time literals in ms sql server?
How can you list all the columns in a database?
Why transaction is important?
How to list all schemas in a database?
Explain timestamp datatype?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What does dml stand for?
How will you add a dimension to cube? : sql server analysis services, ssas
What is dirty read?
What is the difference between seek predicate and predicate?
What is trace flag in sql server?
How to find the second highest salary of an employee?
Can group by be used without aggregate functions?
What is sub-query in sql server?