Part 4 of my series on Craig Freedman’s SQL Server query-processing blog (part 3, August 2006, is here). September 2006 is aggregation month: how GROUP BY, DISTINCT and the aggregate functions actually execute, plus a closer look at scalar subqueries…
Part 3 of my series on Craig Freedman’s classic SQL Server query-processing blog (part 2, July 2006, is here). August 2006 was join month: the two remaining physical join operators, a summary that pits all three against each other, and…
This is part 2 of my series on Craig Freedman’s classic SQL Server query-processing blog (part 1, June 2006, is here). In July 2006 Craig published four articles that finish the story of indexes and access paths, and then open…
Back in June 2006, Craig Freedman — at the time a developer on the SQL Server query processing team at Microsoft — started a blog about how SQL Server actually executes queries. Almost twenty years later it is still one…
The demo of Bob Ward about new features was nice, but lacked a bit of a CES demo. A few customers always ask what is the best way to sync changed data between locations, Triggers perhaps?! (Just yoking). So I…
If you have a lot of database maintenance jobs on different schedules it is hard to see which ones overlap and are not taking advantage of resources. The job visualizers I know are mostly reporting based and hard to get…
SQL Server 2016 is about to retire in July. If you’re not planning to swipe the corporate credit card for ESUs… it’s migration season.And honestly, moving your AG databases doesn’t have to be a drama-filled weekend project.Spin up a fresh…
This is what Microsoft can do for you. ( ) Well how can a DBA do this in a simple way? You analyze it with Claude code using Brent Ozar’s sp_BlitzIndex @AI = 2. You want the query and…
I saw Brent Ozar on Youtube Performance Tuning and going back to the stone-ages using @AI = 2 in sp_BlitzIndex, copy/edit/paste and again paste your precious time and save money by using a smart app and keep the focus on…
SQL Server 2025 gives you new backup compression algorithms that can dramatically reduce backup size and I/O — often without increasing CPU load. The “best” algorithm isn’t universal. It depends on your data, your hardware, and your restore-time requirements. The…
