Let’s talk about some of our exciting success stories with customers. You may find value in how we approached various cases. It could be more of a discussion than a presentation. We want to talk about several cases: Tracing the sync/async column statistics update and its impact on execution plans. Columnstore index builds background task issues. Real-life partitioning solution to archive data in under one second. How to bulk insert data faster than to heap. How to monitor and tune recursive triggers containing dynamic TSQL constructs? Or chains of triggers firing other triggers? Extended Events and SMT monitoring help! We will go through our real-life cases and how we handled them.