By tag: Locks
0
kicks
SQL Server 2005: Immediate Deadlock notifications
Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment. That's why it's crucial to have as much information about them from the production environment as possible. This is one way of getting it immediatly when it happens,
0
kicks
SQL Server 2005: Get full information about transaction locks
Get information about what locks are being held by the transaction, what SPID owns the transaction, on which objects the locks are being held, what SQL statement caused the locks, etc...
0
kicks
SQL Server 2008: Locking with MERGE statement compared to Update/Inser
How SQL Server 2008 MERGE statement locking compares to the locks held when doing "update if exists, insert if not" problem in SQL Server 2005.
0
kicks
SQL Server: Best way to Update row if exists, Insert if not
This question pops up a lot everywhere and it's a common business requirement and until SQL Server 2008 doesn't come out with it's MERGE statement that will do that in one go we're stuck with 2 ways of achieving this. The biggest problem with every update/insert (upsert for those who haven't heard t...