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.
"Change is inevitable... change for the better is not".
"If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)