Posts
49
Comments
50
Trackbacks
26
August 2005 Blog Posts
Sql Server 2005 Partitioning - Updating Existing Data
I've put online the second article of the three: you can find it here.
posted @ Thursday, August 25, 2005 8:09 PM | Feedback (0)
Sql Server 2005 Partition Switch Automation Script

As you should have read in the fantastic Kimberly WhitePaper, partioning gives you an incredible opportunity to load data into your table minimizing locking and having the best performace you can imagine.

The only "drawback" is that the SQL code you need to write and the work you need to do to maintain a partitioned solution (in particular if you have to implement a sliding window scenario) in quite a lot, with only few changes (but essential) every time.

No problem anyway! Using some data from sys tables and the new sqlcmd command everything can be automated!

Here you can find three articles (and scripts) to help you in different scenario:

1 - The basics

2 - Updating existing data

3 - Adding new data while removing old one (Sliding Windows) (work in progress...)

Happy partitioning!

posted @ Saturday, August 20, 2005 7:32 PM | Feedback (3)
News