February 8, 2012 at 1:03 pm
How do i drop and Recreate indexes during ETL?
February 8, 2012 at 1:25 pm
perhaps if you can explain what your ETL process is doing, we can then provide some advice.
there are many ways to perform "ETL".
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2012 at 3:13 pm
The simplest way is disable the index and then enable it with ALTER INDEX REBUILD.
-- Gianluca Sartori
February 8, 2012 at 3:15 pm
Is your etl performed through stored procs or is it done through SSIS or something else?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply