Sql Query coding guidelines with respect to perfomance turning(Do's and Donts)

Hi team,

I am a performance Engineer trying to review the sql queries in application code and find any performance issues.

do we have any Sql Query coding guidelines with respect to performance turning, which has some inputs with respect to Do's and Dont's

August 27th, 2015 9:41am

Hi,

This question is too general ;-(
I recommend you use Google and search for: sql server query tuning

You can download this presentation but without the speaker recording I am not sure how much it can help:
http://www.sqlpass.org/eventdownload.aspx%3Fsuid%3D73

Free Windows Admin Tool Kit Click here and download it now
August 27th, 2015 2:43pm

Hi,

Please refer below PPT and some useful articles, that will help you to understand.

Writing SQL Queries: Let's Start with the Basics

SQL Server Performance Tips and Guidelines

SQL - Quick Guide

http://www.radford.edu/~cshing/340/lectures/databasetuning.ppt

http://www.slideshare.net/Tess98/database-tuning-in-ppt

http://www.solarwinds.com/database-performance-analyzer-sql-server.aspx

August 27th, 2015 3:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics