Viewing 15 posts - 16 through 30 (of 219 total)
call.copse (10/23/2012)
October 23, 2012 at 5:55 am
SQL Kiwi (9/21/2012)
Goodness knows myths around implied ordering are prevalent enough without questions like this reinforcing those misconceptions.
I've just run the 'sp_who2 active' command on one of our servers. This...
September 21, 2012 at 2:52 am
rVadim (9/20/2012)
I thought DiskIO in sp_Who2 means reads and writes combined, not just reads as question asks. Am I wrong?
You are absolutely right. Running 'sp_helptext sp_who2', we can see the...
September 21, 2012 at 12:08 am
(Bob Brown) (9/19/2012)
Executed the select many times and never got a return. Oh well.
Try the following script, I'm sure you'll get some (approx. 10-15) non-empty results:
set nocount...
September 19, 2012 at 5:26 am
Raghavendra Mudugal (9/12/2012)
vk-kirov (9/12/2012)
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
Because here the "peppers" is plural. Of-course the...
September 12, 2012 at 5:32 am
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
September 12, 2012 at 1:07 am
Olga B (9/6/2012)
September 6, 2012 at 11:14 pm
For each table name: if we already have such a table in the database, drop it ...
... and say goodbye to a concurrent process (if any) 🙂
Not so good, I...
September 6, 2012 at 1:12 am
I got a point for choosing the "correct" answer because I hadn't counted characters in the dynamic queries. Now I want an extra point for that reason. This is why...
August 3, 2012 at 2:50 am
L' Eomot Inversé (7/25/2012)
I guess 23% of people were sufficiently observant to notice the check boxes, since that many got it right.
Maybe 12%, not 23?
I guess this is just the...
July 26, 2012 at 1:15 am
WayneS (7/19/2012)
see http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx for more about the UNDO portion of recovery
And see another brilliant Paul Randal's article for the detailed explanation about the subject of the QotD: Understanding SQL Server...
July 19, 2012 at 11:34 pm
Weird logic. I don't understand how the answer could be "No", while in fact the database can be restored from any of the snapshots (although not with a single RESTORE...
July 19, 2012 at 12:40 am
Happy to be enlightened about that myth. It definitely worth two points.
June 28, 2012 at 12:59 am
Koen Verbeeck (6/27/2012)
I doubt a 1-1 foreign key relationship is very useful 😀
At current job I deal with some billing software. There's a table of payments containing such rows as...
June 27, 2012 at 3:11 am
I can create an index by means of a unique constraint:
CREATE TABLE dbo.QotD
(KeyColumn int NOT NULL PRIMARY KEY,
RefColumn int NOT NULL,
-- More...
June 26, 2012 at 11:43 pm
Viewing 15 posts - 16 through 30 (of 219 total)