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
Comments (0)
You don't have permission to comment on this page.