Viewing 15 posts - 2,071 through 2,085 (of 7,483 total)
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...
Tom
November 22, 2014 at 1:55 am
Stewart "Arturius" Campbell (11/21/2014)
Sean Lange (11/21/2014)
Tom
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,...
Tom
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.
Tom
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
Tom
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...
Tom
November 19, 2014 at 7:16 am
SQLRNNR (11/18/2014)
The correct answers listed are only for trace...
Tom
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...
Tom
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. ...
Tom
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...
Tom
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...
Tom
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.
Tom
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...
Tom
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...
Tom
November 6, 2014 at 1:48 pm
Koen Verbeeck (11/6/2014)
TomThomson (11/6/2014)
It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly?...
Tom
November 6, 2014 at 1:40 pm
Viewing 15 posts - 2,071 through 2,085 (of 7,483 total)