Using SQL Rewrite mode in Optimize SQL consists of two steps. In the first step, SQL Optimizer generates semantically equivalent alternatives with unique execution plans for your original SQL statemen...
Most automation scripts produce some kind of output, such as an Excel report, and these need to be distributed to end users or storage locations. When there are many such reports you might want to zip...
One of my client was unable to modify the maintenance plan using SSMS. When we did various tests, we found that existing maintenance plans could execute and work. We tried creating a new maintenance p...
