Excellence in SQL Server

There are a number of queries widely available that will look at the DMVs and tell you what indexes you may be missing. This is a great...

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose...

I was asked the other day was there any way to improve the performance of a large number of rows being inserted. My immediate thought was...

Recently we were asked to build a SQL Server cluster. My initial thought was to use some other technology to provide high availability...

We are currently working on a project to do a major data update on a manufacturing database to update client and product codes in...

Whilst debugging a slow query recently and went through the usual suspects. There were indexes on join columns, all the table joins were...

Whilst recently reviewing performance issues on a large legal system, I noticed that every non-clustered index, explicitly included the...