Tips and Tricks for SQL Server tuning - SMT_Stories

Why is using proper ANSI settings important

by Jiri Dolezalek on 20/05/2021

You might have been wondering what all those ANSI settings are and how they can affect you work.

SMT_Stories Read more

Archiving strategy for DWH

by Michal Tinthofer on 22/04/2021

Recently, we have got a case where our customer requested to implement archiving strategy for their DWH. We wanted to share with you how we approached this and what was the final output.

SMT_Stories Read more

How a High-Frequency LIKE Query Saturated SQL Server

by Michal Kovaľ on 05/03/2021

A customer’s SQL Server instance reached 100% CPU utilization. Blocking increased, response times deteriorated, and unrelated workloads slowed down. The cause was a Camunda worker query executed roughly 100 times per second in one database and 40–50 times

SMT_Stories Read more

Conquering Deadlocks: How We Achieved a 93% Reduction in Database Blockages

by Michal Kovaľ on 15/10/2020

In high-concurrency environments, deadlocks are more than just technical glitches...they are silent performance killers.

SMT_Stories Read more

The Case of the Vanishing Databases: A Deep Dive into HADR Deadlocks

by Michal Kovaľ on 14/07/2020

Imagine opening SQL Server Management Studio (SSMS) on a Monday morning and finding… nothing.

SMT_Stories Read more