The SQL Server 2005 engine
This area is for those things which relate to the database engine, so essentially those things which add performance and optimise how it all works. Areas covered include indexing and query optimisation.
- Analysing Indexes Part 1
- Analysing Indexes Part 2
- Analysing Indexes Part 3
- Analysing Indexes Part 4 - size does matter
- Worksheet for part 4
- Analysing Indexes Part 5 - Find redundant indexes
- Analysing Indexes Part 6 - Missing Indexes ?
- Covering a Clustered Index.
Using the dynamic management views to provide information on your indexes. Especially important with off the shelf packages, CRM, ERP applications and such. Identify unused, hot, low usage, inefficient indexes on your database.
This is the work in progress version of part 3
What factors influence the physical size of your indexes and hence how the optimiser may view them.
The worksheet with the result data - there are small comment tags which explain the tables - these are in small red numbers - you'll have to allow active content to view them
It can make sense to cover a clustered index - read why here..