Search Results for “Ola Hallengren”
If you’re a full time database administrator, then rather than using maintenance plans, you should upgrade to Ola Hallengren’s maintenance scripts. They’re free, open source, and are used all over the world to do powerful, configurable maintenance tasks. For support and feature requests, head to Ola’s Github repository.
To be honest, I’m not a big fan of table partitioning in most scenarios. It’s a data loading & unloading feature thanks to the sliding window scenario, but… most folks just don’t load their data an entire partition at a time. However, when we need to do index maintenance for columnstore indexes, that’s exactly what we…
Developers and sysadmins: the easiest way for you to protect your servers is by using maintenance plans. Full time production database administrators should watch the Ola Hallengren maintenance script setup module instead. I’m specifically targeting this video at developers and sysadmins who need an easy, safe way to protect stuff without knowing T-SQL.