Table Partitioning in SQL2008(2)
Today I proceeded with partitioning a large table in SQL 2008. The objective is to build a partition function with a sliding window. Usually you use staging tables to get to this. This customer wants to keep all his data in one table so staging tables cannot be used. That's a pity because then we can't use all the new wizards in SQL 2008.
Since I do want to show you what this wizard looks like here's the screenshot:
You can switch in a staging table or switch out to a staging table. Pretty straightforward. It's not really automating things but merely making administration easier.
For automating you still have to create a stored procedure to do your merging and splitting. And a job to execute it regularly.