Viewing 15 posts - 14,056 through 14,070 (of 22,224 total)
There are a few ways. You can modify the proc to include WITH RECOMPILE as a hint, I don't suggest that though. Another way is to get the plan handle...
"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
October 22, 2010 at 7:51 am
Right out of the gate, you've got a DISTINCT and a GROUP BY. That's an aggregate operation on an aggregate operation. I'd try to eliminate the DISTINCT from the query.
Looking...
"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
October 22, 2010 at 6:07 am
I very strongly recommend you get a copy of Don Jones book, PowerShell 2.0 TFM. It doesn't get into SQL Server much at all, but it will give a very...
"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
October 22, 2010 at 5:53 am
Excellent article. Clearly articulated and great examples. Thanks.
"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
October 22, 2010 at 5:49 am
It's describing the amount of memory used to store temporary row data for sorts & other operations. Here's a great blog entry from MS on 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
October 22, 2010 at 5:41 am
It sounds like a parameter sniffing issue. A quick fix would be to recompile the procedure on prod and see if the plan changes.
"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
October 22, 2010 at 1:36 am
Jeff Moden (10/21/2010)
Grant Fritchey (10/20/2010)
Jeff Moden (10/20/2010)
Paul White NZ (10/20/2010)
GSquared (10/20/2010)
"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
October 22, 2010 at 1:14 am
Jeff Moden (10/20/2010)
Paul White NZ (10/20/2010)
GSquared (10/20/2010)
"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
October 20, 2010 at 3:20 pm
LutzM (10/20/2010)
"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
October 20, 2010 at 2:30 pm
Or, would it be
SELECT * FROM TABLE WHERE SK = 1 AND Flag = 1I'm confused too.
"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
October 20, 2010 at 2:27 pm
Please don't post to multiple locations. It just messes up the conversation.
There are also responses over here.
"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
October 20, 2010 at 8:28 am
What are you trying to do?
Simply debugging the procedure, which means validating that it runs correctly and does what is requested of it, just requires access to the database 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
October 20, 2010 at 8:26 am
Oh, and start learning PowerShell. I'd start with Don Jones book, PowerShell 2.0, TFM.
"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
October 20, 2010 at 8:22 am
I'd get two of the Inside SQL Server 2008 books, T-SQL Querying by Itzik Ben-Gan and Internals by Kalen Delaney. The vast majority of what you need to know is...
"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
October 20, 2010 at 8:21 am
GilaMonster (10/19/2010)
Grant Fritchey (10/19/2010)
"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
October 19, 2010 at 12:45 pm
Viewing 15 posts - 14,056 through 14,070 (of 22,224 total)