Opening sa login properties in SSMS failed with Property IsLocked is not available for Login. I used Profiler to find the query returning NULL, and here is the fix.
Finding Hot Tables With sys.dm_db_index_usage_stats
Identify hot tables with index usage, lock and latch counters, table sizes, and retained snapshots that describe a real workload interval.
SQL SERVER – Find Blocking Using Blocked Process Threshold
My friend Jim came back with more blocking questions. Here is how the blocked process threshold option, a feature hidden in plain sight, helps find blocking.
SET XACT_ABORT ON: Stopping Timeouts From Leaving Open Transactions
Use SET XACT_ABORT ON to prevent client timeouts from leaving transactions and locks open, with TRY CATCH and a sleeping-session query.
A Shrink That Stops Blocking Others: SHRINKFILE WAIT_AT_LOW_PRIORITY
A shrink at 4 PM on Friday can block your whole app. See what the low-priority option does, and why shrinking is still a rare tool.
The Outbox Table: Publishing Changes Reliably From a Transaction
Orders commit and the message vanishes? Save both in one transaction, then let a worker claim, send and retry with a lease. Duplicates are still possible.
Snapshot Isolation Update Conflicts: Handling Error 3960
Reproduce snapshot isolation update conflict error 3960, compare read committed snapshot, and retry the whole transaction safely.