Partitioning with SQL Server
Speaker: Chad Boyd
Partitioned tables and indexes help improve the scalability and manageability of very large SQL Server databases. In this session, we will take a look at the table and index partitioning capabilities in SQL Server 2005/2008. The discussion will outline the features and benefits of partitioning, explain how it works, and illustrate how to implement and set up this feature. We'll review scenarios for the sliding window, index/table maintanenence, when partitioning helps (and when it hurts), and discuss some potential myths that may exist, then touch on improvements and new enhancments in SQL Server 2008.