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

I...

1) Forums are for TARGETED, small questions and assistance. Your post was neither. I think that is why people didn't answer.

2) Yes, you are naive and old school....