SQLBits 2011

Parallel Plans

The talk will go back to SQL Server 7.0 when we have introduced “parallel query” in SQL Server for the first time. Lubor will share our initial “parallelism” challenges and how this feature has been developing through the subsequent releases
The talk will go back to SQL Server 7.0 when we have introduced “parallel query” in SQL Server for the first time. Lubor will share our initial “parallelism” challenges and how this feature has been developing through the subsequent releases. The newest version SQL Server 11 (codename “Denali”) continues this trend and you will learn how new type of parallel plans combined with column store will speed up your query execution by orders of magnitude. You will learn for example what Parallel Page Supplier is, what types of Exchange Operators we use and how to find out if your parallel query is “unbalanced