SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Great Post on Clearing all data from your Data Warehouse

Hey there Gang !


 Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting since Jamie is always a great source for SSIS and BI info. I wanted to share a post of his that provides a script method for clearing your DW while leaving the foreign keys intact. This is a great option when you need to debug or are working in development mode to test load speeds, etc..


Check it out here - http://sqlblog.com/blogs/jamie_thomson/archive/2009/09/08/deriving-a-list-of-tables-in-dependency-order.aspx

Keep up the good work Jamie ! 


Posted by Jamie Thomson on 9 September 2009

Thanks Adam, I appreciate the link :)

Posted by knight_devin@hotmail.com on 9 September 2009

Great post Jamie/Adam.  I look forward to trying it out.

Leave a Comment

Please register or log in to leave a comment.