Tips and Tricks for SQL Server tuning

The Mystery of the Slow FAST_FORWARD Cursor in SQL Server

by Michal Kovaľ on 14/10/2026

Why even TYPE_WARNING fails to reveal hidden data materialization in tempdb, and how adjusting the sort order reduced form response time from 30 seconds to milliseconds.

SMT_Stories Read more

SMT 1.14.1 – Memory Grants & Plan Explorer

by Michal Tinthofer on 13/08/2026

Introduces advanced SQL Server Memory Grants analysis, production-ready Plan Explorer, Row Accuracy and major monitoring improvements.

SQL Server SMT Performance Monitoring Memory Grants Execution Plans Query Tuning Read more

Clustered Columnstore Index in an OLTP Database? Hell Yeah.

by Mikuláš Mráz on 30/07/2026

If you haven't been living under a rock for the last 10 years (14 if you count the read-only days), you've probably heard about SQL Server's columnstore engine.

SMT_Stories Read more

SMT 1.14.0 – Custom Pages, Plan Guides and New Charts

by Michal Kovaľ on 19/06/2026

We are pleased to announce SMT 1.14.0, one of the most significant SMT releases to date. This version introduces Custom Pages, a completely redesigned chart engine, advanced query recompilation analysis, Plan Guide management, monitoring controls directly

SMT Read more

When SQL Server 2022 Talks Too Much to Windows: Solving the PREEMPTIVE_OS_QUERYREGISTRY Mystery

by Michal Kovaľ on 28/05/2026

You open your performance analytics tool to check the top wait types, expecting the usual suspects like PAGEIOLATCH or CXPACKET. Instead, staring back at you is a strange, rarely seen wait type: PREEMPTIVE_OS_QUERYREGISTRY.

SMT_Stories Read more

SQL Day 2026

by Mikuláš Mráz on 22/05/2026

Last week, between the 11th and 13th of May 2026, we once again returned to SQL Day in Wrocław.

SQL Server SMT SQL Day Conference Wroclaw Read more