Viewing 15 posts - 1 through 15 (of 54 total)
Just work on the code
The issue with this seemingly trivial piece of advice is that we have no idea at this point what sacrifices to the god of SQL2019 we...
May 24, 2023 at 3:01 pm
Ah nice I've used LAG so infrequently that I wasn't aware of that one. Thanks
May 24, 2023 at 1:40 pm
declare @torig table (custid int, employeecount int, datadate date)
insert into @torig values
(1, 10, '1-Jan-2023'), -- 21
(1, 11, '1-Jan-2023'),
(2, 11, '1-Jan-2023'),
(1, 15, '2-Jan-2023'), -- 28
(1, 11, '2-Jan-2023'),
(1, 2,...
May 23, 2023 at 3:11 pm
Even if she already had permission in her own right though via an additional GRANT to Sallydev, it would still do nothing and answer 2 would still not be true...
October 10, 2019 at 4:33 pm
Stewart "Arturius" Campbell (8/17/2016)
However, i noticed a slight inconsistency in the explanation, viz. When a NULL is inserted as a seventh row, Query 2 still returns 6...
August 23, 2016 at 9:51 am
Ah OK so I take it the question is still wrong and I haven't just lost my mind... As it's written now the "correct" answer is 1.7 but there is...
August 23, 2016 at 9:47 am
Hi Nakul, thanks for the reply.
You've confirmed my understanding of sp_configure which I then think means it would be worth a clarification in your article in the section headed...
August 23, 2016 at 4:25 am
I'm confused by the use of sp_configure and I can't find a clear source anywhere to explain it. If the "user options" is made up of a bitmap of options...
August 23, 2016 at 3:02 am
ScottPletcher (11/12/2015)
Explicitly set it ON immediately before DELETE/INSERT/UPDATE statements and OFF immediately afterward?
You would think that would work, but at the same time you'd think that doing it at the...
November 13, 2015 at 2:48 am
Yep - unable to see the article due to a redirect loop.
October 20, 2014 at 3:31 am
Though technically the answer is "it depends on the initial setting of SET ANSI NULLS..." 😛
June 6, 2013 at 1:52 am
Darn it I counted the 4's wrong after having a lightbulb moment about what 'With Ties' does. As I clicked the answer I knew it was wrong because it was...
June 4, 2013 at 7:14 am
Richard Warr (4/29/2013)
baabhu (4/29/2013)
Want my points back. The answer is those hints can be used either with "with" hint or without the with hint. My points back.
You get a point...
April 29, 2013 at 5:06 am
Grant Fritchey (2/6/2013)
I won't say bad things about the competition, but be sure you do a VERY thorough evaluation of the Quest/Dell offerings. Just saying.
Noted, thanks 🙂
February 6, 2013 at 8:15 am
Grant Fritchey (2/6/2013)
SQL Sentry
Confio Ignite
Our software is a good choice for general monitoring, up-time, guidance on performance problems, historical information tracking & custom metrics and...
February 6, 2013 at 6:30 am
Viewing 15 posts - 1 through 15 (of 54 total)