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 3 of 3   
 

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 2014/10/03 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 9,278 reads

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,362 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 2014/10/03 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 9,278 reads
   Items 1 to 3 of 3   
 
Tags
cache bloat (1)    
calculate (1)    
calendar (1)    
complex (1)    
date (1)    
dimenson (1)    
forced parameterization (1)    
populate (1)    
reference (1)