Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Scans and Seeks » Partitioned Tables   (RSS)
Sorry, but there are no more tags available to filter with.
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 | 6 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