Viewing 15 posts - 91 through 105 (of 49,571 total)
Aside from needing brackets, you might also want to read this:
https://sqlinthewild.co.za/index.php/2018/03/13/revisiting-catch-all-queries/
That query's going to perform very badly.
October 13, 2018 at 11:49 am
October 13, 2018 at 11:43 am
Awesome timing. I'm busy updating the training for my grads next year and was looking for some quick exercises I could give them as a break from lectures. 'What's wrong...
October 13, 2018 at 10:07 am
Complete lack of normalisation, several questionable data types, lots of names that don't tell me anything (what is dtmDate?), no naming standard making this look like it was 'designed' by...
October 13, 2018 at 9:57 am
MAXDOP 2 limits the query to 2 *running* threads, as does a 2-core server. Why are you worried about the number of non-executing threads?
October 12, 2018 at 1:31 am
Oh, no, that's not a good setting. You've just disabled parallalism server-wide and forced all queries to run single threaded. Having your CPU at 20% is not a good thing,...
October 12, 2018 at 1:28 am
October 10, 2018 at 1:06 pm
The second one is harder to read and takes more typing, and that's about all.
October 9, 2018 at 7:50 am
Min at 0 unless you have a really good reason. Max, server's physical memory - what anything else on the server needs - reservation for the OS.
October 9, 2018 at 7:45 am
Oh there is so much that can be optimised in there.
Table variables - slow, avoid, use temp tables instead.
Multiple execution paths - erratic performance, avoid
Multi-statement table-valued...
October 9, 2018 at 3:39 am
September 28, 2018 at 3:28 am
You still want to run CheckDB on the secondaries.
August 14, 2018 at 4:30 am
August 13, 2018 at 10:08 am
Viewing 15 posts - 91 through 105 (of 49,571 total)