As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
Answer / swapna
DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc.
| Is This Answer Correct ? | 5 Yes | 0 No |
What are trace files?
When you should use a low fill factor?
How to populate a table in sql server?
What does it mean to be in union?
How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
What does top operator do?
Do you know what is a linked server in sql server?
Why do you want to join software field as you have done your BE in Electronics?
What is use of except clause? How does it differ from not in clause?
How to update existing rows in a table?
Explain the microsoft sql server delete command?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)