Viewing 15 posts - 2,071 through 2,085 (of 7,484 total)
Lynn Pettis (11/22/2014)
Jeff Moden (11/22/2014)
David Burrows (11/21/2014)
Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀
Heh... I've reached the "Overflow Exception" a couple...
November 22, 2014 at 2:38 am
h.tobisch (11/21/2014)
Just understood:a nonclustered index may be the same size but never larger than a clustered index, so, if it covers the data the nonclustered index will be first choice.
I...
November 22, 2014 at 1:55 am
Stewart "Arturius" Campbell (11/21/2014)
Sean Lange (11/21/2014)
November 22, 2014 at 1:43 am
DonlSimpson (11/20/2014)
Koen Verbeeck (11/20/2014)
I'd argue ROWCOUNT_BIG is an odd one as well, as it is not calculated over the current result set, but over the results of a previous query.
+1
Also,...
November 20, 2014 at 12:20 pm
A nice fun question, required a bit of careful thought to get it right but not really difficult if one remembers that the scope of a UDT is the database.
November 20, 2014 at 11:44 am
Ed Wagner (11/19/2014)
crookj (11/19/2014)
Ed Wagner (11/19/2014)
SQLRNNR (11/19/2014)
Ed Wagner (11/19/2014)
sing4you (11/19/2014)
SQLRNNR (11/19/2014)
crookj (11/19/2014)
Ed Wagner (11/19/2014)
BWFC (11/19/2014)
SQLRNNR (11/18/2014)
dissociativefugue
Memory
Drain
O
The Story of ...
Life
of Pie (hint, it gets baked and then eaten) :-D:-D:-D:-D
Apple
fritter
Fry
Christopher
November 19, 2014 at 2:49 pm
Gary Varga (11/18/2014)
budbeth (11/17/2014)
United States visited: 47Foreign Countries visited: 3
Almost the opposite for me; acouple more states a few less countries. Perhaps that is a perspective on the whole "Americans...
November 19, 2014 at 7:16 am
SQLRNNR (11/18/2014)
The correct answers listed are only for trace...
November 18, 2014 at 2:10 pm
What a poor question and answer! The question should specify which edition it is asking about when it is a question which has different answers for different editions.
The recommended...
November 17, 2014 at 7:47 am
Sergei Yakovlev (11/10/2014)
What about ADMINISTER BULK OPERATIONS?
I'd like to know the answer to that too. As far as I can see, CREATE and ADMINISTER work with similar syntax. ...
November 13, 2014 at 8:25 am
Nice question (now that the duplicate answer problem has been fixed).
But I really hate the explanation. It refers to textual order as logical order, contradicting itself since it has already...
November 13, 2014 at 8:11 am
Basically a good and interesting question, but Steffen Mantz-204830's point is a valid criticism. I don't think that the omission of ID from the select list would lead anyone...
November 13, 2014 at 5:14 am
Nice clear question.
The proportion of wrong anwers suggests that security still isn't an important part of the job for most DBAs, which is a pity.
November 13, 2014 at 5:04 am
I agree with what Grant says, but there's an additional point that may apply here. Suppose you don't make the primary ke the identity column, but make it a...
November 12, 2014 at 3:35 pm
Andy sql (11/6/2014)
and you would be assuming that "ls" is correctly configured as an alias to "Get-ChildItem". Maybe only 99.994% correct.
Touché! But of course the assumption is that the...
November 6, 2014 at 1:48 pm
Viewing 15 posts - 2,071 through 2,085 (of 7,484 total)