Seeks seeks seeks… The number of the beast. Seeks are cool though. I like seeks. Sometimes, at least. Perhaps some seeks are cooler than others. I just said seeks six times, now we’re ready to go. Let’s begin by creating… Read More ›
#sqlserver
Performance Woes & Wows #2: LIKE ‘%Make This Query Go Slower Please%’
Sargability is a funny word that’s used to characterize the ability of the engine to take advantage of and index, in order to speed up the execution of a query. The legend says that it is derived from a contraction… Read More ›
Deny User Logins
Imagine that you live in a world where you need an applicational user with god-like powers because, in fact, it needs to. If you want to make sure that applicational users are only used by the application you’ll have to… Read More ›
Slow Query Store
I’m in a SQL Server 2016 database trying to view the Top Resource Consuming Queries. Since this database has Query Store enabled, I went to Query Store > Top Resource Consuming Queries and the usual screen pops-up, as the data… Read More ›
It’s All About Stats!
Statistics shape the way executions plans are built and have a massive impact on query performance. In order to achieve a better understanding on this relation, we will start to briefly explore what happens when a query is executed and… Read More ›
Performance Woes & Wows #1: Implicit Conversions
Implicit conversion… Sounds very clever, so it can’t be that bad, right? Well, in fact, implicit conversions can be huge performance killers and silent enough to stay off the radar, if we are not aware. The good news is that… Read More ›
MemoryGrantInfo Info
As suggested by the title, I like redundancy, bad titles and we’re going to have a brief look into MemoryGrantInfo. In a previous post, we’ve talked about an awesome feature from the new SQL Server 2019 – Row Mode Adaptive… Read More ›