New Extended Events in SQL Server 2022
SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is...
2022-05-24
23 reads
SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is...
2022-05-24
23 reads
Foreword
I’ve started to play Lego Video games with my daughter, and since it’s one of her first games, it can be a little frustrating.
Even though there are no high...
2022-05-21
5 reads
Foreword
I’ve recently had to revisit this topic and spent a lot of time recalling the details. So I’m writing this blog post mainly as a reminder for myself.
The most...
2022-05-12
14 reads
⚠️ It’s hard to convey sarcasm over the text. I’m putting this disclaimer at the top so I don’t come off egoistic. This post is meant as hyperbole, and...
2022-04-13
15 reads
The problem
As a fan of Dynamic Management Objects (DMOs), Query Store and Extended Events, I often work with the Query Hash and Query Plan Hash (I’ll refer to them...
2022-04-11
29 reads
Foreword
I was always wondering what the KEEP PLAN hint does. The documentation isn’t very specific (emphasis mine):
Forces the Query Optimizer to relax the estimated recompile threshold for a query.
In...
2022-04-07
60 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers