Viewing 15 posts - 5,956 through 5,970 (of 22,219 total)
Piling on, Eirikur's request for information is really the only way to get to the bottom of this.
For the most part, I've usually seen improved performance on most queries. It's...
"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 10, 2015 at 3:33 am
SQLRNNR (6/9/2015)
Grant Fritchey (6/9/2015)
So tempted to whip out "DO YOU KNOW WHO I AM?"Time to walk away from the forums for a few...
Where the **** is that tent?
Well, I 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
June 10, 2015 at 3:03 am
GilaMonster (6/9/2015)
Grant Fritchey (6/9/2015)
So tempted to whip out "DO YOU KNOW WHO I AM?"Need a hand somewhere?
Nah, just a break. It actually wasn't a big deal. I'm glad I stayed...
"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 9, 2015 at 4:42 pm
GilaMonster (6/9/2015)
GilaMonster (6/9/2015)
ericpap (6/9/2015)
Joie Andrew (6/9/2015)
Another question, you say that you only have two logs available. If you look at the C:\Archivos...
"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 9, 2015 at 4:27 pm
Those stats get created when someone does a filter operation like a WHERE clause or a JOIN on columns that don't have either an index or custom statistics. 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 9, 2015 at 1:05 pm
ericpap (6/9/2015)
Alvin Ramard (6/9/2015)
ericpap (6/9/2015)
Alvin Ramard (6/9/2015)
Have you discussed this 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
June 9, 2015 at 1:02 pm
I agree. It's always good to know what ultimately worked.
"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 9, 2015 at 12:56 pm
So tempted to whip out "DO YOU KNOW WHO I AM?"
Time to walk away from the forums for a few...
Where the **** is that tent?
"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 9, 2015 at 9:28 am
g.britton (6/9/2015)
Grant Fritchey (6/9/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 9, 2015 at 9:18 am
Steve Jones - SSC Editor (6/9/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 9, 2015 at 9:03 am
Differences in parameter values or WHERE clause criteria? Use of hard coded values or parameters (either of which is sniffed) vs. local variables (which are not, except during a recompile)?...
"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 9, 2015 at 8:23 am
Since the other query is loading a table and you're just running a SELECT statement, the problem could be in the table load. Contention on the disk, resource contention somewhere...
"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 9, 2015 at 7:45 am
Greg Edwards-268690 (6/9/2015)
Grant Fritchey (6/9/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 9, 2015 at 7:38 am
Cool. Thanks.
"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 9, 2015 at 7:34 am
1. Can you? Yes. Should you? Probably not. sp_updatestats is extremely undisciplined in which statistics it updates. Remember, when stats get updated, not only are you adding the load 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
June 9, 2015 at 6:49 am
Viewing 15 posts - 5,956 through 5,970 (of 22,219 total)