Thanks for the write-up Steve, I’m kind of in the same boat...but I think for me it’s more tnullhat I feel intimidated by that language than anything else!

Perry, yes this is a database in full recovery

Any harm in updating the system tables?

In any case, I will change the code we are using to capture the logical files names to pull from the actualy...

It returns the correct names...

@ Welsh Corgi, did you ever get a solution to your 2014 issue?  I just came across the same problem today...thought i would check here first prior to google 🙂

Hey Phil! Thanks for clarifying and yes I did misunderstood what you were intending. Both methods work and perform about the same - your method omits an extra...

Because in that route, while working with 100+ million rows and doing an insert into a temp table on several hundred columns wouldn't play well with tempdb and I don't...

Thanks for the comments guys (not sure why I'm not being notified about them)...

The table design is horrendous...in fact this is a rather small table 🙂 It's a transaction...

Please do Jeff (reporting back on how it went) - Have a mess of stats on our production reporting server as well and while I've entertained that idea...haven't had the...

Excellent points; sincerely appreciate you both for taking the time to clarify things.

Tables with 140 columns? Ha! :hehe: In one of our databases (NOT my design by the way) we have a few tables that have 1,024 columns (yeah, the maximum...

Hey Jeff - care to share your job script for the stats?

😀

Gotcha, so it would make more sense to run the stats before the index rebuilds...if use a more concentrated/targeted process before the indexing rebuilds even take place...

I've always been a little fuzzy on this one - So, is just executing sp_updatestats a safe bet after indexing? Realizing that rebuilildng indexes will only affect the stats...

Very welcome! Let me know if you find any issues with it

(I don't believe it works on filtered indexes, haven't had a chance to correct that yet)