Are you drunk SQL Server? Where did that estimate come from? — Magnus Ahlkvist
Want to learn more about GroupBy’s Sponsors? Check them out below!
SolarWinds: https://loom.ly/WBIxdm0
Redgate: https://loom.ly/mWU0yLs
If you write T—SQL queries on a regular basis, you will have seen unexpected query execution plans, making you wonder ""Hmm.. Why did SQL Server decide to make one million lookups against this 100 row table instead of just scanning the whole thing once?"".
In this session, we will look at some really strange rowcount estimates and figure out how SQL Server came up with them.
Download Speaker Slides:
https://drive.google.com/file/d/1NusQ...