Viewing 15 posts - 31 through 45 (of 47 total)
:ermm: Another question somebody should proofread before posting :sick:
Unique constraint seemed false to me at a glance :unsure: so I searched a bit and found the same article that is...
February 20, 2012 at 7:23 am
honza.mf (2/1/2012)
I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.
😎 Got the same idea while choosing answer.
February 1, 2012 at 1:32 am
Hugo Kornelis (1/31/2012)
"Is this a question about the official rules and limitations, or about workarounds?" -- I guessed wrong. :crying:
As the question is worded it seems about the...
January 31, 2012 at 2:28 am
Tom.Thomson (8/10/2011)
unambiguous question
Oh, what is a normal backup :ermm: a backup before TDE was enabled or backup following standard procedure :blush:
August 11, 2011 at 1:36 am
This is just a fowl joke :doze:
How many rows are returned
None as there is no Select as the code is given. There is no correct answer (0 is not an...
July 27, 2011 at 4:46 am
This post from yesterday's QOTD comes even more appropriate :Whistling:
Carlton Leach (6/28/2011)
Have you been drinking Steve? :hehe:
Christian Buettner-167247 (6/28/2011)
Only the Answer & Explanation of this QOTD are paradox.
:w00t::hehe::Wow:
June 29, 2011 at 12:39 am
Also Grant in "SQL Server 2008 Query Performance Tuning Distilled"
Great explanation:
Execution context is another data structure that maintains the variable part of the query.
June 28, 2011 at 1:40 am
I have to disagree with explanation :crazy:
I looked up before answering and I found:
Query plans are read-only reentrant structures that are shared by multiple users.
The explanation is about execution...
June 28, 2011 at 1:22 am
Shocked again :sick: total mismatch between question and answer :exclamationmark:
April 8, 2011 at 12:10 am
Carlo Romagnano (12/6/2010)
dawryn (12/6/2010)
How can result have more rows than number of inserted rows :blush:
The INSERT SCRIPT should be executed twice: one with ANSI_PADDING option set to ON and another...
December 6, 2010 at 4:51 am
How can result have more rows than number of inserted rows :blush:
December 6, 2010 at 2:17 am
Question is not precise enough :exclamationmark:
Answer depends on model database for first files, next files get size of 1MB ➡ Books Online http://msdn.microsoft.com/en-us/library/ms176061.aspx
When size is not supplied for the primary...
January 21, 2010 at 1:22 am
Another QoD turned sour
And it will be covered with educational purposes :Whistling:
November 26, 2009 at 4:54 am
vk-kirov... That link contains nothing about jobs and SQL Server Agents and should be corrected.
Done (it was under first result)
November 26, 2009 at 4:13 am
I can't see anything about jobs there. The link seems to be not relevant to the question.
What is the use of a job if there is no service to be...
November 26, 2009 at 2:35 am
Viewing 15 posts - 31 through 45 (of 47 total)