DROP and CREATE for an object works great until you run into one that has any kind of security assigned. If you drop and create, rights granted (or expressly denied)...
With long hours the norm, downward pressure on wages, most skills being all but useless once they're just a few years old, and more and more work being sent offshore,...
The question is a false choice. I don't want more automatic tuning or more manual controls, I want both. As a developer who also keeps 10 SQL Server instances running...