SQL Tuner

  IJCTT-book-cover
 
International Journal of Computer Trends and Technology (IJCTT)          
 
© 2016 by IJCTT Journal
Volume-33 Number-1
Year of Publication : 2016
Authors : Rohini Bhajipale, Poonam Bisen, Achal Meshram, Snehal Singh Thakur
  10.14445/22312803/IJCTT-V33P106

MLA

Rohini Bhajipale, Poonam Bisen, Achal Meshram, Snehal Singh Thakur "SQL Tuner". International Journal of Computer Trends and Technology (IJCTT) V33(1):29-32, March 2016. ISSN:2231-2803. www.ijcttjournal.org. Published by Seventh Sense Research Group.

Abstract -
SQL statements can be used to retrieve data from the any database. To get same results we need to write different SQL queries. For better performance we need to use best, faster and efficient queries. So we need SQL query tuning based on the business and user requirements. This paper covers how these SQL queries can be optimized for better performance. Query optimization subject is very deep but we will try to cover the most important points. In this paper we are focusing on, in-depth analysis of database and simple query tuning tips & tricks which can be applied to gain immediate performance gain.

References
[1] Sunderi Dejan, Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET, Third Edition, McGraw-Hill, 2006, ISBN:0072262281.
[2] Dave Pinal, SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader's Article. April 26, 2008.
http://blog.sqlauthority.com/2008/04/26/sql-server-optimizationrules- of-thumb-best-practices-readers-article/
[3] Dandan Li,SQL Query Optimization Methods of Relational Database System, Second International Conference on Computer Engineering and Applications,
[4] Andrei Volkov, SQL Server Optimization, http://msdn.microsoft.com/enus/ library/aa964133(v=sql.90).aspx.
[5] SQL Server 2005 Books Online, Introducing SQL Trace. http://technet.microsoft.com/en-us/library/ms191006.aspx.
[6] SQL Server 2005 Books Online, Understanding plan forcing. http://msdn2.microsoft.com/en-us/library/ms186343.aspx.
[7] SQL Tuning or SQL Optimization. http://beginner-sqltutorial. com/sql-query-tuning.htm
[8] SQL Server Optimization Tips, http://santoshgudise.weebly.com/uploads/8/5/4/7/8547208/sql_ser ver_optimization_tips-1.doc
[9] Optimize MS SQL Server http://omarabid.hubpages.com/hub/Optimize-MS-SQL-Server
[10] SQL Spark. http://sqlspark.blogspot.in/2011/07/best-waysto- write-sql-query.html
[11] MySQL Load Blancing PHP script. http://www.flteksolutions.com/
[12] What are the most common SQL Optimizations. http://stackoverflow.com/questions/1332778/what-are-your-mostcommon- sql-optimizations
[14] Index Optimization Tips. http://www.mssqlcity.com/Tips/tipInd.htm
[15] Review, Change, or Delete Transferred or Imported data. http://turbotax.intuit.com/support/iq/Import/Review--Change--or- Delete-Transferred-or-Imported-Data/GEN12079.html.

Keywords
SQL Query Optimization, Performance Tuning.