Monthly Archives: April 2010

Best Practices Analyzer (BPA)

As per the CSS blog entry SQL Server 2008 R2 BPA is based on the new Microsoft Baseline Configuration Analyzer (MBCA) v2.0 is coming soon…   http://blogs.msdn.com/psssql/archive/2010/04/22/europe-pass-a-volcano-live-meeting-and-sql-2008-r2-bpa.aspx      

Posted in SQL Server 2008 | Leave a comment

Parameter Sniffing trace flag 4136

Microsoft has released Cumulative Update Package 7 for SQL2008 SP1 (KB797065). In this update there is a new feature (trace flag 4136) that let us control the Query Optimizer should do parameter sniffing (KB980653) or NOT.   Improve Performance on … Continue reading

Posted in SQL server | 11 Comments