Tag Archives: T-SQL

SQL Server Blocking Report

Posted on November 25, 2016 by uday arumilli

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

Posted on July 5, 2016 by uday arumilli

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

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