Tag Archives: sql server

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

Top 10 SQL Server Architecture Interview Questions

Top 10 SQL Server Architecture Interview Questions SQL THE ONE There are total 46 questions are answered under SQL Server Architecture category in the book “SQL THE ONE”. In this chapter we’ll find interview questions and answers on SQL Server … Continue reading

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments