Optimizing partition split when the partition is not empty

Published Jan 15 2019 03:13 PM 85 Views
Microsoft
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?
http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/08/13/oops-i-forgot-to-leave-an-empty-sql-ta...

Venu Cherukupalli - SQL Support Escalation Services
https://twitter.com/cherku

%3CLINGO-SUB%20id%3D%22lingo-sub-317781%22%20slang%3D%22en-US%22%3EOptimizing%20partition%20split%20when%20the%20partition%20is%20not%20empty%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-317781%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Aug%2013%2C%202013%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20Some%20of%20our%20Field%20Engineers%2C%20Kal%20Yella%20and%20Denzil%20Ribeiro%20(%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FDenzilRibeiro%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%40DenzilRibeiro%20%3C%2FA%3E%20)%20have%20posted%20a%20blog%20that%20discusses%20how%20to%20optimize%20adding%20a%20partition%20when%20either%20the%20right%20most%2C%20or%20left%20most%20partition%20is%20not%20empty..%26nbsp%3B%20It%20is%20well%20worth%20the%20read%2C%20so%20we%20are%20posting%20it%20on%20PSSSQL%20to%20help%20get%20it%20out%20there.%3CBLOCKQUOTE%3E%0A%20%20%20%3CP%3EOops%E2%80%A6%20I%20forgot%20to%20leave%20an%20empty%20SQL%20table%20partition%2C%20how%20can%20I%20split%20it%20with%20minimal%20IO%20impact%3F%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fsql_pfe_blog%2Farchive%2F2013%2F08%2F13%2Foops-i-forgot-to-leave-an-empty-sql-table-partition-how-can-i-split-it-with-minimal-io-impact.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Fsql_pfe_blog%2Farchive%2F2013%2F08%2F13%2Foops-i-forgot-to-leave-an-empty-sql-table-partition-how-can-i-split-it-with-minimal-io-impact.aspx%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3C%2FBLOCKQUOTE%3E%0A%20%20%3CP%3EVenu%20Cherukupalli%20-%20SQL%20Support%20Escalation%20Services%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fcherku%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20https%3A%2F%2Ftwitter.com%2Fcherku%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-317781%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Aug%2013%2C%202013%20Some%20of%20our%20Field%20Engineers%2C%20Kal%20Yella%20and%20Denzil%20Ribeiro%20(%40DenzilRibeiro)%20have%20posted%20a%20blog%20that%20discusses%20how%20to%20optimize%20adding%20a%20partition%20when%20either%20the%20right%20most%2C%20or%20left%20most%20partition%20is%20not%20empty.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-317781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EStorage%20Engine%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 03:13 PM
Updated by: