Category Archives: SQL Scripts

SQL Server Transactions Per Day

SQL Server Transactions Per Day This post can help you in capturing SQL Server Transactions per day. Sometimes we need to capture the average number of transactions per day / hour / minute. Below is the T-SQL script that can … Continue reading

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

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

SQL Server Space Usage

SQL Server Space Usage Hello there, this post can explain various ways to know the SQL Server Space Usage information. Here are the different ways available: XP_FIXEDDRIVES SP_SPACEUSED SP_HELPDB DBCC SQLPERF (LOGSPACE) sys.dm_os_volume_stats Database and file wise Space usage Used … Continue reading

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