Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 456 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Writing efficient Stored Procedures - A Case Study


 Article Abstract:

(By G.R. Preethiviraj Kulasingham)
Performance optimization of Stored Procedures for developers. This article is a case study, which re-writes a stored procedure in differnet ways in order to optimize the performance.

 Read this article...

 Related Articles - For Members.
All Articles By Author

Second Normal Form (2NF)
SQL Server 6.5: Some useful undocumented DBCC commands
SQL Server 2000 useful undocumented stored procedures
SQL Server 2005 XML Optimization Tips
SQL Server 7.0: index statistics details
Stored Procedures Administration
Tips for using SQL Server 2005 stored procedures
Meta Data User-Defined Functions
Automate Database Defragmentation and Statistics Updates
SQL Server 7.0 useful undocumented stored procedures



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content


Reader Comments: Post Your Comments/Feedback

RE: Writing efficient Stored Procedures - A Case Study
by Ralph Wilson (posted: 5/16/2008 11:04:20 AM)
For whatever reason, this article flowed off the right side of me browser. In fact, I had to shift to the right _3_ times in order to read all of one line. Now, I don't know whether this is a fault of the author's choice of a formatting or editing tool or a fault of the web site's formatting or some combination of/interaction between the two but it made the article extremely difficult to read and, therefore, of little use even though the information may be worthwhile.



RE: Writing efficient Stored Procedures - A Case Study
by Preethiviraj Kulasingham (posted: 5/21/2008 11:39:44 AM)
Hi Ralph,
Thank you for the comment. In fact it is a mistake I made in formatting the table (within the article) which made the entire article to spread. Regret for it. If you want to read it, please copy the article into word or copy the article into into two/three parts(before the table, table and after the table) into a browser and you can read it.

Regards,
Preethiviraj Kulasingham



Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   




 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004