Viewing 15 posts - 91 through 105 (of 149 total)
The right answer isn't the right one? The selects give 2 and 0 rows back. Arghhh..
October 5, 2012 at 2:44 am
I guessed and won. I thought, SQL Server stores the compression flag in the header and not at the data part of the backup. And as the header remains, the...
September 17, 2012 at 1:30 am
Where are the variable definitions? I can see only the inserts (Chrome) :w00t:
August 23, 2012 at 12:41 am
I hate questions with missleading title. :angry:
August 7, 2012 at 12:36 am
I'm not agree with the "right" answer. I can revert to any undamaged snapshot:
Step 1: delete all other snapshot
Step 2: revert to the selected
The answer would be right only with...
July 19, 2012 at 2:26 am
imarran (6/26/2012)
badly formed answersyou are selecting 4 columns in your question (ID, Y, Test1, Test2) yet your answers and the supposed "correct" one only has 3
Say, not optimal, but if...
June 26, 2012 at 12:46 am
BOL: Indexes cannot be created explicitly on table variables, and no statistics are kept on table variables. In some cases, performance may improve by using temporary tables instead, which support...
June 25, 2012 at 12:39 am
The subquery in the update confused me. I would use a "case when else" statement instead. It is longer, but for me better readable.
June 22, 2012 at 2:53 am
A very good question, even if i missed it. 😛
I thought, if the LEN delivers 1, then the LIKE makes the same. For me a bit inconsistent, but good to...
May 9, 2012 at 12:44 am
Viewing 15 posts - 91 through 105 (of 149 total)