“In this series of blogs, I want to show some common concurrency questions that we get asked by customers. Before we look into common concurrency issues seen by customers, it will be good to review the transaction isolation levels provided in SQL Server.
Some interesting posts about SQL Server and concurrency. Concurrency isn’t magical and while SQL Server helps, all it takes is one human to tank your app’s through-put…
Here’s the series TOC to date;
- Concurrency Series: Basics of Transaction Isolation Levels
- Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
- Concurrency Series: Why do I get blocked when no one has locked the row(s) being queried?
- Concurrency Series: Minimizing blocking between updaters
- Concurrency Series: My application was running fine yesterday but why is it blocking today?
SQL Server 2008 Full Text Search Best Practices from the SQL CAT Team
SQLCAT.com - The "Level 500" SQL Server Resource