venablc, thanks for the post. I use a similar technique for certain large imports. It does not make a lot of sense for small inserts, but it is...

Excellent article. One thing worth reemphasizing is practical experience, as mentioned in the article. You can learn a lot by setting yourself challenges and trying to solve them.

A good article and an interesting approach. Another approach for when dealing with truly large amounts of data is to have the application output it into a CSV file...

Brilliant article on a good technique. I am going to have to try this out before I actually need it.

Steve Jones - Editor (8/11/2009)

---

What I would be happy to do is publish a list of "reviewers" on the writer's page and allow authors the ability to private message people...

Kit G, you have some excellent points.

The counterpoint is that a review does not have to be perfect to be useful. As you quite correctly say, even sources of...

It is good to have the editorial policy elucidated.

Personally, I am a big fan of this site exactly as it is and have great respect for what it has accomplished....

GilaMonster (8/10/2009)

---

That has been discussed before here. I don't recall if there was a consensus, but a common concern was lack of time. It's all well and good to say...

GilaMonster (8/10/2009)

---

timothyawiseman (8/10/2009)

---

I am not clear on if temp tables generate better execution plans than table variables. I have not formally tested it, but intuitively I would expect the...

Lynn Pettis (8/10/2009)

---

So, are you volunteering to be part of a forced peer review group for articles? Then, the more important question, how long will stay with it if...

GSquared (8/10/2009)

---

Have to sort of disagree with you on this one. Temp tables cause statement recompiles in 2005/8, and proc recompiles in 2000, but even those are often/usually better...

It can be highly useful and provide enormouse performance benefits, but it comes with risks of dirty data. If that can be...

Andy DBA (8/10/2009)

---

I agree with Tim that many readers will assume endorsement by SSC and might not read any of the comments or even be aware of their presence. ...

This was an interesting article, but I must respectfully disagree on a few points. I apologize if I overlap somewhat with Gail Shaw and other commentors.

2. SQL-92 -

As a...

A very nice article.

I ran into a similar problem a little over a year ago and posted my solution at the time to the site. It is at: ...