Viewing 15 posts - 21,841 through 21,855 (of 22,226 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2007 at 8:44 am
Quick and dirty, completely inelegant and unefficient and you might have to run it two or three times in a row, but it will do the job. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2007 at 8:35 am
I think most of the other posters have already hit the high points. Upgrade and development times are just too long to support short release cycles. We started working with 2005...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2007 at 5:27 am
I've been reading Hornblower & Sharpe & Aubrey/Maturin novels my entire life. That and growing up on Monty Python and British television... It's just there. Plus, I used it to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2007 at 5:15 am
Hey watch it! I resemble that remark.
Yeah, old, weak joke but unfortunately true.
How about a manly hand shake?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2007 at 4:53 pm
You got trouble in River City. According to MS:
The 824 error indicates that a logical consistency error was detected during a read. A logical consistency error is a clear indication...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2007 at 6:52 am
In addition to all those recommendations, I'd suggest taking the IN clause and turning that into a join, even if you keep it as a derived table. In terms of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2007 at 6:47 am
HI STELLA!
<big hug>
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2007 at 5:28 am
Most of our procs are converted to XML out on the client (app server actually). No real need to output to XML, in most cases, in the procedure. From your...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2007 at 5:26 am
Oh hell, time to start a support group. Who needs a hug?
Hi, my name is Grant. I'm unable to upload useless little pictures.
<CROWD> Hi Grant
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2007 at 4:47 am
Code reuse in this circumstance sounds really useful. I think I might take a look around. I'm sure we have something along these lines that might, possibly benefit.
I'm curious to see the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2007 at 4:23 am
What about:
UPDATE
[Northwind].[dbo].[Orders]
SET [ShippedDate] = x.myshipdate
FROM ( "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2007 at 8:10 am
What error are you getting? You can run a backup command from just about anywhere (a linked server isn't really necessary), but the real issue is usually one of disk...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2007 at 8:05 am
Assuming a clustered index on the UniqueRowId (or a combination of the other columns used in the aggregate query), in a similar situation we've found that using TOP(1) with an...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2007 at 7:58 am
Viewing 15 posts - 21,841 through 21,855 (of 22,226 total)