The Evil Query
Many DBA's have seen a query from hell where a mulit-million row fact table is joined to its major dimensions. One approach is to throw hardware at the problem, and this is exactly what we discuss in this video with Henk van der Valk from Unisys Holland. He's got SQL Server 2008 R2 running on a server with 96 cores and is responsible for setting many of the scalability records that you may have seen for SQL Server.
With his latest equipment and SQL Server 2008 R2 he can get a 72 hour query to execute in 25 seconds!
Published Date: December 09, 2009
Presented By: Andrew Fryer