Tag Archives: 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 , , , , , , , , , , | 2 Comments

Update Without Where Clause

Update Without Where Clause Running Update Without Where Clause might causes a data damage when it is with the critical table that creates a lot of problems and escalations. Recently while working with one of the customer we had a … Continue reading

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

Database Restore Progress in SQL Server

Database Restore Progress in SQL Server This post will takes you through you monitoring Database Restore Progress in SQL Server. Here we have an useful script which can help us in the process of restoration of databases. As we are … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 1 Comment