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

SELECT RefNumber

FROM #Data d

GROUP BY RefNumber

HAVING

COUNT(DISTINCT EntryType) = 3 AND

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

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/1/2013)

---

sharky (3/31/2013)

---

Lynn Pettis (3/29/2013)

---

SQLRNNR (3/29/2013)

---

Lynn Pettis (3/29/2013)

---

ScottPletcher (3/29/2013)

---

The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to...

jasona.work (4/3/2013)

ScottPletcher, Once the SP Admin gets done with clearing out the old audit information, actually reducing the on-disk size of the logs (and as you suggest, setting their...

Overall that sounds reasonable, given that you are in an emergency situation.

About how long might it be before SQL auto-truncates the logs? Can I "force" it to happen sooner by...

It's a huge waste to do a separate SELECT from the table for each column.

You can do a MAX(LEN(column_name)) for all columns in one SELECT statement, and hopefully thus do...

Yes, additional writes can occur to the log after you start a log backup.

But the log backup itself will contain only logs records up to the time the log backup...

SELECT

, segment, value

FROM (

SELECT

, segment, value,

ROW_NUMBER()...

Not in that sense, no.

Triggers are designed to...

"FOR" was used before SQL allowed BEFORE or INSTEAD triggers; there were only AFTER triggers, and the syntax used the word "FOR" instead of "AFTER".

After other trigger types were added,...