Tag Archives: DBCC

SP_SPACEUSED is giving wrong counts

Posted on July 12, 2013 by uday arumilli

SP_SPACEUSED is giving wrong counts !!! SP_SPACEUSED: is a system stored procedure and used to capture number of rows, total size, data and index size information. Sometimes SP_SPACEUSED may give incorrect information or SP_SPACEUSED  give wrong counts. Below are some … Continue reading →

Posted in SQL Development | Tagged , , , , , , , , | 1 Comment

How to Use DBCC CHECKDB in SQL Server

Posted on June 26, 2013 by uday arumilli

How to Use DBCC CHECKDB in SQL Server Use: By far the most widely used command to check the status of your database is DBCC CHECKDB. This statement checks the allocation and structural integrity of all data and index pages … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , , , , , , | 2 Comments

SQL Server DBCC Commands

Posted on December 4, 2009 by uday arumilli

SQL Server DBCC Commands    Microsoft provides a set of SQL Server DBCC Commands originally that stood for Database Consistency Check commands. The DBCC commands are divided into four main categories: Status, validation, maintenance, and miscellaneous commands. Let’s take a … Continue reading →

Posted in SQL Server DBA | Tagged , , , | 2 Comments