Viewing 15 posts - 21,796 through 21,810 (of 22,194 total)
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...
May 24, 2007 at 6:29 am
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...
May 24, 2007 at 5:25 am
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...
May 23, 2007 at 5:20 am
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.
May 23, 2007 at 5:13 am
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...
May 22, 2007 at 8:48 am
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.
May 22, 2007 at 7:36 am
Actually, I haddn't thought of that, but yeah, in most cases this is probably quicker.
May 22, 2007 at 6:02 am
Ooh, Steve, if you're taking orders, grab a keg of something... how about Ruddles County. If not that, use your judgement.
May 22, 2007 at 5:11 am
I'm jealous Steve. English beer... Mmmmmm! A few pints of real ale and I'll hug everybody.
May 21, 2007 at 8:31 am
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...
May 21, 2007 at 7:42 am
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...
May 21, 2007 at 7:09 am
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...
May 21, 2007 at 7:00 am
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...
May 21, 2007 at 5:33 am
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...
May 18, 2007 at 8:58 am
I believe that debugging is only available through Visual Studio.
http://msdn2.microsoft.com/en-us/library/ms165034(VS.80).aspx
May 18, 2007 at 8:44 am
Viewing 15 posts - 21,796 through 21,810 (of 22,194 total)