Explain some DBCC commands?

Answers were Sorted based on User's Feedback



Explain some DBCC commands?..

Answer / swapna

DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc. But there are a whole load of DBCC commands
which are very useful for DBAs.

Is This Answer Correct ?    16 Yes 2 No

Explain some DBCC commands?..

Answer / karthick.p

DBCC SHOWCONTIG - TO FIND THE FRAGMENTATION

DBCC SHRINKDATABASE - TO REDUCE THE SIZE OF THE DATABASE

DBCc SHRINK FILE - TO REDUCE THE SIZE OF THE FILE

Is This Answer Correct ?    11 Yes 1 No

Explain some DBCC commands?..

Answer / varun

dbcc opentran,dbcc inputbuffer,dbcc outputbuffer.

Is This Answer Correct ?    9 Yes 2 No

Explain some DBCC commands?..

Answer / samar

DBCC commands

1. DBCC CHECKCONSTRAINTS <db_name>|<indexname> WITH
ALL_CONSTRAINTS
Here with all coinstraints include disable coinstraints also

DBCC CHECKCONSTRAINTS checks the integrity of foreign key
and checked constraints, but does not check the integrity
of a table's on-disk data structures. These data structure
checks can be performed with DBCC CHECKDB and DBCC
CHECKTABLE

2. DBCC CHECKTABLE performs a physical consistency check on
tables and indexed views. The NOINDEX option, used only for
backward compatibility, also applies to indexed views.
For the specified table, DBCC CHECKTABLE checks that:
· Index and data pages are correctly linked.
· Indexes are in their proper sort order.
· Pointers are consistent.
· The data on each page is reasonable.
· Page offsets are reasonable.

DBCC CHECKTABLE does not acquire a table lock by default.
Instead, it acquires a schema lock that prevents meta data
changes but allows changes to the data.
To perform DBCC CHECKTABLE on every table in the database,
use DBCC CHECKDB.

3. DBCC DBREINDEX can rebuild all of the indexes for a
table in one statement, which is easier than coding
multiple DROP INDEX and CREATE INDEX statements. Because
the work is done by one statement, DBCC DBREINDEX is
automatically atomic

4. DBCC HELP returns a result set displaying the syntax for
the specified DBCC statement


5. DBCC INDEXDEFRAG can defragment clustered and
nonclustered indexes on tables and views. DBCC INDEXDEFRAG
defragments the leaf level of an index so that the physical
order of the pages matches the left-to-right logical order
of the leaf nodes, thus improving index-scanning
performance.
DBCC INDEXDEFRAG also compacts the pages of an index,
taking into account the FILLFACTOR specified when the index
was created. Any empty pages created as a result of this
compaction will be removed

Is This Answer Correct ?    8 Yes 2 No

Explain some DBCC commands?..

Answer / sanjeev kumar

DBCC stands for database consistency checker. We use these
commands to check the consistency of the databases.
Example, maintenance, validation task and status
checks.Saying is that,through DBCC we can check what is
happining in database on time to time. It give me a changes
of information just happing in a bit of time (this is the
reason it is called consistency)
like:-
DBCC CHECKALLOC - Check consistency of disk allocation.
DBCC CHECKCATALOG - Check catalog consistency
DBCC CHECKCONSTRAINTS - Check integrity of table constraints.

etc.

Is This Answer Correct ?    6 Yes 1 No

Explain some DBCC commands?..

Answer / kiran

PLEASE TEL ME ANY ONE
WHAT IS THE DIFFERENCE BETWEEN DBCC INPUTBUFFER AND DBCC
OUTPUTBUFFER?

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Security Question- SQL DBA exparts, need your help...

3 Answers  


How to delete the duplicate rows from a table in SQL Server ??

3 Answers  


Tell me when is the update_statistics command used?

0 Answers  


Explain the collation?

0 Answers  


What is index, cluster index and nonclustered index?

0 Answers  






What is plan freezing?

0 Answers  


how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,


What are the transaction properties?

0 Answers  


What is use of except clause? How does it differ from not in clause?

0 Answers  


How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  


What are the different types of cursor?

0 Answers   HCL,


What does it mean to normalize data?

0 Answers  


Categories