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?

Can we create clustered index on composite key?

0 Answers  

Can we hide the definition of a stored procedure from a use?

0 Answers  

How to get the number of affected rows?

0 Answers  

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

What samples and sample databases are provided by microsoft?

0 Answers  

What are joins in sql and what are the different types of joins?

0 Answers  

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

What are the system database in sql server 2005?

0 Answers  

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

How to connect to a sql server using odbc_connect()?

0 Answers  

where can you add custom error messages to sql server? : Sql server administration

0 Answers