Click here to monitor SSC

Author Profile

Dmitri Korotkevitch

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:

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

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...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.