Subscribe to this blog
Archives: January 2011
Upcoming presentations
It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up for the first quarter of the year.
- On the 10th February I’m presenting on database corruption for Quest’s Pain of the Week webcast. I’m not Paul Randal,…
0 comments, 81 reads
Posted in SQL In The Wild on 28 January 2011
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in IN or EXISTS subqueries. The rationale is given either as a performance enhancement or as necessary for correct results.
Is it necessary or useful? Only one way to find… Read more
7 comments, 644 reads
Posted in SQL In The Wild on 18 January 2011
Capturing the Execution Plan
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the display execution plan option of Management Studio is usually adequate, however there are occasions where it’s either not feasible to run the query from Management Studio or the particular… Read more
3 comments, 251 reads
Posted in SQL In The Wild on 4 January 2011