Viewing 15 posts - 4,336 through 4,350 (of 22,219 total)
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
I just cancelled a trip for the first time in almost six years of travelling thanks to this hurricane. I am not pleased.
I hope everyone down in Florida, and especially...
"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 5, 2016 at 10:18 am
george sibbald (10/5/2016)
I made it into the top 30 posters at one point so I did my...
"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 5, 2016 at 5:27 am
Eirikur Eiriksson (10/5/2016)
Any upgrades available for the Crystal Ball?😎
And the latest question on the indexes... oh my.
"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 5, 2016 at 4:45 am
ramyours2003 (10/5/2016)
thanks for the mail , what is the reason of not creating index on 32 bit system?
You tell us. Indexes are as vital to a 32 bit system as...
"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 5, 2016 at 4:44 am
Grab a copy of my book on performance tuning and start reading. Get a copy of Gail's book on being an Accidental DBA and start reading.
One system change I...
"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 5, 2016 at 4:23 am
Viewing 15 posts - 4,336 through 4,350 (of 22,219 total)