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, however, valuable...

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...