Steve,

Let me start by saying that I like your editorials. They provoke thoughts on topics that we all come across but don't deal with in our day to day fire...

Chris,

Very interesting.

So what you are saying is that even with the complexity of the CASE added to the query, the number of scans needed by the UNION ALL is the...

Mithun,

Interesting thought but in the same vein each one of the UNION ALL selects in my example has to do a comparison on the AccountType column.

Thanks for your...

Jeffrey Williams (3/30/2009)

---

Be aware that UNION also has to remove duplicates, which is going to take longer to process. If you can guarantee that each query is unique -...

Lynn Pettis (3/30/2009)

---

Simple answer, write it both ways and test. Use the one that works best for you. You may want to revisit the testing periodically to see...

Jeeze, chill out!

I had a gut feeling or, to better define it, a SQL newbie opinion.

Sorry to disturb...

Actually I am looking a costs. Currently I am running SQL Server 2000 standard on a dual processor Xeon (old version) @ 3.2 GHz and am looking to upgrade to 2005...

I would like to re-ask one of the original questions:

"And how does the quad core at a slower speed relate in performance terms to a dual core at a higher...