Category Archives: SQL Development

SQL Server Date and Time related Interview Questions

SQL Server Date and Time related Interview Questions This post can help you in answering SQL Server Date and Time related Interview Questions. ¬†Below is the list of queries which are recently asked in SQL Server Developer interviews. These are … Continue reading

Posted in Interview Q&A, SQL Development, SQL Scripts | Tagged , , , , | 1 Comment

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

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