Viewing 15 posts - 6,496 through 6,510 (of 7,484 total)
igsri (11/27/2010)
CREATE PROC Test
WITH ENCRYPTION
AS
SELECT *from tbl_Test
Now this procedure is encrypted, but in SQL 2008 we can see it's execution plan too.
I...
November 28, 2010 at 5:48 am
Nakul Vachhrajani (11/24/2010)
This was very similar to one of my own QotDs a few months back.
However, what I take from this one is that the DDL is not committed...
November 28, 2010 at 5:36 am
Alvin Ramard (11/24/2010)
Just heard IT supervisor say it's 110 degrees in the server room. Glad I don't have anything to do with server admin.
It must be nice to have...
November 24, 2010 at 5:43 pm
Gianluca Sartori (11/24/2010)
WayneS (11/23/2010)
Alvin Ramard (11/23/2010)
Craig Farrell (11/23/2010)
Alvin Ramard (11/23/2010)
LutzM (11/23/2010)
Alvin, that's what you look like when you've had time to shave?!? 😀But isn't that counterproductive regarding hunting season?
Depends on...
November 24, 2010 at 5:35 pm
It's a good question, but now that MS have clearly stated that # (on its own) will not be supported as a temporary table name in a future version of...
November 24, 2010 at 5:20 am
Nice easy question.
Appalled that half the answers to date have been wrong.
November 24, 2010 at 5:07 am
Nice question. I didn't know the answer so had to think about what would be likely to happen. Fortunately reached the right conclusion.
November 21, 2010 at 3:30 pm
An excellent question.
I didn't see any ambiguity in it: "defined row size" is not a reserved phrase in connection with SQL server, but then neither are most of...
November 21, 2010 at 3:04 pm
Although I'm irritated that the flipping of 1 and 2 was very noticeable and having noticed it I decided that was "the trick" and thought no more (thus getting the...
November 21, 2010 at 1:42 pm
I agree with Scott, the query which the explanation says willprovide info about the table will in fact retrieve nothing unless "=" is changed to "LIKE" and it's running in...
November 21, 2010 at 1:19 pm
GilaMonster (11/19/2010)
Grant Fritchey (11/19/2010)
GilaMonster (11/19/2010)
Irreparably suspect, no backups.http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx
Doesn't say much for my mood that I slightly enjoyed posting that last message there. Wrong, I know.
That's it. We're cancelling Christmas for...
November 19, 2010 at 10:50 am
Roy Ernest (11/19/2010)
Alvin Ramard (11/19/2010)
Stefan Krzywicki (11/19/2010)
GilaMonster (11/19/2010)
Brandie Tarvin (11/19/2010)
And here's a big ol' U.S. standard baseball bat.Jo. Bokken. Katana. Baseball bat.
Decisions, decisions....
I'm an American, so I have no...
November 19, 2010 at 10:44 am
Eric Min (11/17/2010)
We are in Eastern Time zone.
I think the time zone is not a problem.
The problem is that the SQL Audit event log time is different from the...
November 18, 2010 at 6:23 am
This was a good question, with a clearly correct answer.
All the suggestions that "none of the above" is the correct answer surprised me, and the absolutely illogical arguments supporting that...
November 15, 2010 at 5:50 am
Nice clean question, answer, and explanation. Thanks.
But I must remember not to do QOTD at this time of day.
November 12, 2010 at 8:37 pm
Viewing 15 posts - 6,496 through 6,510 (of 7,484 total)