Viewing 15 posts - 5,851 through 5,865 (of 22,219 total)
Isn't the CHARINDEX just checking the existence of the value in a column? Can't you use equals? If not, can you use LIKE? If you really are searching through an...
"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
July 9, 2015 at 8:24 am
Junglee_George (7/8/2015)
Instead of removing cursor, please help to me to modify the existing code within.
I did. Those functions on columns are going to kill your performance. You must remove them.
"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
July 9, 2015 at 2:47 am
Interesting. Which add 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
July 9, 2015 at 2:41 am
It must have something to do with parameter sniffing. The hard coded values are going to get specifics from the OID column. The query is open to interpretation. In other...
"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
July 9, 2015 at 2:38 am
Eric M Russell (7/8/2015)
"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
July 8, 2015 at 8:22 am
rodjkidd (7/8/2015)
Grant Fritchey (7/8/2015)
rodjkidd (7/8/2015)
BrainDonor (7/8/2015)
Yes, PASS UK isn't well organised. I found out about by chance, having decided to search on the PASS website for anything in trhe UK.
Really?...
"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
July 8, 2015 at 6:38 am
rodjkidd (7/8/2015)
BrainDonor (7/8/2015)
Yes, PASS UK isn't well organised. I found out about by chance, having decided to search on the PASS website for anything in trhe UK.
Really? It's mentioned at...
"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
July 8, 2015 at 6:22 am
Doing an operation like this with a large query like that within a cursor is extremely problematic. Instead of a cursor, I'd suggest modifying or loading your temp table such...
"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
July 8, 2015 at 6:00 am
It sounds like you're largely on track.
On the implied relationship, I'd get that enforced if possible. The more tools you give the optimizer, the better the results.
"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
July 8, 2015 at 5:55 am
The MAXDOP hint is a way of adjusting the degree of parallelism for a given query. It won't force parallelism onto a query. To do that, you have two options....
"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
July 8, 2015 at 2:28 am
More memory.
"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
July 8, 2015 at 2:27 am
I'm not sure why you're choosing to go with all the clustered indexes on the identity columns? I would only do this if that was also the primary path 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
July 8, 2015 at 2:21 am
Not sure what it is, but I've heard of others having this issue. I haven't seen it myself, so I don't have much advice.
"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
July 8, 2015 at 2:15 am
Hey Eric, no query hint I'm aware of that will tell the optimizer to ignore an index.
Ramana, so your concern then is not whether or not an index 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
July 8, 2015 at 1:45 am
I'm not understanding all your structures. In order for the partitions to be eliminated, you have to be able to filter on them. You're saying that partitions are eliminated 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
July 8, 2015 at 1:41 am
Viewing 15 posts - 5,851 through 5,865 (of 22,219 total)