Optimizing partition split when the partition is not empty
Published Jan 15 2019 03:13 PM 188 Views
First published on MSDN on Aug 13, 2013
Some of our Field Engineers, Kal Yella and Denzil Ribeiro ( @DenzilRibeiro ) have posted a blog that discusses how to optimize adding a partition when either the right most, or left most partition is not empty..  It is well worth the read, so we are posting it on PSSSQL to help get it out there.

Oops… I forgot to leave an empty SQL table partition, how can I split it with minimal IO impact?

Venu Cherukupalli - SQL Support Escalation Services

Version history
Last update:
‎Jan 15 2019 03:13 PM
Updated by: