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 impact on other user sessions when creating indexes?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is Extended user-defined?
what is difference between NULL and ISNULL in SQL Server 2008?
What are the differences between DDL, DML and DCL in SQL?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain foreign key in sql server?
What is the Disadvantage of indexed sequential file.
What is SQL Server?
Does union all remove duplicates?
Explain steps of normalization?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How to select all columns of all rows from a table with a select statement in ms sql server?
SQL Server Architecture ?
Does a server store data?