November 2010 - Posts

Gone in 60 nano seconds – The presentation

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.

Posted by GrumpyOldDBA with no comments