Viewing 15 posts - 20,056 through 20,070 (of 22,219 total)
It does parse, but try generating an estimated execution plan. It fails immediately. Parse and compile aren't the same.
"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
July 3, 2008 at 7:56 am
I've done this two different ways.
First was to add an effective date column and then always sort by effective date to get the latest effective value.
Better was to create...
"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
July 3, 2008 at 7:47 am
I agree with Gail. Further, it seems like a SurveyId would be a great candidate for the leading edge of the clustered index on most tables. This would store 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
July 3, 2008 at 7:40 am
No, it's pretty clear. Here's the first statement that jumps out:
A TRY…CATCH construct catches all execution errors with severity greater than 10 that do not terminate the database connection.
And then,...
"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
July 3, 2008 at 7:36 am
WOO HOO!
Another well deserved reward. That's terrific. Congratulations Gail. Holy cow, all the cool kids seem to be hanging out here now.
"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
July 3, 2008 at 5:32 am
You're going to be at PASS?
You've got a beverage-of-your-choice coming from me. Track me down.
"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
July 2, 2008 at 1:03 pm
No way in the world to even suggest a solution without at least the execution plan.
"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
July 2, 2008 at 12:11 pm
Great. If you did need to pursue the CASE statements, you can't use "= LIKE." So you'd have to change
AND lc.locstring =
to
AND lc.locstring LIKE
"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
July 2, 2008 at 7:25 am
Several problems where. A horizontal line is formatting. That's not what TSQL is all about.
Also, a UNION query doesn't necessarily return the rows from table 1 and then the rows...
"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
July 2, 2008 at 6:37 am
Johann Montfort (7/2/2008)
How can I write a stored procedure based on condition. At the moment, my code is not working. Here is my example
ALTER PROCEDURE [dbo].[FindStrings]
(
@uid bit,--...
"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
July 2, 2008 at 6:32 am
It depends on the severity of the error. Higher severity errors cause a disconnect of the offending process. Those cannot be trapped.
For the other procedures, in SQL Server 2005, you...
"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
July 2, 2008 at 6:23 am
That sums it up very well.
By the way, you're posting a SQL Server 2000 question in the SQL Server 2005 forum. While this question was fairly generic and the answer...
"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
July 2, 2008 at 6:21 am
A full and hardy congratulations to you both. You deserved it and you earned it.
"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
July 2, 2008 at 6:17 am
Yeah, yeah, I used the "depends" right at the beginning and added weasel words "in all likelihood"
I covered my behind.
😛
"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
July 1, 2008 at 6:40 am
You have to put a "GO" statement between these two scripts. This seperates the two scripts into seperate commands so that they are processed independently by the server. That allows...
"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
July 1, 2008 at 6:27 am
Viewing 15 posts - 20,056 through 20,070 (of 22,219 total)