In this article we look at things you should know to help tune and optimize your SQL Server queries.

• Always Check the Execution Plan
• Find the Operators that have Highest Cost
• Look for Warnings
• Arrows Between Operators Provide Good Insight
• Execution Plan Properties Window
• Index Suggestions