OK so the title might not be very specific so I'm sure I'm breaking some rule about how to be a “successful” author… but if I can get a bunch of people on April Fool's Day “Rickrolled” I'm hoping enough people will read on. In SQL there are so many ways to solve the same [...]
Posts Tagged ‘index’
Update Statistics Before or After an Index Rebuild?
So a Twitter friend of mine @peschkaj tweeted this morning: “Just finished adding scripts to update stats and rebuild indexes after our nightly and weekly loads. Now on to… something else.” So I asked the question: “now the question is… did you update stats BEFORE or AFTER the index rebuild? ” He replied with the [...]
