Viewing 15 posts - 3,991 through 4,005 (of 22,219 total)
Since you can't go to 2016 and take advantage of Query Store, upgrading to 2014, you need to, as much as possible, simulate having Query Store available. With that in...
"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
March 20, 2017 at 10:43 am
Excellent article.
I would suggest a single caveat that having a secondary copy of the data somewhere other than Azure is a good practice if this is business critical...
"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
March 20, 2017 at 5:17 am
It's not always about free consulting. When we had people get past our tier 1 phone interview, assuming they did well during our second discussion (white board & all that...
"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
March 15, 2017 at 6:03 am
"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
March 11, 2017 at 2:44 am
Interesting. I've never seen that approach before. I'm not sure I'm crazy about it at all. In general I wouldn't really bother counting, or worrying about the count, of CXPACKETS....
"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
March 10, 2017 at 10:31 am
I'm not sure where you got the concept of balancing CXPACKET and SOS_SCHEDULER_YIELD. That's not a valid approach that I've ever heard of.
CXPACKETS just indicates that parallelism is...
"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
March 10, 2017 at 9:33 am
However, I'm a little hung on why this is so vitally important? What's the end goal? What are we trying to do? Is it just about learning index internals?
"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
March 9, 2017 at 6:30 am
"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
March 9, 2017 at 6:29 am
"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
March 9, 2017 at 6:25 am
"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
March 9, 2017 at 5:56 am
"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
March 7, 2017 at 11:24 pm
You put the clustered index on a bit column? Very odd choice since there are only two possible values there. It's not a very good index, clustered or nonclustered, 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
March 7, 2017 at 10:57 pm
"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
March 7, 2017 at 2:15 am
I try to fall to moving as little data as possible, so if you have a mechanism of tracking create/update date, then use that as part of your polling process...
"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
March 6, 2017 at 3:34 am
So, a key lookup operation is added cost. However, there is not reason to automatically attempt to remove that cost unless you determine that in fact that key lookup operation...
"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
March 6, 2017 at 3:26 am
Viewing 15 posts - 3,991 through 4,005 (of 22,219 total)