posts - 230, comments - 423, trackbacks - 27

My Links



Follow billgraziano on Twitter

Article Categories


Post Categories


SQL Server

May 2007 Blog Posts

Presentation: Understanding the Procedure Cache: Writing Efficient, Reusable Queries

If you're in the Kansas City area tomorrow night I'm going to be doing a presentation on the procedure cache, parameterization and parameter sniffing.  Details are on the Kansas City SQL Server User Group web site.  I'm a last minute fill in but this is a presentation I've been working on for a while.  Just to get you started I'll post two queries that I use in the introduction: SELECT sum(single_pages_kb) AS Single_Pages_KB , sum(single_pages_kb) / 1024 AS Single_Pages_MBFROM sys.dm_os_memory_cache_counters SELECT LEFT([name], 20) AS [Name], LEFT([type], 20) as [Type], ...

posted @ Wednesday, May 09, 2007 3:18 PM | Feedback (2) |

Powered by:
Powered By Subtext Powered By ASP.NET