Viewing 15 posts - 18,301 through 18,315 (of 22,219 total)
Lynn Pettis (2/19/2009)
Grant Fritchey (2/19/2009)
Steve Jones - Editor (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 9:31 am
harsha.bhagat1 (2/19/2009)
Even I provide with the table hints 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
February 19, 2009 at 9:28 am
noeld (2/19/2009)
Why so many DBs?You surely have a lot of contention on tempdb!
And everywhere else.
"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 9:25 am
Steve Jones - Editor (2/19/2009)
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
February 19, 2009 at 9:23 am
There are a bunch of functions available in the Scripts area of the site. You do a search to track them down. Here's the one at the top of 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
February 19, 2009 at 9:21 am
I still don't understand why you would do this, but you might want to look up the SQL Agent in the Books Online.
"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 9:19 am
If you look at the execution plan for the DISTINCT, you're getting a huge load because of the DISTINCT operation itself. It's joining ALL the data between the three tables...
"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 9:17 am
Yeah, Gail's got it. Fix that lookup operation with the included columns and should see a pretty substantial increase in performance.
I think you're getting those scans because of 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
February 19, 2009 at 9:10 am
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
Viewing 15 posts - 18,301 through 18,315 (of 22,219 total)