Viewing 15 posts - 4,141 through 4,155 (of 7,484 total)
Nice easy question (now that the wording has been edited a little).
But sp_who2 is not very useful, and isn't documented anywhere as far as I can tell.
I used sp_who2 ages...
September 21, 2012 at 10:04 am
capnhector (9/21/2012)
ok im breaking out my "Realy? WTF" card on the behaviour twards the end of http://www.sqlservercentral.com/Forums/Topic1357081-392-3.aspx. did we really hit Godwin's law?
Yes, Craig mentioned a certain person (naughty...
September 21, 2012 at 9:37 am
Luis Cazares (8/24/2012)
The design relies on many things and the most common (and correct) answer is "it depends".
That seems to me to be the most anyone could say without...
September 21, 2012 at 6:07 am
Cliff Jones (9/20/2012)
SQLRNNR (9/20/2012)
Nellydeli
belly
September 21, 2012 at 5:54 am
lanre_makinde (9/19/2012)
Sorry the explanation is wrong. Then the question is not properly framed. Questions should be aimed at eliciting understanding....
It appears to me to be right, to...
September 19, 2012 at 4:51 pm
Hugo Kornelis (9/19/2012)
Miles Neale (9/19/2012)
Kind of erodes the confidence in certain uses of the product.
Huh? Why?
SELECT TOP ... without ORDER BY is like saying "give me the first by any...
September 19, 2012 at 4:31 pm
patrickmcginnis59 (9/19/2012)
September 19, 2012 at 1:58 pm
dwain.c (9/18/2012)
L' Eomot Inversé (9/18/2012)
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't....
September 19, 2012 at 4:43 am
I got it wrong. I looked at it, and realised that there are in theory 3 correct answers there: the table will always return no more than 1 row,...
September 19, 2012 at 4:34 am
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't. If I understand...
September 18, 2012 at 1:40 pm
dglane (9/18/2012)
What a coincidence. In a thread below that I read, I learned that this may be the EAV model.
It does indeed look like a variant of EAV -...
September 18, 2012 at 12:40 pm
Nice easy question.
I'm sure I selected 6, but the system told me I was wrong. I guess I didn't select what I though selected - senility setting in,...
September 18, 2012 at 8:41 am
GSquared (9/17/2012)
L' Eomot Inversé (9/15/2012)
SELECT LoadNumber
FROM...
September 17, 2012 at 10:42 am
Good question.
But the referenced BoL page doesn't describe this behaviour, the problem isn't that a media set can't contain both compressed and uncompressed backups (if both backups worked in the...
September 17, 2012 at 8:59 am
Sergiy (9/16/2012)
L' Eomot Inversé (9/16/2012)
... the storage engine decides not to update the row
Can you please provide a reference to a document saying that storage engine operates rows?
So far...
September 16, 2012 at 4:29 pm
Viewing 15 posts - 4,141 through 4,155 (of 7,484 total)