Binu Kumar
10 December 2015

SQL Query writing: Best practices

Binu Kumar 10 December 2015

About Binu Kumar

Project Manager in .Net and its related technologies. Banking on 7+ years of experience in various development verticals like Finance, Sales, Travel/Tourism, Healthcare, CRM etc, has also a proven track record of handling multiple european customers at same time. Actor of various roles and responsibilities like Developer, Lead, Manager, scrum master, trainer/mentor and as a decision maker.

5 thoughts on “SQL Query writing: Best practices

  1. On Addition to the above points, i would like to suggest ,
    Practice proper use of CASE statements.
    Try to avoid using, Updates to temporary tables or unnecessary UNION’s in your Query. Instead practice proper use of CASE.

  2. As most of us are using SQL server Management Studio Express IDE, its easy to see the execution plan and missing indexes. In the tool bar itself there is an icon that says ‘Include Actual Execution plan (Ctrl + M)’. You can use it to measure the performance of query.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>