Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Partitioned Tables   (RSS)
Friday, August 22, 2008 3:42 PM

Dynamic Partition Elimination Performance

In this post on partitioned tables, I mentioned that SQL Server 2008 has a much more efficient implementation of dynamic partition elimination as compared to SQL Server 2005. In response, a reader posted this comment asking how much dynamic partition
Posted by craigfr | 1 Comments
Filed under:
Tuesday, August 05, 2008 11:33 AM

Partitioned Indexes in SQL Server 2008

In my last post , I looked at how SQL Server 2008 handles scans on partitioned tables. I explained that SQL Server 2008 treats partitioned tables as tables with a logical index on the partition id column and that SQL Server 2008 implements partition elimination
Posted by craigfr | 1 Comments
Tuesday, July 15, 2008 2:03 PM

Partitioned Tables in SQL Server 2008

In this post , I introduced how SQL Server 2005 implements query plans on partitioned tables. If you've read that post or used partitioned tables, you may recall that SQL Server 2005 uses a constant scan operator to enumerate the list of partition ids
Posted by craigfr | 8 Comments
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
 
Page view tracker