Viewing 15 posts - 5,896 through 5,910 (of 22,219 total)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days off, and the people...
"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 1, 2015 at 12:21 pm
Being a college drop-out and utterly w/o degree, yet, I'd argue, a relatively successful career within IT, I'm frankly not sure what a college degree would have done for me....
"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 1, 2015 at 10:34 am
It's still just about standard monitoring. Keep an eye on your wait statistics, watch to see if these change in a negative fashion. Same thing goes for the queues 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
July 1, 2015 at 8:08 am
If you don't have the capabilities to do disaster recovery, your company can go under.[/url] That's the number one argument for me. We have to be able to do disaster...
"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 1, 2015 at 7:59 am
A second vote for the Internals book. It's great. My book on execution plans does go over how the optimizer works, but not in as much detail. Plus, you can...
"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 1, 2015 at 7:55 am
Also, as much as I'm guilty of saying this, it's not about improving the plan. It's about improving the performance of the query. The plan just exposes how the optimizer...
"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
June 30, 2015 at 12:41 pm
DBA From The Cold (6/30/2015)
Grant Fritchey (6/30/2015)
DBA From The Cold (6/30/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
June 30, 2015 at 6:24 am
GilaMonster (6/30/2015)
Eeep. Just realised that tomorrow's the 1st of July. Or the 'refresh email every 5 seconds' day.
Mine is April 1st, which also means that it's "check the header 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
June 30, 2015 at 5:37 am
DBA From The Cold (6/30/2015)
I've had 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
June 30, 2015 at 3:56 am
Congrats Alan. That's awesome.
"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
June 29, 2015 at 12:39 pm
jellybean (6/29/2015)
Hi,Yes SQL Search is free, indexes fast and is easy to use but does not detects string in the synonyms 🙁
Put in a feature request.
"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
June 29, 2015 at 5:51 am
Unfortunately, there isn't an alternative to CHARINDEX and LTRIM. You need to not use functions, at all, of any kind, on your columns. If your data requires you to pull...
"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
June 29, 2015 at 5:48 am
What Kevin is referring to is this:
LTRIM(P.partnerSqlId) + '-' + LTRIM(P.partnerIncId) = @PartnerKey
That is going to destroy your performance and there's no way around it. You need to remove 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
June 27, 2015 at 8:00 am
Please don't cross post into multiple forums. Most of the people answering questions here read across many of the forums. Cross posting just leads to confusion as different people answer...
"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
June 27, 2015 at 7:54 am
better than what? I've reformatted it so that it's more readable and use the IFCode Shortcuts in the post screen of this website to highlight it as SQL.
SELECT a.emp_id,
...
"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
June 27, 2015 at 7:52 am
Viewing 15 posts - 5,896 through 5,910 (of 22,219 total)