Viewing 15 posts - 31 through 45 (of 1,583 total)
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!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 2, 2017 at 6:45 am
Perry, yes this is a database in full recovery
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 13, 2017 at 9:56 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 11, 2017 at 1:57 pm
It returns the correct names...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 11, 2017 at 1:51 pm
@ 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 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 23, 2017 at 5:58 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2016 at 11:04 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2016 at 8:36 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2016 at 7:29 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 19, 2016 at 10:09 am
Excellent points; sincerely appreciate you both for taking the time to clarify things.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 18, 2016 at 7:58 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 17, 2016 at 9:14 am
Hey Jeff - care to share your job script for the stats?
😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 17, 2016 at 12:05 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 16, 2016 at 11:57 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 16, 2016 at 9:13 am
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)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 27, 2016 at 5:08 pm
Viewing 15 posts - 31 through 45 (of 1,583 total)