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

Content with tag 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,343 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2009/10/29 | Source: | Category: date
Rating: |  Discuss |   Briefcase | 8,109 reads
   Items 1 to 2 of 2   
cache bloat (1)    
calculate (1)    
calendar (1)    
complex (1)    
date (1)    
dimenson (1)    
forced parameterization (1)    
populate (1)    
reference (1)