Overview
SQL query performance improvement is a very thought-provoking topic between developers and the user community. Users always wants a fast response on their data retrieval action and developers put forth their best efforts to provide the data in the shortest time, however, there is no straightforward way to define what is the best performance. Sometime it’s debatable what is good and what is bad performance of a query but overall if you follow best practices during development, you can provide the best query response to users and avoid such discussions.
You can choose multiple ways to improve SQL query performance, which falls under various categories like re-writing the SQL query, creation and use of Indexes, proper management of statistics, etc.
In this slideshow we discuss 10 different methods to improve SQL query performance.
About the Author:
Anoop has worked with Microsoft and has 13+ years of IT experience. He has worked on end to end delivery of enterprise scale BI/DW projects. He has a strong knowledge of database, data warehouse and business intelligence application design and development. Also, he worked extensively on SQL Server, designing of ETL using SSIS, SSAS, SSRS and SQL Azure.
Anoop is a Microsoft Certified IT Professional (MCITP) in Microsoft SQL Server and a Microsoft Certified Technology Specialist (MCTS). Anoop has a Post Graduate degree in Computer Science from Birla Institute of Technology, Mesra, India.
We discussed how SQL query performance can be improved by re-writing a SQL query, creation and use of Indexes, proper management of statistics and we revisited schema definitions. There are many more areas that can be looked at to improve the SQL query performance like using query hints, table hints and plan hints, etc.
Overall we explored 10 different ways to improve SQL query performance, which isn't much for this subject. You can come across many other ways with your experience and deeper knowledge of your SQL query execution plan to get better performance. You can also refer previous articles to understand SQL query execution plan and its operator.
http://msdn.microsoft.com/en-us/library/ff647793.aspx
http://msdn.microsoft.com/en-us/library/ff650689.aspx
http://technet.microsoft.com/en-us/library/ms172984.aspx
Advertiser Disclosure: