SqL Query performance issue

SqL Query performance issue

References

Reference NO 1

http://www.infoworld.com/d/data-management/7-performance-tips-faster-sql-queries-262

Reference NO 2

http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.developer.soa.doc/refs/rsdperformanceworkspaces.htm

Reference NO 3

http://technet.microsoft.com/en-us/library/ms172984.aspx

Reference NO 4

http://www.quest.com/whitepapers/10_SQL_Tips.pdf

Reference NO 5

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Reference NO 6

http://stackoverflow.com/questions/15204290/sql-query-performance-issue

Reference NO 7

http://www.mssqltips.com/sql-server-tip-category/9/performance-tuning/

Reference NO 8

http://www.componentace.com/help/absdb_manual/increasesqlperformance.htm