Viewing 15 posts - 1 through 15 (of 831 total)
Toni-256719 (9/22/2016)If the correct answer is 24 logical processors, the newsletter is incorrect.
Imagine that, you'd think they'd have corrected the e-mail they'd already sent out when they corrected the question...
September 22, 2016 at 5:52 am
Although incorrect, the answer does highlight an interesting difference between a virtual machine and a physical machine where it comes to logical CPU usage which I never knew about, so...
September 21, 2016 at 5:30 am
I do wonder why the limit is set at that. Is it just an arbitrary number Microsoft plucked from the air, or is there an actual reason for it?
September 16, 2016 at 1:12 am
Yeah, I think the answer depends on what the hire date of Employee 2 in the database is, and since we don't know that (the question doesn't specify) then either...
September 15, 2016 at 3:07 am
Hugo Kornelis (9/12/2016)
That isn't actually what you *said*, though? You said that a (well written) cursor will never, ever beat a WHILE loop, which implies the WHILE is faster?
September 12, 2016 at 8:08 am
dbishop (9/9/2016)built a recursive CTE off the final temp table then use a WHILE loop against the final result, but really! Just to avoid using a cursor?
A WHILE loop is...
September 9, 2016 at 8:07 am
September 6, 2016 at 7:46 am
Got it wrong--read the examples in the AT TIME ZONE article and noticed they were returning the same time, but a different datetime offset, so assumed the same would happen...
September 6, 2016 at 2:40 am
Mikael Eriksson SE (8/25/2016)If you let this run for a while you will eventually get 1 row back from the query.
Mikael Eriksson SE (8/25/2016)
Yeah, I was going to say that ought to be...
August 26, 2016 at 2:01 am
Got the wrong answer, but that's because I pretty much clicked at random...I wanted to know the actual answer and my Google-fu failed me in finding it. Odd that functionality...
August 24, 2016 at 2:27 am
Nakul Vachhrajani (8/16/2016)A datetime allows the time component to be 23:59:59.
Nakul Vachhrajani (8/16/2016)
But it also allows the date component to be up to 9999-12-31, so none of the answers would be correct...
August 17, 2016 at 3:09 am
Got it wrong because I didn't realise SQL didn't enforce foreign keys on temp tables, so I learned something. Bit more information would have been nice, though, as said above.
August 2, 2016 at 2:57 am
D'oh, I must be blind...completely failed to notice the column in the view was called Qty while the SELECT was querying against OrderQty. :crying:
June 9, 2016 at 2:50 am
Terje Hermanseter (6/6/2016)
June 6, 2016 at 2:00 am
Brandie Tarvin (5/25/2016)So now I need to get with the server admin and see if a CNAME record depends on a specific port associated with an IP address or not.
Brandie Tarvin (5/25/2016)
So now I need to get with the server admin and see if a CNAME record depends on a specific port associated with an IP address or not.
May 26, 2016 at 2:50 am