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
Explain what are sparse columns?
What is primary key index?
Do you know what are pages and extents? : SQL Server Architecture
Explain what is raid and what are different types of raid levels?
What is the largest component inside a field?
write an SQL query to list the employees who joined in the month of January?
What is the default server name for sql server?
How global temporary tables are represented and its scope?
What is indexing and its types?
How does normalization work?
What should be the fill factor for indexes created on tables? : sql server database administration
What is the difference between function and stored procedure in sql server?
What is the difference between nvl and nvl2?
What do you mean by 'normalization'?
What is an entity-relationship diagram (erd)?