Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between cte and view?
What programming language would you use to create embedded functions in ssrs?
What is inline table-value user-defined function?
Explain in brief how sql server enhances scalability of the database system?
Mention what are the core components of ssrs?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How to install sql server 2005 express edition?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are the different type of replication in sql server?
List the ways in which dynamic sql can be executed?
What are the types of indexing?
Ways to improve the performance of a SQL Azure Database?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How do you delete a data source?
