Viewing 9 posts - 16 through 24 (of 24 total)
For myself, if I am looking for a new job it's because I've tried and failed to get my current one improved. Any counter offer would therefor be questioned as...
April 3, 2019 at 8:00 am
March 27, 2019 at 4:16 am
March 27, 2019 at 2:36 am
I'm with N.Ryan on this, but will add a spin: You'll need to configure SQL to meet your needs, and test that configuration, so at some point you'll need to...
March 26, 2019 at 5:11 am
If you only check the monitor data when something goes wrong, you're reacting to an issue, not being proactive in managing your servers.
No, you won't catch every instance,...
January 28, 2019 at 5:09 am
December 19, 2018 at 2:03 am
denisock: Yes, ORDER BY 1 is accepted syntax. It's used when you're uncertain of the column names but know you want to order by column 1 in the select list....
December 17, 2018 at 2:02 am
Logically the two operations would be different and give different results. ORDER BY <column> ASC/DESC with TOP (X) may be used to obtain the maximum or minimum value from a...
December 17, 2018 at 1:57 am
Going to take exception to this: The supposed answer is wrong: 'ys.dm_exec_requests' does not exist. It is, as on the previous line 'sys.dm_exec_requests'. Think you have a typo in the...
November 28, 2018 at 1:53 am
Viewing 9 posts - 16 through 24 (of 24 total)