I’ve been working on writing a new Microsoft white paper since January covering the main changes made in the SQL Server 2014 Cardinality Estimator, and happy to announce that it was just published: Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator A big thanks to the contributor and reviewer team – including […]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
Posted on: April 14, 2014 10:30 am
Finding Timeout-Prone Code with max_elapsed_time
Posted on: April 8, 2014 7:04 am
Consider a scenario where your application timeout setting is 30 seconds and you’ve been asked to proactively start tuning workloads that are at risk of timing out. There are several different places you can start, and I want to demonstrate an additional option today. To demonstrate timeout settings, I can configure it in SQL Server […]
Deck from “Practical SQL Server Cardinality Estimation”
Posted on: April 2, 2014 7:41 am
I uploaded the deck from my session for SQLSaturday #287 Madison 2014 and you can download it here. It was an excellent event! Great organizers, volunteers, venue, speakers – and a matching big turnout with lots of first-time SQLSaturday attendees. Grateful for the experience and hope to be back again next year.
