Viewing 15 posts - 4,066 through 4,080 (of 22,224 total)
The main problem with reading deadlock graphs is that they are incomplete. The batch that contains the UPDATE statement has another 159 lines of code in it. The deadlock victim...
"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
February 21, 2017 at 5:10 am
SQLRNNR - Monday, February 20, 2017 11:47 AMDang it. It wasn't bought out of midlife crisis. :Whistling:
Mostly.
"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
February 20, 2017 at 1:05 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
February 20, 2017 at 1:05 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
February 20, 2017 at 9:24 am
If you lose a decision, do you resort to violence...
"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
February 20, 2017 at 8:14 am
Everyone has posted thoughtful contributions to the discussion. 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
February 20, 2017 at 7:43 am
It does depend on how the queries are consuming your indexes. If you have an exact duplicate clustered index and a non-clustered index and you have a query that needs...
"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
February 20, 2017 at 7:27 am
It's not just a question of the debugger slowing down the server. You can generate all sorts of errors on the server during the debugging process. They can have impacts...
"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
February 20, 2017 at 7:21 am
First up, don't use the Wizard. The only advantage the Wizard has over the regular GUI is the Next button. You don't need that. Further, the Wizard doesn't offer all...
"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
February 20, 2017 at 7:07 am
Check out the traceflag 2371. If you're not hitting automatic statistics updates with the default settings, you may benefit from setting this traceflag.
"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
February 20, 2017 at 6:49 am
kucyk - Friday, February 17, 2017 7:20 AMture, but only for >= 2012 instances 🙂 thank you
You are posting in the 2014...
"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
February 17, 2017 at 7:30 am
Connection timeouts are very hard to track. They're almost impossible to track within SQL Server because they're not connecting, therefore, SQL Server doesn't see anything. You just can't track what'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
February 17, 2017 at 7:29 am
It's a bool. It should simply turn off page locking. In fact, when it's turned off, you'll get an error when you try to reorganize the index. Check the "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 17, 2017 at 7: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
February 17, 2017 at 7:13 am
Everything Bill has said is 100% correct. I just want to reinforce it.
Proper normalization improves performance. You store smaller amounts of data. This means fewer reads and writes...
"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
February 17, 2017 at 6:36 am
Viewing 15 posts - 4,066 through 4,080 (of 22,224 total)