Inside Microsoft® SQL Server™ 2005

Conclusion

There’s a lot to consider when developing applications for multiple concurrent users working with SQL Server. Most importantly, you have to understand the concurrency vision implemented in the product. SQL Server 2005 introduces new snapshot isolation levels, providing you with different concurrency models to choose from.

This chapter covered the fundamentals required when developing applications to allow multiple users to work concurrently. It covered transactions, lock resource types, lock modes, isolation levels, savepoints, and deadlocks.