| Length:
2 Days
|
|
Prerequisites:
Prior knowledge of SQL and T-SQL |
Key
Benefits:
-
Learn how SQL Server selects indexes
Learn how to interpret SQL Server optimizer results
Understanding indexing internals
Learn how the optimizer works with single-tab
lookups, joins, and complex queries
|
| Other
Course Features:
Detailed Lab/Workshop Solutions
Instructors are hands-on Database Administrators.
They will share their experiences while teaching the
course material.
|
| Course
Description:
Soaring
Eagle presents "Indexing for MS SQL Server 2005". In
this course you will learn index selection as it was
taught to Microsoft internal engineers, from how the
server selects indexes, to index storage structures, to
how to quantify whether your index is working better
than another.
The instructors and authors of the materials bring years
of general database systems experience to the attendees.
All are experienced MS SQL Server professionals ready to
add their insight to the classroom environment.
|
| |
| Topics
Covered:
|
|
|
- Introduction to
Performance
- Query Analysis
Tools
- SQL Statement
Processing
- Indexing
- Single Table
Optimization
- Join Processing
- Subquery
Processing
- Views
- Unions
- Indexing and
cursors
- SQL-Specific
Problems (optional)
|
|
|
|
