December 26, 2007 at 10:31 am
Hi, I am trying to understand the benefits of partitioning with SS2K5. Specifically, is it helpful when building a data warehouse and refreshing it each night. I am reading about the SWITCH operator and it says that rows can be added and deleted from a table very quickly and without rebuilding indexes. So is partitioning and the SWITCH operator something that can be utilized in an ETL process? Thanks.
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
December 26, 2007 at 10:50 am
Yes, partitioning can easy keep data separated, usually by dates, but could be by other values, and let you add rows to "part" of the table without affecting the other part.
Some info here:
http://www.sqlservercentral.com/articles/Development/3135/
http://www.sqlservercentral.com/articles/Miscellaneous/3242/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply