One thing I don't see mentioned is if PERFORMANCE or actual IO or other metrics change when PLE falls off a cliff. If it doesn't, I would chalk it...

Bummer! Sometimes ignorance can be bliss! :hehe:

The log buffer flushes from the individual inserts without a wrapping begin/commit tran will absolutely crush your throughput.

Yes, this is almost certainly possible using this construct:

UPDATE tablea

set ... case statements here for each field with proper code table

FROM tablea

LEFT JOIN to various code tables

It is pretty...

Abu Dina (3/13/2013)

---

Okay great, just one more question that's been bugging me for a while.

My staging table has a lot of NVRCHAR(500) columns. Now I know many of my columns...

RVO (3/13/2013)

---

Thanks all for your response.

Gail's blog recommends using dynamic SQL

but our boss doesn't like it at all.

I have to learn how to handle it either with CASE

or IF. My...

You have been going round and round with this for over 2 weeks now. May I suggest that you get a performance tuning professional on board to really help...

DB_Newbie2007 (3/6/2013)

---

We are working on trying to reduce the high number of IO waits on one of our production servers, a large percentage of which appears to come from one...

Please do NOT just try to implement partitioning without a VERY good knowledge of it and a VERY good understanding of WHY you think you need it in the first...

ChrisM@Work (3/12/2013)

---

Thanks for the reminder, Kevin. I wouldn't say "never" however, I'd...

colin.Leversuch-Roberts (3/11/2013)

---

Generally do you run with this on or off?

I've always been slightly worried about setting this trace flag to ON as I don't really have any load like...

Have them stop deleting data one row at a time!!! Using a cursor for this is ridiculous! This should be done in batches of X records at a time...

What is the other person's justifications for wanting to store 8M entries, 7.99999M of which will never be referenced?

Completely horrible suggestion from a performance standpoint for numerous reasons.

One minor point ChrisM - never do a SELECT INTO... with an ORDER BY. No benefit there.

shohelr2003 (3/11/2013)

---

Dear,

I fire triggers on different events. But some of my clients insist on not using trigger. Because they claim that using triggers are the worst solution. It may disable...