When partitioning was first introduced in SQL Server 2005, I thought what a great idea. However, when I started reading Books Online I thought, this is going to be a big Pain in the you know what. After reading Kimberly’s article, Partitioned Tables and Indexes, I was convinced of how easy it would be to implement Partitioning and how it would help manage and maintain Very Large Databases, specifically warehouses. The article is a little dated, but if you have any questions about Partitioning from a management and maintainability stand point this article is a must read. She discusses topics that include, planning, defining, steps to create, etc… This article should definitely help jump start your design and implementation of partitioning in your SQL Server environment.
To read the article in its entirety click here.
Talk to you soon