TIP: Managing Stored Procedures with Multiplication

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.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish