Here’s my working document for the presentation fleshed out with sample code and hopefully containing the majority of what I talked about.
To recap I was talking about dealing with archiving of logged data by using partitioning and removing aged data by using partition switching.
I have the switching and deleting as part of an automated set of scripts to produce cut down databases for non production use where we want to reduce the database size.
I can’t put this document into the blog – it’s too large - so here’s a link to a pdf – enjoy
Any questions about partitioning and my experiences please feel free to mail me and I’ll do my best to answer.