Microsoft SQL Server

Query Cached Execution Plans

Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment. There are several techniques for simulating the environment on a test server such as exporting statistics…

SQL Server 2012 SP2 released

Microsoft SQL Server 2012 SP2 is now available Build number: 11.0.5058.0 Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP2. This service pack contains up to and including…