Dmitri Korotkevitch is a Microsoft SQL Server MVP, MCITP (Database Developer, DBA) and MCPD. He has 16 years of experience in the industry, including more than 10 years working with Microsoft SQL Server. Dmitri specializes in the architecture, design, development and performance tuning of OLTP systems. He blogs at: http://aboutsqlserver.com.
Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.… Read more