Viewing 15 posts - 5,326 through 5,340 (of 59,068 total)
Oops (again). Thank you Jeff. I updated the answer with before/after 2017.
Heh... thanks for the feedback, Steve. The reason I'm so very familiar with this one is that...
April 24, 2021 at 11:04 pm
But my question is do we have a better approach to avoid deadlocks?
You bet there is. But, we can't help because we don't know what criteria you're using...
April 24, 2021 at 10:59 pm
From the Article:
"The startup flags (1117 and 1118) recommended for tempdb are no longer needed as that functionality is now baked in."
Yeah... that little "trick" of theirs killed some...
April 24, 2021 at 10:45 pm
If you look at the original 5 year old post on this thread, the OP didn't include the actual command they used. It could have been a spelling error in...
April 24, 2021 at 10:03 pm
Yes, no STRING_AGG in 2012. We're in the 2016 Forum 🙂 To revert you could use STUFF+XML instead of STRING_AGG.
Doesn't matter if it is a 2016 forum... I'm...
April 24, 2021 at 9:49 pm
You can ab
I considered submitting a request asking for a way to suppress the dark mode request.
I actually have to use DATEDIFF_BIG. The fact they couldn't be bothered...
April 22, 2021 at 7:57 pm
The Postgres function is the one that I remember the best. I've not tested it for performance because I've never had to work on a Postgres DB. Oddly enough, I...
April 22, 2021 at 2:56 pm
Ken McKelvey wrote:You might be interested in an interesting series of articles by Itzik Ben-Gan:
https://sqlperformance.com/2021/04/t-sql-queries/number-series-solutions-4
Ken, Thank you for posting this link.
I was involved in that series for...
April 22, 2021 at 2:28 pm
Note that Microsoft is preparing to switch, yet again, to a different feedback system.
Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021...
April 22, 2021 at 2:03 pm
I use this function with recursion and @top of 1000000 is enough for me, but I don't n know if it performs better:
-- by Carlo.Romagnano CREATE FUNCTION dbo.fn_tally(@top...
April 22, 2021 at 1:44 pm
Personally, I like the 5th option, which wasn't included... Run the two versions of the same query in the same window and compare the execution plans that show.
April 22, 2021 at 2:40 am
I know this is an old post but I just ran across it again while looking for something else. Probably doesn't make any difference to anyone anymore but...
Going through it...
April 21, 2021 at 11:11 pm
Heh... I agree with Grant on logical execution being left to right and data flow being right to left and both being top to bottom (except on super-umbra-red moons on...
April 21, 2021 at 2:34 pm
Yep. Without the rest of the error message, I can't even hazard a guess. Jeff is probably right (says Grant all the time).
Thanks, Grant. I'm humbled but I'm...
April 21, 2021 at 2:21 pm
Don't you have access to the rest of the failure message from the SQL Server Error Log?
If I had to guess from the truncated message above, I'd say you may...
April 21, 2021 at 1:14 am
Viewing 15 posts - 5,326 through 5,340 (of 59,068 total)