SQL Server execution-plans-3 book cover

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

SWAG Saves the Day

By

PASS Summit East is in one week. I was on the road last week...

Upgrading SQL Server Containers on the Laptop

By

I don’t have SQL Server installed on my laptop. In an effort to keep...

Read the latest Blogs

Forums

BCA KCP Intercon Megah Telpon/WA:08137887595

By tanehome

BCA KCP Intercon Megah Telpon/WA:08137887595.Komp.Intercom Megah, Jl. Joglo Raya Blok W-IV No.27, Srengseng, Kec....

BCA KCP Kreo Ciledug Telpon/WA:08137887595

By tanehome

BCA KCP Kreo Ciledug Telpon/WA:08137887595.Jl. HOS Cokroaminoto Jl. Ciledug Raya, RT.001/RW.006, Kreo Selatan, Kec....

BCA KCP Penjernihan Telpon/WA:08137887595

By tanehome

BCA KCP Penjernihan Telpon/WA:08137887595.Jl. Penjernihan I No.23, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers