Home > Uncategorized > Talking about Stored Procedures vs Inline SQL: An interesting debate

Talking about Stored Procedures vs Inline SQL: An interesting debate

Another one of my old posts 🙂

Quote

Stored Procedures vs Inline SQL: An interesting debate

Read some interesting stuff today. These are really old blog entries, I just stumbled upon them today.
From SQL Server BOL this guys quotes:

SQL Server 2000 and SQL Server version 7.0 incorporate a number of changes to statement processing that extend many of the performance benefits of stored procedures to all SQL statements. SQL Server 2000 and SQL Server 7.0 do not save a partially compiled plan for stored procedures when they are created. A stored procedure is compiled at execution time, like any other Transact-SQL statement. SQL Server 2000 and SQL Server 7.0 retain execution plans for all SQL statements in the procedure cache, not just stored procedure execution plans.

The link is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_0nxv.asp.

He refers to a section called "Stored Procedures and Execution Plans".

The actual debate URLs:

Started by a post from Rob Howard (Microsoft ASP.NET Program Manager).

http://weblogs.asp.net/rhoward/archive/2003/11/17/38095.aspx

Frans Bouma and Thomas Tomiczek respond here:

http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: