Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
TIP: Managing Stored Procedures with Multiplication
Sometimes, T-SQL stored procedures are too large to manage. Often, using multiple shorter stored procedures is better than using one long stored procedure.
William Vaughn
April 1, 2004
1 Min Read
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.
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)