Viewing 15 posts - 19,156 through 19,170 (of 22,226 total)
I guess I need to go back to those 25 table joins that are running in under 50ms and start adding temp tables...
Nah. I'll stick with getting indexing right, 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
December 6, 2008 at 4:41 am
You're getting an error, as you stated above:
However when this query is executed it never completes, eventually failing with a message "8623: The query processor ran out of internal resources...
"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
December 6, 2008 at 4:25 am
Oooh! Nice trick. I never knew about that one. Sweet.
And yes, '%y%' won't use an index. If you think about it logically, it makes sense. An index stores the key...
"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
December 6, 2008 at 4:15 am
I've got two systems that we're trying it out on. The first one was getting lots of deadlocks. We know why, but we're not allowed to modify the code... Don't...
"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
December 5, 2008 at 12:05 pm
Actually, I meant:
It is also pretty lazy ...
I thought you summed it up nicely with those five.
"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
December 5, 2008 at 11:42 am
sqlguy (12/5/2008)
OK - Let's say, for example, that the where clause has conditions where personid = x or lastname like %y%. What type of indexing would you use?
If 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
December 5, 2008 at 11:37 am
You might want to be more lazy. You only needed five words in that last sentence.
"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
December 5, 2008 at 11:23 am
Regardless...
PLZ give complete differences
Without, at the very least, three or four lines of qualification, that's a pretty lame post on just about any topic.
"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
December 5, 2008 at 11:18 am
There must be increased sunspot activity or something because it sure seems like there's a bunch of these popping up all of a sudden.
"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
December 5, 2008 at 10:40 am
If you want to program the extraction, say using C#, get the SMO (SQL Server Management Objects) loaded into your code and you can generate create procedures for any object...
"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
December 5, 2008 at 10:37 am
And comma delimited IN statements are notorious. Like Gail said, execution plans & structures.
"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
December 5, 2008 at 10:35 am
The last ON clause for Table 3 is the same as the ON clause for Table 2.
Is that the problem?
"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
December 5, 2008 at 10:33 am
No.
But which "checks" are you referring to?
"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
December 5, 2008 at 9:03 am
SQL Server uses late binding. So if I wrote this query:
SELECT * FROM
Dinglefarb
And checked the syntax, it'll pass. But if I execute it, while resolving all the objects involved in...
"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
December 5, 2008 at 8:59 am
Sounds like you have a syntax error within the code that allows it to compile but not execute.
"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
December 5, 2008 at 8:34 am
Viewing 15 posts - 19,156 through 19,170 (of 22,226 total)