No arguments there. We had a proc that was so poorly written that it took about 3 minutes to recompile. It too was called thousands of times a minute and...

And, if you do decide to split them, you can still use the original proc as a wrapper around the other two so that you don't have to re-write your...

I think you've already answered your own question. If the optimizer can generate a plan that kills performance then you need a method to avoid this. You could try forcing...

This is a part of Analysis Services. According to the books online you can turn this off through the Properties of the server in SSMS.

I did tech support for a bank in the early 90's and had to wear a suit & tie while pulling cable and crawling under desks. Dumbest damn thing in...

Guiness is OK, still not as good as a real ale. Corona? Blech! The best beer out of Ol Mehico is Bohemia. Great stuff. Hold the friggin' lime.

Actually, I haddn't thought of that, but yeah, in most cases this is probably quicker.

Ooh, Steve, if you're taking orders, grab a keg of something... how about Ruddles County. If not that, use your judgement.

I'm jealous Steve. English beer... Mmmmmm! A few pints of real ale and I'll hug everybody.

Looks like the SuppContacts table has one row for email with phone null & one row for phone with email null? Better design would probably be to seperate these into...

CTE's are only available for the next SELECT statement. You can't define a CTE & then run multiple selects against it. If you need that kind of functionality, you'll need...

I tried setting up the two tables and putting together some sample data, but I can't run your query. As I suspected it returns more than one row in the...

Holy Cow! Discussions around the proper placement of the f-bomb in sentence structure in order to communicate with the squids is serious? I clearly need to get out more.

<hug>

I'll be...

It looks like the correlatted query can return more than one value and that will cause the query to fail.

Here's a first pass substitute:

SELECT ItemNo_,ItemDescription, COALESECE(a.Description,b.Description)

FROM Item

JOIN ItemExtraDescription a

ON Item.No_=a.No_

AND...

I believe that debugging is only available through Visual Studio.

http://msdn2.microsoft.com/en-us/library/ms165034(VS.80).aspx