Viewing 15 posts - 18,316 through 18,330 (of 22,226 total)
That looks like SQL SErver 2000. You're posting in the SQL SErver 2005 forum. There is a difference in functionality. That's why you can't save the plan.
Well, without the data...
"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
February 19, 2009 at 8:38 am
Aaron N. Cutshall (2/19/2009)
Sorry for the estimated plans, but since we couldn't get the function to operate, we were unable to get actual plans.
The problem is, especially when dealing with...
"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
February 19, 2009 at 8:32 am
GilaMonster (2/19/2009)
Lynn Pettis (2/19/2009)
"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
February 19, 2009 at 8:22 am
harsha.bhagat1 (2/19/2009)
i am not able to paste the execution plan..how will i do it.. please help..
You generate an actual execution plan, graphical is fine, even preferred. Right click on...
"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
February 19, 2009 at 8:17 am
GilaMonster (2/19/2009)
"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
February 19, 2009 at 8:13 am
OK. This is going to lead to table scans:
WHERE R.MedGroupID = ISNULL(@MedGroupID,
...
"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
February 19, 2009 at 8:08 am
That's kind of a wide PK, depending on the data types. Can you post the execution plan? Actual please, not estimated.
"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
February 19, 2009 at 7:56 am
I'm still trying to untangle the code (did you really need to put comments at the end of every line?), but if this is functional as an inline UDF, 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
February 19, 2009 at 7:48 am
Lynn Pettis (2/19/2009)
"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
February 19, 2009 at 7:46 am
What is it that you're actually trying to do?
Just so you know, the code you posted ran in 89ms on my desktop (not the fastest machine on earth either).
"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
February 19, 2009 at 6:48 am
It sounds like the database is in FULL recovery mode. So you need to institute log backups. Depending on your data needs, you could set the database to SIMPLE recovery...
"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
February 19, 2009 at 6:45 am
harsha.bhagat1 (2/19/2009)
I have a procedure which has to insert into a table in different database and then will delete those data from the related tables. There are more than...
"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
February 19, 2009 at 6:43 am
OK. Now I have questions. My contacts & calendar are managed through Outlook and my phone (Blackberry currently, going to change soon). Can you sync that with one of these...
"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
February 19, 2009 at 6:21 am
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
It makes me wonder what people do all day at these jobs they've been slogging away at for years.
From prior experience working with people like that,...
"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
February 19, 2009 at 6:19 am
GilaMonster (2/19/2009)
Roy Ernest (2/19/2009)
My problem is the management says I am too tough when giving interviews.
My former management used to tell me the same thing. So I expect that people...
"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
February 19, 2009 at 6:15 am
Viewing 15 posts - 18,316 through 18,330 (of 22,226 total)