Categorie Performance Tuning

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…

If there is a large (10 tables and some temp tables), complex query and in the select is a calculation with a lot of column values from different tables and the execution plans shows nested loops inside nested loops ..…