Tag Archives: T-SQL

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 , , , , , , , , , , | 4 Comments

TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server TSQL script to get the index size and information in SQL Server post can help you in getting the index information from a database in SQL Server. There … Continue reading

Posted in Performance Tuning, SQL Development | Tagged , , , , , , , , , , , | Leave a comment

SQL Server Backup and Restore Reports

SQL Server Backup and Restore Reports This post can help you to quickly find SQL Server Backup and Restore Reports from a given SQL Server instance. For a typical DBA a most common task is to check the latest backup … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment