THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Scripts » Caching   (RSS)
  • Viewing how much memory is used by not reused query plan

    One interesting observation that may help developers get convinced that they should parametrize query and that they must check that the ORM they use does it correctly is show how much memory can be wasted by plans that cannot be effectively reused. The following query can help on this: with cte as (     select ...
    Posted to Davide Mauri (Weblog) by manowar on July 23, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement