Thanks Craig,

it was a good one to throw into wrapper and process couple hundred thousands of record each time.

all the table has VISITOR_ID as the primary key. So there will...

The p0 table is clustered index on VISITOR_ID ASC too.

The Recovery model is Simple. Whole data size is approx close to 301GB

Yes, I need all the data. Because we just...