SQLServerCentral.com Content tagged Lock and Connection Managementhttp://www.sqlservercentral.com/Content tagged Lock and Connection Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Transactionhttp://www.sqlservercentral.com/questions/Transaction/63294/2008/07/16http://www.sqlservercentral.com/questions/Transaction/63294/Blockinghttp://www.sqlservercentral.com/questions/Lock+and+Connection+Management/62845/2008/05/16http://www.sqlservercentral.com/questions/Lock+and+Connection+Management/62845/Using Indexes to Bypass LocksOne of the issues you'll face with SQL Server is blocking which is caused by other processes that are holding locks on objects. Until the locks are removed on an object the next process will wait before proceeding. This is a common process that runs within SQL Server to ensure data integrity, but depending on how transactions are run this can cause some issues. Are there ways to get around blocking by using different indexes to cover the queries that may be running?http://www.sqlservercentral.com/redirect/articles/62913/2008/05/02http://www.sqlservercentral.com/redirect/articles/62913/TopBlockerScript to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/61438/2007/12/07http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/61438/How to insert and update from remote linked serverhttp://www.sqlservercentral.com/scripts/Replication/31977/2007/10/30http://www.sqlservercentral.com/scripts/Replication/31977/usp_KillConnectionshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/usp_KillConnectionshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/finding the blocks in sql serverhttp://www.sqlservercentral.com/scripts/Miscellaneous/32000/2007/09/09http://www.sqlservercentral.com/scripts/Miscellaneous/32000/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31267/2007/06/13http://www.sqlservercentral.com/scripts/Miscellaneous/31267/Who's Blockinghttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31901/2007/04/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31901/What's Runninghttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31900/2007/04/17http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31900/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31267/2007/06/13http://www.sqlservercentral.com/scripts/Miscellaneous/31267/Script to output dbcc inputbuffer adding spid infohttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31802/2006/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31802/sp_whathttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/2006/10/02http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/SQLPing.vbshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31781/2006/09/04http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31781/Function to return the SQL Build Numberhttp://www.sqlservercentral.com/scripts/Replication/31753/2006/08/09http://www.sqlservercentral.com/scripts/Replication/31753/Function to return the SQL Version Numberhttp://www.sqlservercentral.com/scripts/Replication/31754/2006/08/08http://www.sqlservercentral.com/scripts/Replication/31754/Function to return the SQL Build Numberhttp://www.sqlservercentral.com/scripts/Replication/31753/2006/08/09http://www.sqlservercentral.com/scripts/Replication/31753/Function to return the SQL Version Numberhttp://www.sqlservercentral.com/scripts/Replication/31754/2006/08/08http://www.sqlservercentral.com/scripts/Replication/31754/sp_whathttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/2006/10/02http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/SP_WHO_3 - A Very Powerful Utility for All DBAshttp://www.sqlservercentral.com/scripts/Miscellaneous/31232/2006/01/17http://www.sqlservercentral.com/scripts/Miscellaneous/31232/Table Variableshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/2006/01/15http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/Blocked Process script for deadlock correctionhttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31535/2005/12/01http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31535/Save results DBCC SQLPERF(UMSSTATS) in a table http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31577/2005/11/04http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31577/To Identify blocks if using Solomon IVhttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31578/2005/11/03http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31578/usp_ToggleDatabaseshttp://www.sqlservercentral.com/scripts/Replication/31554/2005/08/04http://www.sqlservercentral.com/scripts/Replication/31554/Blocked Process script for deadlock correctionhttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31535/2005/12/01http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31535/SQL Blocking and Blocked Proc + Notifi - Part2http://www.sqlservercentral.com/scripts/Miscellaneous/31492/2005/05/12http://www.sqlservercentral.com/scripts/Miscellaneous/31492/Get SQL code Blocking and Blocked procs + Notifhttp://www.sqlservercentral.com/scripts/Mail/31482/2005/04/28http://www.sqlservercentral.com/scripts/Mail/31482/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31227/2004/11/09http://www.sqlservercentral.com/scripts/Miscellaneous/31227/