February 24, 2009 at 11:19 pm
Hi friends,
Is any tutorial or useful link for stored procedure optimization with example.
I searched in google.But it is not enough. Please if you know send me,
Hope your's reply.
Thanks & Regards
February 24, 2009 at 11:39 pm
Hi
The following link is giving some useful information
http://www.sqlservercentral.com/articles/Performance+Tuning/ospr/666/
Latha
February 25, 2009 at 5:41 am
You just won't get enough information from an article for stored procedure optimization. What you need is a book. I'd suggest Itzik Ben-Gan's SQL Server 2008 T-SQL Fundamentals or Inside SQL Server 2005: T-SQL Querying. Those are excellent starting points. You might also check out Joseph Sack's SQL Server 2008 T-SQL Recipes.
Articles, like the one linked above, are going to focus on a tiny topic of tuning, like recompiles. That's only a small piece of the pie.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2009 at 9:07 am
Also Inside SQL Server 2005: Query Tuning and Optimisation which, as it's name implies, is an entire book on query tuning and optimisation.
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
February 26, 2009 at 4:01 am
I've always found http://www.sql-server-performance.com/ to be pretty useful.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy