I presented three sessions at SQLLive 360 in Orlando, Florida, on November 19 and 20, 2013. It was my first time in Orlando. These are my notes from the event, with a few photos.
Why the Same Query Is Fast Then Suddenly Slow
Recognize parameter sniffing by comparing compiled values, data distribution, and reused plans, then test a remedy with its tradeoffs.
SELECT * Cost: Why Wide Result Sets Slow Exports
The query starts fast but the export crawls. A small demo shows how much a wide text column adds, and what to measure on your own server.
Real-Time Operational Analytics With a Filtered Columnstore Index
Build real-time operational analytics with a filtered columnstore index, inspect batch-mode plans and rowgroups, and measure write costs.
An Index Seek That Reads Millions of Rows: Residual Predicates
Diagnose an index seek that reads far more rows than it returns by checking residual predicates, Actual Rows Read and index key order.
Rewriting OR Conditions So the Index Gets Used
Rewrite OR conditions with separate seeks, preserve duplicate and NULL behavior, and compare plans before choosing UNION or recompilation.
SSRS Parameters That Do Not Slow Reports
SSRS parameters work best with selective defaults, compact value lists, and SQL queries that preserve useful indexes under real filters.