March 12, 2009
SQL 2005 Clustering
Posted by: Delamater : Category: White Papers
March 03, 2009
Using UPDATE STATISTICS To Predict Query Behavior
Posted by: Delamater : Category: SQL Server Performance Tuning
While doing some research recently, I came by this article that really got me thinking, could this really work? It is one thing to fool the optimizer, but it is another thing to see it in production. Either way, this article is so interesting, I recommend you read it. I’m keeping a copy of the test code down below just to keep on file. One thing I recommend you do is use STATISTICS XML ON, or you can also just use the graphical execution plan as well.
