Viewing 15 posts - 4,786 through 4,800 (of 22,221 total)
river1 (4/27/2016)
I have a proc running every day that reorg/rebuild indexes. If reorg then also updates the stats
It still sounds like the stats are getting stale. If the statistics get...
"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
April 28, 2016 at 2:33 am
Steve Jones - SSC Editor (4/27/2016)
tindog (4/27/2016)
"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
April 27, 2016 at 10:26 am
Mark Cowne (4/27/2016)
Finally got a chance to go this year - doing Wednesday to Saturday.
Track me down and say Hello. I get there Thursday afternoon (assuming the trains work).
"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
April 27, 2016 at 10:25 am
Thanks for reporting back. Glad what I said was helpful.
"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
April 27, 2016 at 8:20 am
I would follow the recommendation from Jonathan Kehayias[/url].
"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
April 27, 2016 at 7:42 am
SQL Server will use every bit of RAM that you give it (assuming you have enough data to fill the cache).
For a good calculation of how much RAM you should...
"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
April 27, 2016 at 7:41 am
rodjkidd (4/27/2016)
Steve Jones - SSC Editor (4/26/2016)
rodjkidd (4/26/2016)
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? ...
"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
April 27, 2016 at 3:43 am
Steve Jones - SSC Editor (4/26/2016)
rodjkidd (4/26/2016)
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK...
"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
April 27, 2016 at 3:42 am
GilaMonster (4/26/2016)
Grant Fritchey (4/26/2016)
GilaMonster (4/26/2016)
Grant Fritchey (4/26/2016)
"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
April 26, 2016 at 11:21 am
SQLRNNR (4/26/2016)
jeff.mason (4/26/2016)
"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
April 26, 2016 at 11:19 am
GilaMonster (4/26/2016)
Grant Fritchey (4/26/2016)
"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
April 26, 2016 at 8:33 am
TheSQLGuru (4/26/2016)
Is TF 8649 supported now? If not (or even if so) it could be better to use Adam Machanic's spiffy high-CPU-estimate trick: http://sqlblog.com/blogs/adam_machanic/archive/2013/07/11/next-level-parallel-plan-porcing.aspx
I doubt it, but all 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
April 26, 2016 at 8:31 am
info.sqldbamail (4/26/2016)
"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
April 26, 2016 at 7:14 am
TheSQLGuru (4/24/2016)
"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
April 26, 2016 at 7:11 am
In addition to what everyone else has already asked, I'd be curious about a couple of things about this query. The estimates are that it's processing 22 rows out 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
April 26, 2016 at 7:07 am
Viewing 15 posts - 4,786 through 4,800 (of 22,221 total)