Viewing 15 posts - 4,801 through 4,815 (of 22,227 total)
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
You basically have to rebuild the query parsing engine within SQL Server. I know that there are people who have done this, but most of the time it's being used...
"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:40 am
I've always written it as ...TableA JOIN TableB ON... adding LEFT/RIGHT as needed. Clarity suggests pretty strongly that you want the defining elements of the JOIN to be right next...
"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:29 am
I don't think there are 10 decent tools in the market. Here are a few, in the order I'm recommending them:
Redgate SQL Monitor [/url](my employer)
SQL Sentry
Microsoft System Center
Solarwinds
Idera
Dell/Quest
That's what 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
April 26, 2016 at 6:25 am
Without more information, it's hard to say. Probably that's an adequate distribution for a very small set of memory (my laptop has 16gb of memory).
Instead of immediately focusing on...
"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:20 am
"Dimmest bulb in the box" is also a good one.
"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 25, 2016 at 7:15 am
I've always liked "dumber than a bag of hammers"
"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 25, 2016 at 6:57 am
VSSGeorge (4/19/2016)
The full execution plan is not available as an error message is encountered.
Msg 1105, Level 17, State 2, Line 61
Could not allocate...
"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 19, 2016 at 4:56 am
Viewing 15 posts - 4,801 through 4,815 (of 22,227 total)