Welsh Corgi (11/24/2015)
ScottPletcher (11/24/2015)
For us, most tables don't really need partitioned. Archiving and partitioned views handles most of them.When I do partition, I align indexes because I want to be able to do partition switches.
So I need to align all indexes?
Please excuse my lack of experience.
Thank you for your guidance.:-)
Well, that would be the best option.
But the world is not quite ideal. 🙂
So, you probably would be better off aligning queries with existing indexing. Something similar to what I indicated in my previous post.
It would be not perfect, but in most cases "close enough".
The only situation which signifies a dead end (at least I don't know a way out without redesigning tables) is a clustered PK over GUID. That is a killer.
_____________
Code for TallyGenerator