Bart Duncan's SQL Weblog
We have a database here that stores information about Azure SQLDB health issues; it was chugging...
Date: 02/08/2018
This post discusses “row goals“, but with a twist. The point is to illustrate how row goals can...
Date: 03/14/2012
There are a fair number of blog posts and forum discussions regarding expression short circuiting in...
Date: 03/03/2011
We recently had a situation where we needed to interface with an external non-relational data source...
Date: 01/06/2011
Some time ago I described the query fingerprint and query plan fingerprint (a.k.a. query hash /...
Date: 11/03/2010
(The title of this post might seem a little inflammatory, but it’s not just a troll -- I...
Date: 08/25/2010
Recently, I was asked whether Microsoft had any SQL Server hardware sizing tools. The asker referred...
Date: 06/16/2010
This post is about deleting a lot of rows, as you might do in a data archiving or purging task. By...
Date: 06/01/2010
Explicitly parameterizing queries is a well-known best-practice for database app developers. There...
Date: 05/26/2010
Programmers should naturally gravitate toward the simplest, most elegant solution. This is because...
Date: 05/03/2009
I've received a couple of questions in email and in comments about deadlocks involving...
Date: 09/24/2008
Policy Based Management (PBM) is a new feature in SQL Server 2008 that allows you to define a set of...
Date: 09/11/2008
In versions of SQL Server before SQL Server 2008, it can be difficult to determine the cumulative...
Date: 09/03/2008
This isn't perf-related like most of my earlier posts, but I thought it was useful enough that I...
Date: 07/25/2007
Did you know that your SQL Server is keeping track of the indexes that it thinks you should create?...
Date: 07/19/2007
Here’s an example of the classic scenario that is usually used to introduce the concept of a...
Date: 09/25/2006
In this post I’ll look at an actual deadlock, then troubleshoot it using the steps I described in...
Date: 09/12/2006
CraigFr has a great series of posts in his blog describing the difference between the various...
Date: 08/16/2006
Sometime we get complaints that a query is slower than it could be because a filter isn’t pushed...
Date: 08/14/2006
Here's another case where you might see intermittently poor performance that is "by design". Suppose...
Date: 07/27/2006
To set up this scenario, run the script below: USE tempdbGOIF OBJECT_ID ('test1') IS NOT NULL DROP...
Date: 07/25/2006
Everyone that has worked with databases for long enough has run into situations where the query...
Date: 07/25/2006