Conor vs. SQL

Conor Cunningham's blog on SQL Server, data-driven applications, and pretty much whatever other random stuff he decides to post.

This Blog

Syndication

Search

May 2009 - Posts

Posted Monday, May 25, 2009 1:39 PM

Conor vs. Recompiles, part 2

Thanks to those of you who replied to my previous post. I spent the last week or so talking with customers, coworkers, and looking at various applications to see how recompiles are modeled today in their applications. At a high level, SQL Read More...

by Conor Cunningham [MSFT] | 2 Comments

Filed under: recompiles, plan choice

Posted Monday, May 18, 2009 1:45 PM

Conor vs. Recompiles

I have a question for you guys about how do you force a recompile for a single query today? There are a lots of different ways that one could cause the system to recompile a query: a) sp_recompile <object used in a query> b)DBCC FREEPROCCACHE Read More...