Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2005, Advanced Querying, Performance Tuning Rss

   Items 1 to 1 of 1   

Introduction to Parameterization in SQL Server

In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL   Read more...
By Additional Articles 2007/08/14 | Source: | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,144 reads
   Items 1 to 1 of 1