• [April 2, 2004]
  • TIP: Managing Stored Procedures with Multiplication
  • By:  William Vaughn
  • Features
  • InstantDoc #42244
  • Web Exclusive from SQL Server Magazine
Subscribe to SQL Server Magazine | See More Database Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

T-SQL stored procedures can be too large to manage. If the query optimizer gives up trying to come up with a good query plan (and it will if it feels the query is too complex), you need to simplify your stored procedure. Executing four 100-line stored procedures is often better than executing one 400-line procedure.

End of Article


Post Your Comments Here

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now

 
 

ADS BY GOOGLE