DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC CHECKALLOC, DBCC S

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

Question Posted / swapna

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

Please Help Members By Posting Answers For Below Questions

What is catalog views?

791

How to create a dynamic cursor with the dynamic option?

713

How do I partition a table in sql server?

710

Can a function call a stored procedure in sql server?

695

What do you mean by SQL injection attack?

795

What is data block and how to define data block size?

779

How to call a function from a stored procedure in SQL Server ?

734

Explain what is the difference between union and union all?

739

How do I start sql server?

693

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

726

Tell about MOM Tool(Microsoft Operator Manager)?

1585

What are magic tables in sql server?

783

how to overcome kernel isssues

1349

What is a data collection table?

720

Some queries related to SQL

736