pdanes (8/24/2016)
BLOB_EATER (8/24/2016)
For me partitioning is about manageability first and performance second.Your MDF is 500MB with 8 years growth? I'm not so sure you need to go down this route... don't forget you need enterprise edition too.
Aha, thanks. That settles it - I don't have Enterprise edition.
I was more thinking in terms of learning something potentially useful, and maybe getting some performance benefit in the process. But this is completely manageable as a whole, so I guess there would be little point in it even if I did have the Enterprise version.
Appreciate the input.
Don't give up on the learning aspect of things, though. If you don't have one already, grab a copy of Developer Edition (same features as Enterprise) and if your employer approves, set it up on your work PC and grab a copy of your database to use for testing. Putter around with setting up partitioning against it to get a sense of what's involved, grab queries that are run against your production DB and run them against your sample (both pre- and post-partitioned) and see what impact that has on query plans and such.
Never stop learning!
😀