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.

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

Answer / varun

dbcc opentran,dbcc inputbuffer,dbcc outputbuffer.

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

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.

Answer / kiran

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

What is the use of stored procedure?

0 Answers  

What are the new features in sql server 2016?

0 Answers  

How can windows applications connect to sql servers via odbc?

0 Answers  

Can primary key be null?

0 Answers  

Explain what is log shipping?

0 Answers  

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

What does this statement do @@rowcount?

0 Answers  

Tell me can we use custom code in ssrs?

0 Answers  

Creating Tables Using SELECT

1 Answers  

Do you know what is lock escalation?

0 Answers  

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

Explain nested join?

0 Answers