Viewing 15 posts - 4,336 through 4,350 (of 22,224 total)
This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's just odd.
No need to pile on 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
October 10, 2016 at 11:45 am
mohsinladha (10/10/2016)
Thanks for all the replies. I get it! One cannot rely on just Query Execution Plan to determine if a query will run efficiently
Not exactly. It's just that 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
October 10, 2016 at 8:42 am
Query stats and procedure stats can be very different because a proc can consist of multiple queries, or, you may even have a query in multiple procs. The execution of...
"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 10, 2016 at 8:05 am
Although, let's be cautious about comparing the estimated costs on execution plans and saying that's the same as comparing performance. It absolutely is not. Even with actual plans, those costs...
"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 10, 2016 at 6:41 am
It's possible that the query is not being executed as a remote procedure call, but as a SQL Batch. You can call procedures that way. You may be seeing that....
"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 10, 2016 at 6:39 am
drew.allen (10/7/2016)
niall5098 (10/7/2016)
HI There,it looks like sql but is actually text
We said it was XML, not SQL, and XML IS text, but in a very specific format. Even if...
"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 7, 2016 at 9:18 am
The example looks like either XML or JSON. Do you know where the data is coming from? It's fine that it's stored in a VARCHAR field, but if it's XML...
"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 7, 2016 at 8:37 am
Brandie Tarvin (10/7/2016)
Stuart Davies (10/7/2016)
rodjkidd (10/7/2016)
Brandie, and everyone else who are in the path / effected by Matthew, stay safeRodders...
I don't post here often, but love the community that 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 7, 2016 at 8:15 am
If it's not XML, and XML would be a lot easier here, then you'll have to use string manipulation to find the start and stop points using CHARINDEX. Then 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
October 7, 2016 at 8:13 am
The easiest way is to simply put wild card values around the string you're looking for and use LIKE:
...WHERE a.Col LIKE '%new_ref_no%' AND a.Col LIKE '%old_ref_no%';
Performance will be horrible...
"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 7, 2016 at 6:00 am
It's really down to identifying the pain points. Figure out which query or queries are running slower. Why are they running slower? Fix that. First blush, it sounds like a...
"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 6, 2016 at 11:12 am
FunkyDexter (10/6/2016)
I can't seem to start a thread in one of the TSQL forums. Just trying a reply here to see what happens. Sorry to interrupt the ramblings:-)
This...
"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 6, 2016 at 6:34 am
hurricaneDBA (10/5/2016)
Ill discuss it with management to run them every hour.
If I setup the backups to run every...
"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 6, 2016 at 5:11 am
I'm with Kevin on still being a little new on the memory optimized stuff. Most of my testing and training suggests you might be better off with a hash 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
October 6, 2016 at 5:02 am
Tava (10/6/2016)
Is it not better to do both physical and logical? If you had too choose would...
"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 6, 2016 at 4:59 am
Viewing 15 posts - 4,336 through 4,350 (of 22,224 total)