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…
Of course you run Ola Hallengren’s IndexOptimize ( SQL Server Index and Statistics Maintenance ) as a job in the weekend with your own custom @FragmentationLevel1 and @FragmentationLevel2 levels and suddenly the jobs takes much longer to run.. why? Well…
And here are the old red an new blue matrix, both have 22 columns, I think they are the same. If you have frustrations blue is probably a better color to cool the DBA down. Above the new one.…
