SQL Server scripty a tipy

Microsoft SQL Server Versions List

SQL SERVER – List Expensive Queries – Updated March 2021 – SQL Authority with Pinal Dave

SQL SERVER – Missing Index Script – Download – SQL Authority with Pinal Dave

SQL SERVER – Unused Index Script – Download – SQL Authority with Pinal Dave

Downgrade SQL Server edition by In-Place method!

Windows User Group – Czech Republic

Brent Ozar Blog

So You Wanna Build an App

I get a lot of emails like this: Hi! I built an app. Can you take a look at it, give me your feedback, and then help get the word [...]

You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.

When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually executed. It’s easy to miss whole swaths of code that didn’t happen [...]

There Are Days When I Feel Like Giving Up on the Plan Cache and Query Store.

In theory, SQL Server performance monitoring is pretty simple: Review the server’s top wait types Find the queries causing those wait types Fix those queries, or improve the way the [...]

Contest Winners: Make the Comments Look Like My ChatGPT History.

I asked y’all to make the comments on this post look like my ChatGPT history, and y’all understood the assignment. The answers were all over the place from accurate to [...]

Kendra Little Blog

Bad News, DBAs, We Are All Developers Now

I sometimes joke that I’m a Junior Developer and a Principal Database Administrator, which is why I have a Staff level title. I’m not sure it’s a joke anymore, though. [...]

Adaptive Joins and Memory Grants in SQL Server

Adaptive joins let the optimizer choose between a Hash Join and a Nested Loop join at runtime, which can be fantastic for performance when row count estimates are variable. Recently, [...]

Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

I see this pattern repeatedly: a “wide” query that returns many columns and less than 100k rows runs slowly. SQL Server gets slow when it drags large amounts of baggage [...]

Testing SQL Server 2025 Resource Governor tempdb Limits with a Query that Spills a Terabyte

SQL Server 2025 introduces a new Resource Governor capability to manage tempdb usage, along with making Resource Governor available in Standard Edition. I wondered: can Resource Governor’s new tempdb feature [...]

How to Trace Trigger Executions with Query Store and Extended Events

Triggers can be tricky to observe in SQL Server. When you need to understand exactly what a trigger is doing and what it impacts, Query Store and Extended Events both [...]

Useful Links