Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Article of the Week – Kimberly L. Tripp (Partitioned Tables and Indexes)

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

Patrick LeBlanc, Founder www.tsqlscripts.com and www.sqllunch.com

Comments

Posted by Anonymous on 17 November 2009

Pingback from  Dew Drop – November 17, 2009 | Alvin Ashcraft's Morning Dew

Posted by Anonymous on 17 November 2009

Pingback from  Dew Drop – November 17, 2009 | Alvin Ashcraft's Morning Dew

Leave a Comment

Please register or log in to leave a comment.