Viewing 15 posts - 4,786 through 4,800 (of 22,219 total)
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
Your memory is behaving exactly as it's supposed to. As Kevin has said, your max might be a little high. Probably leaving 8gb for the OS would work better.
However, 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 6:58 am
On top of what Luis recommends, great selection by the way, I'd suggest getting a copy of Kalen Delaney's SQL Server Internals. That's a fantastic collection of in-depth information about...
"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 6:55 am
Viewing 15 posts - 4,786 through 4,800 (of 22,219 total)