As a part of your job, what are the DBCC commands that you commonly use for da

As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?

Question Posted / swapna

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

More SQL Server Interview Questions

Can we insert data into view sql server?

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

What are different types of join?

what is bit data type? and what are the information that can be stored inside a bit column?

Which tcl commands are available on the sql server?

How do I install only the client tools of sql server 2000?

What is compound operators?

What is the difference between createstatement and preparedstatement?

Define compound operators?

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

How to check if a table is being used in sql server?

What are the advantages of partitioning?

For more SQL Server Interview Questions Click Here