Turn on trace flag 1222:

DBCC TRACEON ( 1222, -1 )

Then when a deadlock occurs, SQL will put detailed info about the deadlock into the SQL error log.

Rebooting will not help...

rarascon (4/9/2013)

---

One more thing, I did wind up having to add a new column, because as Sean mentioned the original column as varchar is always going to be a thorn...

STUFF(TheDate, 3, 0, '/01')

Would convert 'mm/yyyy' to 'mm/01/yyyy'. You could then use it as a date, either implicitly (somewhat risky) or explicitly, 100% safe but you have to use...

I don't think that's true. If it is, it violates...

In SQL Server, temporary tables start with # or ##, such as #table or ##table.

IIRC:

SQL will automatically destroy # tables when the connection ends.

For ## tables, under SQL 2005 and...

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

Lynn Pettis (4/4/2013)

---

Not saying I am right or wrong. I wanted a straight answer to a straight question: Is it a problem to lose the data...

Lynn Pettis (4/4/2013)

---

Not saying I am right or wrong. I wanted a straight answer to a straight question: Is it a problem to lose the data if there is...

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that...

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that connection as well.

I...

Agree absolutely. Can you not specify any time of date range to help limit the rows to be processed?

And, what the heck, maybe try this first too:

SELECT CASE WHEN...

rajarshi_ghosh_05 (4/4/2013)

---

ScottPletcher (4/4/2013)

---

It sounded like one of those types of processes, where you basically just need a temporary "cache" of results / report. Typically those are easy enough for...

Sean Lange (4/4/2013)

---

ScottPletcher (4/4/2013)

---

SELECT RefNumber

FROM #Data d

GROUP BY RefNumber

HAVING

COUNT(DISTINCT EntryType) = 3 AND

MAX(CASE WHEN EntryType NOT IN ( 0, 2, 11 )...

It sounded like one of those types of processes, where you basically just need a temporary "cache" of results / report. Typically those are easy enough for a user...

You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that connection as well.

I mean, seriously, if...

SELECT

LEFT(File, 4) AS File,

MAX(CASE WHEN SUBSTRING(File, 6, 1) = '' THEN Description ELSE '' END) AS Description,

SUM(Points)...