This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan caching...

In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download the materials from my...

If your database needs a complete index overhaul, you can do it automatically. This useful script rebuilds or reorganizes indexes...

When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you...

Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many...

This query stats script returns aggregated statistics information for every query statement in the cached plan. Use it to get details on...

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course...

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course...

This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a very important...

A short while ago, I was asked to create a certain report with a “Windows File Share” subscription. The client wanted the file to be...