Okay, I've finished my performance testing. See attached zip file for the code used, as well as the execution plans generated and the trace file outputs.

Test was:

Create a 1,000,000 row...

A former boss of mine used to say... if 24 hrs a day isn't enough, work nights.

Bob Hovious 24601 (10/28/2009)

---

You're welcome, Wayne. Please let us know which you finally go with and why. If one is significantly faster than the other,...

Hey guys, this looks awesome. I had pushed the UNPIVOT out of my mind 'cause I didn't think it would work with multiple sets of columns.

I'll post some results as...

I assume you're counting a server as an instance of sql server? Thus one physical computer might have several sql servers?

That's a bummer Jeff... but is the new job going good?

Sounds like it's not going to be easy, but I'll be praying for a speedy recovery.

Steve Jones - Editor (10/21/2009)

---

Database Pork Chops

---------------------

4 large chops, bone-in

cayenne pepper

flour

sharp knife

trebuchet

With the knife, sharpen the end of the bones until they achieve a dangerous point.

Liberally coat the chops with...

GabyYYZ (10/21/2009)

---

I've been wondering if people who accidentally stumble onto the first page of the THREAD and casually go from page to page, not realizing how long it has grown?...

Bob Hovious 24601 (10/20/2009)

---

I have this odd vision of one of the "outsourcees" bringing a problem here for assistance, and then Wayne helps him out and finally sees his own...

Paul White (10/21/2009)

---

Venting time. Feel free to skip this post if you're not in the mood to hear me whinge on... 🙂

So, this guy Steve McRoberts goes to all...

Jonathan Kehayias (10/20/2009)

---

Reapply Service Pack 1 to SSMS 2008. There is a DLL from 2005 that was reregistered during the updates that is causing the issue. Running SP1...

adonismartinez (10/20/2009)

---

I have a store procedure that work fine for entire results, but I am interest it in populating my parameters with result of my store procedure, do I need...

Yeah, but at least I'm in the position where I can reject their code... they just keep coming to...

On a related note, is there any benefit to having a database in either the Full or Bulk-Logged recovery model if log backups are not occurring?