Snapshot Isolation has been in SQL Server since 2005, yet many shops still skip it. A simple example shows how it can reduce blocking transactions.
Watching the tempdb Version Store
Watch the tempdb version store with per-database space DMVs, find transactions that delay cleanup, and plan capacity from trends.
Preventing Overbooking When Two Sessions Grab the Last Seat
Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.
SQLAuthority Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008
At the August 30 Ahmedabad User Group meeting we talked about the quality of programmers and hiring, and why free user groups are great for developers.
ACID Properties Shown With Real Transactions
ACID properties shown With Real Transactions uses short SQL Server scripts to explain atomicity, consistency, isolation, and durability.





