Problems with Page Splits and How you can prevent it.

Say you have a glass filled with water and you try to put more water in that glass, what happens? Water in the glass will overflow/spill. Exactly the same way, whenever a new row is added to a full index page, SQL Server moves around half of the rows to a new page to...

Remotely Executing SQL Server Commands (Scotty, Beam me up!)

We use EXEC or EXECUTE command almost every day of our database life. It’s a command that allows us execute Stored Procedures (extended, system, user, CLR, etc.)  and Functions. However, EXEC command also has a powerful feature that allows you to run any command...

Best Practices for Managing Large Data Modification

Did you know that you can use the TOP operator for Deleting, Inserting and Updating data in SQL Server tables? Using Top operator for DML operation can help in executing very large operation by breaking the process into smaller pieces. This will help with increased...

Efficiently Managed Thousands of SQL Servers

Imagine this: Your manager (Say Saleem Hakani) has asked you to find out the available disk space for all the drives from all MSG database Servers residing in the production environment. You have 500 SQL Servers that are spread across different datacenters in North...

SQL Server 2014 Backups! Let there be backups and backups happend!

Backups are extremely important for the continuity of business. Many companies fire their engineers just because they didn’t have proper backups in place. Wouldn’t it be great if there was a way that DBA’s and engineers didn’t have to worry about backups and SQL...

Nuts and Bolts of Database Mirroring

Inside Microsoft.comGetting Started with Database Mirroring Saleem Hakani If your database goes offline, you’re probably up a creek, right? If you’re using SQL Server 2005 with SP1, however, the database mirroring feature can prevent disaster. This new...