Microsoft put a great deal of effort into SQL Server 2005 and 2008 to ensure that that the platform it is a real Enterprise class product. I’m not going to write about all the new features in the OLTP Engine, in this article I will focus on Database Partitioning and provide a real world scenario. This article will cover the following points:
I. Benefits and Limitations of Partitioning (HEAPS/CLUSTERED/NONCLUSTERED). II. Implementation Methodology.