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
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain the creation and execution of a user-defined function in the sql server?
Please illustrate physical database architecture? : SQL Server Architecture
What is database isolation in sql server? : sql server database administration
What is ssl in sql server?
Write an sql query for deleting duplicate rows?
explain different types of cursors? : Sql server database administration
Do you know hot add cpu in sql server 2008?
What are the advantages of using stored procedures in sql server?
Explain different backup plans?
How to enter comments in transact-sql statements?
What is the function of inner join?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is system stored procedures?
How to sort the query output with order by clauses in ms sql server?