Troubleshooting problems with locking in SQL Server 2014 (Part 2) If you have problems with SQL Server 2014 locking, review this troubleshooting checklist to find potential solutions. 1. Encapsulate transactions within SQL Server stored procedures. This can reduce network traffic, because your client will send to server only the stored procedure name (perhaps with some parameters), and reduce the amount […]

Troubleshooting problems with locking in SQL Server 2014 (Part 1) If you have problems with SQL Server 2014 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many locking bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the time […]