Viewing 15 posts - 391 through 405 (of 552 total)
honza.mf (3/11/2013)
wolfkillj (3/11/2013)
March 11, 2013 at 10:37 am
Thank you for the question. I got it right as I knew this. 🙂
(and I was expecting to see this "2050-01-27" as one of the answers for value-2)
March 11, 2013 at 3:27 am
well....i did it again......
knowing the declaration without the size will default to 1 and at the time of cast/convert it defaults to 30.... and... me being dumbest of all the...
March 6, 2013 at 12:22 am
Awesome put. Thank for posting very neatly.
(i kind of had a catch that after disabling and the next statement it rebuilds.... so i assumed it might activate the index again......
March 5, 2013 at 4:59 am
ashwani24 (2/28/2013)
I guess answer is Yes as it compiled and executed successfully but sql server restricts for nested looping to 32 level so it fails after execution of 32 times.
no...
March 1, 2013 at 1:09 am
p.govindaraj (3/1/2013)
Yes, It will create infinite loop but it will end with maximum nesting level on 32
No it is not infinite loop, as you said it executes 32 times -...
March 1, 2013 at 1:05 am
Simply nice, thank you for posting.
got it wrong, i selected "yes", i cancelled the page transaction but it was too late... the answer got submitted.
and couple of concerns
1. The batch...
March 1, 2013 at 12:52 am
demonfox (2/28/2013)
yes.. and I think , it would be same as this one
...also significant improvement on the EP.
February 28, 2013 at 12:29 am
Good one. :), thank you for posting. (very cute logic...)
i manually iterated the update in mind and 5 OK, 6 OK 7 OK and then for last entry 4 i...
February 27, 2013 at 11:08 pm
L' Eomot Inversé (2/27/2013)
However, the default isn't Latin1_General_CI_AI, it's case insensitive. But it's accent sensitive - CI_AS
actually... mine does. I am using the below version
Microsoft SQL Server...
February 27, 2013 at 7:46 am
demonfox (2/27/2013)
Kingston Dhasian (2/26/2013)
handkot (2/26/2013)
the answer is ambiguous and depends from collationsI agree somewhat
The answers will change if the database collation is case sensitive
But, overall a very good question.
Well, I...
February 27, 2013 at 1:13 am
Very interesting question, did not know until now... and I answered all correct with just mental work 🙂 and I can feel my confidence is somewhat kicking in back..
(note :...
February 27, 2013 at 1:03 am
Dineshbabu (2/21/2013)
February 21, 2013 at 3:28 am
demonfox (2/18/2013)
zerko (2/18/2013)
February 19, 2013 at 12:54 am
Interesting question, thank you for posting.
Did not tried this before, so had really no idea , but bit search on offline BOL, was able to guess that opt-3 may be...
February 18, 2013 at 3:28 am
Viewing 15 posts - 391 through 405 (of 552 total)