Events at this location

In this Precon Torsten Strauß (MVP, MCT, MSCE) will provide deep insights into the mystery of Query Optimizer and how to interpret execution plans to optimize query performance in SQL Server.
We will also cover in this session the impact of stale statistics and parameter sniffing, how some prominent iterators work, and the downside of parallelism to better understand and ultimately fix the root causes of performance issues.
This session will be code-based to prove and disprove theory in practice if necessary.

Concurrent inserts into a clustered table with an ever-increasing key become a bottleneck since Microsoft SQL Server must protect the corresponding pages with a page latch. There are several techniques like, hash partitioning, reserve bits, in-memory OLTP and the feature introduced in 2019 CTP 3.1 called OPTIMIZE_FOR_SEQUENTIAL_KEY. We will compare these features to understand their performance improvements and the effort required to modify your existing application