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
Assignments
Go to Assignments