troubleshootingsql.com
Why can I not produce the same plan with a copy of the production database?
This question has been asked multiple times for SQL Server 2005/2008 environments. Well, the answer is SQL Server has become a bit smarter when it comes to the Query Optimizer. Now it takes into ac…