OPTIMIZE FOR UNKNOWN – a little known SQL Server 2008 featurehttp://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-for-unknown-a-little-known-sql-server-2008-feature.aspxUsing parameterized queries is a well known SQL Server Best Practice. This technique ensures caching and reuse of existing query execution plans (instead of constantly compiling new plans), as well as avoiding SQL injection by mandating that input dataen-USCommunityServer 2.1 SP1 (Build: 61025.2) Consider Data Distribution when using OPTIMIZE FOR UNKNOWNhttp://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-for-unknown-a-little-known-sql-server-2008-feature.aspx#9269675Fri, 02 Jan 2009 23:50:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:9269675 Consider Data Distribution when using OPTIMIZE FOR UNKNOWN<p>PingBack from <a rel="nofollow" target="_new" href="http://joesack.com/WordPress/?p=221">http://joesack.com/WordPress/?p=221</a></p>OPTIMIZE FOR UNKNOWNhttp://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-for-unknown-a-little-known-sql-server-2008-feature.aspx#9284471Tue, 06 Jan 2009 05:50:31 GMT91d46819-8472-40ad-a661-2c78acb4018c:9284471Strate SQL<p>A good performance tuning trick in SQL Server 2008 from the SQL Programmability team and a response reminding everyone that it isn't a silver bullet from Joe Sack. ...</p> OPTIMIZE FOR UNKNOWNhttp://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-for-unknown-a-little-known-sql-server-2008-feature.aspx#9290405Thu, 08 Jan 2009 00:31:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:9290405Strate SQL<p>A good performance tuning trick in SQL Server 2008 from the SQL Programmability team and a response reminding</p> Consider Data Distribution when using OPTIMIZE FOR UNKNOWNhttp://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-for-unknown-a-little-known-sql-server-2008-feature.aspx#9293227Thu, 08 Jan 2009 06:41:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:9293227Joe Sack's SQL Server WebLog<p>The Microsoft SQL Programmability &amp;amp; API Development Team Blog recently posted an excellent article</p> OPTIMIZE FOR UNKNOWN - How could that possibly make any sense???http://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-for-unknown-a-little-known-sql-server-2008-feature.aspx#9328926Fri, 16 Jan 2009 18:55:23 GMT91d46819-8472-40ad-a661-2c78acb4018c:9328926Conor vs. SQL<p>Yes, I'm alive. I have been chatting with my wife about the times I need to &quot;go dark&quot; - in this case,</p>