Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Stored Procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-18 : 09:00:04
Yogesh writes "How can we optimize a stored Procedure ?"

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-18 : 09:03:00
Use your experience.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-05-18 : 09:32:13
The procedure will be more compact, and thus more efficient, if you eliminate all spaces between words.
Go to Top of Page
   

- Advertisement -