Welcome to MSDN Blogs Sign in | Join | Help

November 2006 - Posts

Monday, November 27, 2006 11:56 AM

Introduction to Partitioned Tables

In this post, I’m going to take a look at how query plans involving partitioned tables work. Note that there is a big difference between partitioned tables (available only in SQL Server 2005) and partitioned views (available both in SQL Server 2000 and
Posted by craigfr | 1 Comments
Thursday, November 16, 2006 8:08 PM

Parallel Hash Join

SQL Server uses one of two different strategies to parallelize a hash join . The more common strategy uses hash partitioning. In some cases, we use broadcast partitioning; this strategy is often called a “broadcast hash join.” Hash Partitioning The more
Posted by craigfr | 0 Comments
Filed under: ,
Wednesday, November 08, 2006 7:04 PM

Parallel Nested Loops Join

SQL Server parallelizes a nested loops join by distributing the outer rows (i.e., the rows from the first input) randomly among the nested loops threads. For example, if we have two threads running a nested loops join, we send about half of the rows to
Posted by craigfr | 3 Comments
Filed under: ,
Wednesday, November 01, 2006 9:16 PM

Parallel Scan

In this post, I’m going to take a look at how SQL Server parallelizes scans. The scan operator is one of the few operators that is parallel “aware.” Most operators neither need to know nor care whether they are executing in parallel; the scan is an exception.
Posted by craigfr | 3 Comments
 
Page view tracker