April 24, 2013 at 5:34 am
Hello All....
I am a fresher in an MNC and have been assigned the task of optimization. I am working on Sql Server 2000 for database support. So, can anybody help me out in getting the list of things which i can look into while optimizing the code in SQL?? It will be better if i get something on optimizing at logical level.
Here is a few things which i look into....
1) Removal of Cursors
2) Removal of unused variables
3) Prefixing qualified name "dbo." while calling Stored Procedures
4) Replacement of multiple 'Set' statements with a single select statement.
5) Removing unnecessary BEGIN or END
6) Taking care of numeric precisions while declaring variables
7) Replacing 'Else If' conditional blocks with 'Case' statement blocks
So, other than these things can i get something better on optimizing from logical point of view??? 🙂
April 24, 2013 at 5:47 am
rohit11.jagannath (4/24/2013)
2) Removal of unused variables
Code cleanup, not much to do with optimisation
4) Replacement of multiple 'Set' statements with a single select statement.
That's more a style decision than anything else in most cases.
5) Removing unnecessary BEGIN or END
Code cleanup, not much to do with optimisation
7) Replacing 'Else If' conditional blocks with 'Case' statement blocks
SQL doesn't have a CASE that can replace if/else blocks. SQL's case is a part of a select/insert/update/delete statement
Take a read through this, yes, it's SQL 2008, most of the principals apply.
http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025
Optimisation is about making queries run faster, through code changes or indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2013 at 7:39 am
Thank You....:-) Since i am still in the beginning stages of developing queries in SQL or rather optimizing them, how exactly should i cultivate the skills of SQL???
April 24, 2013 at 8:55 am
Practice, practice, practice and a hell of a lot of reading.
Start with you basic skills in writing queries. If you don't know how to write queries well, you won't be able to tune them effectively.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply