This is a great overview article. The pictures save a thousand words.
My only disappointment is that code was only provided for one of the 3 scenarios. It would also have been interesting and helpful to have seen what the Partition Scheme and Partition Function looked like as well as what controls were used to limit the Medium to Large partitions to 10M rows.
Also, was any consideration made to making the older partitions Read_Only to save on backup and any index maintenance times?
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)