OK, so sp_updatestats uses sampling to create the statistics? Do you also do index rebuilds at any point? These create statistics using full scan. You may just be putting your...

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...

Mostly.

Everyone has posted thoughtful contributions to the discussion. Thanks.

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...

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...

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...

Check out the traceflag 2371. If you're not hitting automatic statistics updates with the default settings, you may benefit from setting this traceflag.

You are posting in the 2014...

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...

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