Archives: January 2011
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,…
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
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