Tag Archives: T-SQL

SQL Server Blocking Report

SQL Server Blocking Report This post can help a SQL DBA / Developer to quickly find the SQL Server Blocking Report using T-SQL scripts. There are various ways to get the SQL Server Blocking Report but here we are going … Continue reading

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , | Leave a comment

Script to get row count for all tables in a SQL Server database

Script to get row count for all tables in a SQL Server database This post helps you in writing a Script to get row count for all tables in a SQL Server database. For any database developer or administrator the … Continue reading

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , | 5 Comments

SP_SPACEUSED is giving wrong counts

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