Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided that it is only necessary to process some data under a certain condition. By way of example, something like this : Create...(read more)
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,395 reads
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-15
3,713 reads
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
2010-03-10
2,763 reads
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
2001-06-19
2,670 reads
This article by Neil Boyle examines techniques for speeding up your queries by writing better T-SQL.
2001-06-07
13,584 reads
