Topic - Performance and Indexes

Reading

http://en.wikipedia.org/wiki/Database_index - The main Wikipedia article on indexing is very good and quite thorough. You should have a handle on clustered vs. non-clustered indexes.

http://msdn.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx - Using Materialized (or indexed) views is a solid way to increase database performance. This is covered very well in this article.

Reference - http://msdn.microsoft.com/en-us/library/ms188783%28v=sql.105%29.aspx - CREATE INDEX syntax and documentation for SQL Server

Reference - http://msdn.microsoft.com/en-us/library/ms178071%28v=sql.105%29.aspx - Documentation for SQL Server execution plan

Lectures

Lecture - Monitoring Database Performance

Lecture - Database Indexing

Assignments

COP4709 Spring 2013 Assignments - Week 11 assignment.

COP4709 Course Lectures By Week