The foundation of tuning queries is understanding the fundamental basics, and it all started with the blogs of Craig Friedman explaining executions plan. Originally this was a Microsoft Blog (blogs.msdn.microsoft.com) but it was moved several times. I have copied all the content and will reproduce all the t-sql statements against SQL Server 2025.
People like Itzik Ben-Gan, Erik Darling, Brent Ozar and many others sometimes mention Craig. I will categorize it in this blog and present the blogs in order they once appeared online, we go back to the year 2006…
“Craig Freedman has nearly two decades of experience designing and implementing relational database servers, including 13 years as a Principal Software Design Engineer with the Microsoft SQL Server query processing and in-memory OLTP teams. He holds a Ph.D. from the University of Wisconsin-Madison where he researched parallel file systems and video on demand. Craig enjoys living and playing in the Pacific Northwest with his wife, two children, and dog.“