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…
Using @tabel variables in the past was a good reason for getting fired, because the engine thought you gonna put 1 row in, so the cost for the execution plan were low, so no parallelism in the operators. However now,…
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 ..…
Just enable it so better tools can use it… for example “The Mouse and the Elephant” Enable script. Check Erik Darlings Github Repo’s you just search on the Module name .. Lesson: the elephant execution plan is ok for the…
Paar extra kolommen voor de tabel.
