Hi Grant,

I ran a trace to get a deadlock graph but the xdl file is 0 Kb and I got the following message

Failed to initializa deadlock control.

There is an error...

Thank you

you cannot add bits

CREATE TABLE #Findings

(

CName VARCHAR(100),

Soaps INT,

Paste INT,

Choclates INT,

Biscuit INT,

Pencil INT,

Pen INT

)

INSERT INTO #Findings

VALUES

('Customer1',1,0,0,0,0,0),

('Customer2',1,1,1,0,0,0),

('Customer3',1,0,0,0,1,0),

('Customer4',1,0,0,0,0,0),

('Customer5',1,0,1,0,1,0),

('Customer6',1,0,1,1,0,0),

('Customer7',0,0,0,0,0,1),

('Customer8',0,0,0,0,1,0),

('Customer9',0,1,0,0,0,0)

DECLARE @NbrProducts int = 1;

SELECT*

FROM#Findings

WHERECASE WHEN Soaps > 0 THEN 1 ELSE 0 END +

CASE WHEN Paste >...

Jeff Moden (6/4/2012)

---

On the 9999-12-30 thing... someone could probably write a chapter on it but I'll summarize. One of the best practices I've seen (and almost always use) when...

@jeff, as you can see from my reply to Joe the architecure is not mine, set in concrete and causes me great anguish and pain. Your reply is,...

record

status

CELKO (6/3/2012)

---

>> I have the following table <<

Even for a skeleton, this was bad code; we do not use bit flags, IDENTITY as a fake mag tape recorc...

Thanks Jeff, I appreciate the compliment.

Well, I have learned that there aren't many people, if anyone at all, who know it...

Thanks Mark, that works nicely.

:Whistling:

Comprehension fail on my behalf.

Firstly, SQL Server already stores created_date.

SELECT name, create_date, modify_date

FROM sys.tables

Secondly, where's Joe? :pinch:

Using -b is not entirely correct, the load is still logged, however the log file will be reused for each batch if you are using the simple recovery model.

To achieve...

CELKO (3/19/2012)

---

Part of the University of Maryland and DoD research was the effect of formatting on maintaining code. Desktop programmers do not know or think about maintaining code but that...