Welcome to MSDN Blogs Sign in | Join | Help

August 2008 - Posts

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
 
Page view tracker