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)

@jacob, thanks as well! I will take a look at this approach as well - much appreciate everyone's help!

This was exactly the case! I can't believe I completely overlooked that...wow I feel like an idiot :hehe:

The developers used UniqueID as the PK because in the table they...

I'm not saying that at all. Check out the original execution plan, looks like it's doing some cartesian product in the portion of code I originally posted.

In the example...