Category Archives: SQL Scripts

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

SQL Server Health Check

SQL Server Health Check Hello there, if you are a SQL DBA the most common task that you perform is “SQL Server Health Check”. You may already have an automated report but this is for doing a quick SQL Server … Continue reading

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , | 26 Comments

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