Gregory Larsen

Have you been experiencing vastly different execution times for the same query over time? If so, you might be experiencing what is known as

As a DBA it is important to have a toolbox that supports the work you do.  You need to have a toolbox that allows you to work smarter instead of

Have you ever cancelled a large transaction, only to find it doesn’t cancel immediately? Instead of cancelling immediately you must wait for a

If you have been a DBA for a while you have probably gone through at least one migration to a new version of SQL Server, or maybe even more than one

Suppose you are a new DBA in an environment. You are tasked with restoring a database, but you don’t have a single clue as to what is in any of the

There are times when an application needs to execute dynamic TSQL. Dynamic TSQL is SQL code that is generated by a program then executed. There are a

In my last tip Displaying the Object Explorer Details Pane in SQL Server Management Studio, you learned how to bring up the Object Explorer Details pane.

You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the

Have you ever heard of the identity cache? If not, it is just a cache that stores the next 1000 available identity cached values for a table. The identity

Have you deleted a bunch of rows from a table that has an identity column value? Do you now find that when you insert a new row, you find that the

What is the current identity column value in my table? You probably have an identity column defined in some, or a lot of your SQL Server tables.  But

If you compress your database backups you can save a ton of disk space. But by default compressed backups are not created. In order to create a compress