Viewing 15 posts - 166 through 180 (of 208 total)
Thanks for the question. Couldn't get it right even with researching it!
August 30, 2012 at 7:39 am
churlbut (8/29/2012)
Never used sparse columns in my SQL experience, do any developers here use them frequently?
I have never used them and am not sure I understand their true applicability.
August 30, 2012 at 4:44 am
This was a great question. Had to do a lot of research, since I was not familiar with SPARSE, to get this one right.
August 29, 2012 at 6:10 am
Great question Lokesh. And thanks to Hugo and others for additional education on the subject.
August 28, 2012 at 4:28 am
Hugo Kornelis (8/27/2012)
After reading this, I tested it for myself on my SQL 2012. I ensured no table named table1 or table2 exists, then executed this batch:
Part of the question...
August 27, 2012 at 4:37 am
Nice clear question. Good start to the week.
August 27, 2012 at 4:15 am
Good question. Knew three of the choices, had to guess at cb-3 but got it right. Fridays are great!
August 24, 2012 at 4:35 am
Looks like about a third of us answered before coffee and failed to take into account the first one started with value 0.
August 23, 2012 at 4:22 am
Lokesh Vij (8/22/2012)
Overlooked the question: Inserts start from 0 that makes the first statement to exceed this...
August 23, 2012 at 4:17 am
Not familiar with SPN but the question got me to look it up. Thanks.
August 22, 2012 at 4:17 am
Try this one: SELECT 1+'130'+'120'+1. It comes up 252! Implicit conversion are very dangerous.
August 21, 2012 at 9:31 am
Got it right so I'm not complaining but I agree that there is room for error if there were other choices for the answer.
August 20, 2012 at 11:42 am
I agree. Not a good QotD. This should bring lots of discussion though and is very educational.
August 17, 2012 at 5:32 am
Viewing 15 posts - 166 through 180 (of 208 total)