1
vote
1answer
102 views

Can I limit the time a table lock is being held server side?

I have a SQL Azure server with some stored procedures with TABLOCKX hints that I call from C# code on a Windows Azure web role VM. I'm kinda paranoid about those hints - what if there's some network ...
2
votes
1answer
520 views

Database locked

I canceled a query which took too long time. After that, the SQL-Server database was locked. After I restarted SQL Server, the mode of my database was "in recovery". Now I can't access my database ...
6
votes
1answer
477 views

Deadlock graph with a lock on an index on a seemingly unrelated table

I have a deadlock graph from a deadlock where one process is doing a SELECT and one is doing an UPDATE. This seems like the classic case where the SELECT gets a NCI lock to perform a join and then a ...
2
votes
1answer
566 views

Sql server update query locking stages?

Looking at update MyTable set Status = 1 where Status = 0 of course- the where is calculated before the actual update. but does this filtering (where Status = 0) is also inside the lock ? I mean ...