Did you know that when you change the recovery model of a database – plans for that database are removed from cache ? I didn’t… SQL 2012 :- I was doing some performance tuning today, using DMV sys.dm_exec_query_stats to look at summary information for database performance. I normally find this a very useful DMV as