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

Content with tag plan cache Rss

   Items 1 to 2 of 2   
 

Find Single use plans in Plan Cache

This script will return all the Adhoc Single use Plans currently in your Plan Cache. It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008   Read more...
By SQLSACT 2012/12/11 | Source: SQLServerCentral.com | Category: plan cache
Rating: |  Discuss |   Briefcase | 580 reads

sp_prepexec and nHibernate

SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.  Read more...
By David Poole 2011/12/08 | Source: SQLServerCentral.com | Category: sp_prepexec
Rating: |  Discuss |   Briefcase | 7,976 reads
   Items 1 to 2 of 2   
 
Tags
execution plan (1)    
nhibernate (1)    
sp_prepexec (1)