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 filestream storage of sql server 2008?
What is intellisense?
What is a fan-out query in SQL Azure?
Do you know what are acid properties?
How can we get count of the number of records in a table?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is the difference between varchar and nvarchar?
What is b tree index?
What is msdb database? : SQL Server Architecture
Explain transaction server isolation?
What are the different methods available under sqlcommand class to access the data?
What are the database objects? : SQL Server Architecture
Describe how to use the linked server?
What is the use of RDBMS?
How dts is used to extract, transform and consolidate data?