Viewing 15 posts - 8,566 through 8,580 (of 22,232 total)
paul.knibbs (3/26/2014)
Well, it's not a totally unreasonable position, so long as you actually know what you're talking about...
Maybe. I mean, the organization I was with is still using SQL Server,...
"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
March 26, 2014 at 3:59 am
The Dixie Flatline (3/25/2014)
"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
March 25, 2014 at 6:46 pm
ScottPletcher (3/25/2014)
Grant Fritchey (3/25/2014)
ScottPletcher (3/25/2014)
Grant Fritchey (3/25/2014)
"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
March 25, 2014 at 6:34 pm
If you really want to do it all manually, I'd look up one of the blocking scripts that are posted online here. Get a newer version for 2008 , not...
"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
March 25, 2014 at 3:32 pm
ScottPletcher (3/25/2014)
Grant Fritchey (3/25/2014)
"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
March 25, 2014 at 3:31 pm
Rows will be limited by storage and that's storage in tempdb. Here's a listing of all the limits on SQL Server. Books Online is always one of the single best...
"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
March 25, 2014 at 12:32 pm
I can't see the query since it exceeds the size of what's stored in the plan, so suggestions from the plan alone are going to be a bit vague.
First off,...
"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
March 25, 2014 at 12:20 pm
Do you need the aggregation of DISTINCT? Are there data problems you could fix instead of using DISTINCT? You might want to try attacking that. But, I'm with Gail, without...
"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
March 25, 2014 at 12:03 pm
That's what a reporting tool is for. SQL Server and T-SQL are a horrible place to do that kind of formatting.
"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
March 25, 2014 at 12:00 pm
Caruncles (3/25/2014)
"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
March 25, 2014 at 8:41 am
Default values are extremely low cost. I'm not even sure if you can measure that. You pass a NULL value and something else is used instead. When you said constraints...
"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
March 25, 2014 at 7:46 am
SQLSACT (3/25/2014)
ThanksCould a literal possibly be:
select column from table where column = 'literal'.
Yep. That's 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
March 25, 2014 at 6:22 am
I'd suggest double checking the data in the column. It sounds like you may have text data mixed in with the numbers.
"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
March 25, 2014 at 5:55 am
A literal is a string or number used within the query, not a variable or a parameter, but a literal value.
Then, the plan isn't cached. Period. It's not inside or...
"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
March 25, 2014 at 5:49 am
Try running the query without the WHERE clause. You'll note that there are tons of plans right there in the cache that are larger. If there is a literal within...
"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
March 25, 2014 at 4:24 am
Viewing 15 posts - 8,566 through 8,580 (of 22,232 total)