Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is DBCC
What is DBCC?
✍: Guest
DBCC (Database Consistency Checker Commands) is used to check logical and physical
consistency of database structure.DBCC statements can fix and detect problems.They
are grouped in to four categories
Maintenance commands like DBCC DBREINDEX , DBCC DBREPAR etc ,
they are mainly used for maintenance tasks in SQL SERVER.
Miscellaneous commands like DBCC ROWLOCK , DBCC TRACEO etc ,
they are mainly used for enabling row-level locking or removing DLL from
memory.
Status Commands like DBCC OPENTRAN , DBCC SHOWCONTIG etc ,
they are mainly used for checking status of the database.
Validation Commands like DBCC CHECKALLOC,DBCC
CHECKCATALOG etc , they perform validation operations on database.
Note :- Check MSDN for list of all DBCC commands, it is very much possible specially
during DBA interviews they can ask in depth individual commands.
Below is a sample screen in which DBCC SHOWCONTIG command is run. DBCC
SHOWCONTIG is used to display fragmentation information for the data and indexes
of the specified table.In the sample screen gCustomerh table is checked for fragmentation
information. If you look at the figure “Scan density” is 100 if everything isucontigious in
this image it is 95.36% which is decent percentage. So such type of useful information
can be collected by DBCC command and database performance and maintenance can be
improved.
2007-10-25, 5368👍, 0💬
Popular Posts:
Can you explain in brief how can we implement threading ? Private Sub Form1_Load(ByVal sender As Sys...
Can Two Forms Be Nested? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields Can two forms ...
Can JavaScript steal text from your clipboard? It is true, text you last copied for pasting (copy &a...
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...
What are some advantages and disadvantages of Java Sockets? Advantages of Java Sockets: Sockets are ...