Jeremiah Peschka, SQL Server Developer

Marco Russo posted about a possible LINQ to SQL performance problem.
Using AdventureWorks for our sample, we might have a stored procedure to select from the Production.Product table:
[viewcode] src=”http://facility9.com/files/2008/08/create_getproductbyname.sql” showsyntax=”no” link=”yes” [/viewcode]
Calling this procedure will always use the same cached execution plan and will only be re-compiled if/when the procedure is consciously changed by a DBA [...]