Database Optimization

Useful links for optimizing the operation of Microsft SQL Server

• Query performancehttps://msdn.microsoft.com/en-us/library/ms190610.aspx
• General index design guidelines https://msdn.microsoft.com/en-us/library/ms191195.aspx
• Analyzing a query https://msdn.microsoft.com/en-us/library/ms191227.aspx
• Checklist for analyzing slow-running queries https://msdn.microsoft.com/en-us/library/ms177500.aspx