Home >
SQL Server >
SQL Server 2005 - Snapshot Isolation
SQL Server 2005 - Snapshot Isolation
| Course Code: |
SQSSNA |
| Duration: |
1 day |
| Audience: |
Developers, programmers and database administrators. |
| Prerequisites: |
At least six (6) months of relational database experience. |
| Summary: |
This presentation details how to use SQL Server 2005's new
isolation levels for lock avoidance and read consistency, mainly
in OLTP environments. |
| Objectives: |
Upon completion of this presentation, the participant should
understand SQL Server 2005's:
- Concurrency controls
- Isolation levels
- Snapshot isolation
- Row versioning
- Isolation level usage and good practices
- How to monitor isolation levels
|
| Format: |
Lecture
|
Detailed Outline |
|