Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Forced Parameterization Rss

   Items 1 to 2 of 2   

Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization

Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe case of 'Cache Bloat' due to ad-hoc queries, but you can't fix the code itself. What should you do? Specify forced parameterization? Perhaps a better idea would be to use guide plans.   Read more...
By Additional Articles 2014/03/04 | Source: SimpleTalk | Category: parameterization
Rating:  Rate this |   Briefcase | 2,472 reads

SQL Server Simple and Forced Parameterization

I have heard about parameterization for SQL Server queries, but what is Forced and Simple Parameterization and which one should I use for my SQL Server database?  Read more...
By Additional Articles 2013/05/10 | Source: | Category: forced parameterization
Rating: (not yet rated)  Rate this |   Briefcase | 5,120 reads
   Items 1 to 2 of 2   
cache bloat (1)    
parameterization (1)    
simple parameterization (1)