I am often appalled by the lack of knowledge of the database culture of computer scientists in general and more particularly of systems engineers, as well as developers who naively believe that restarting a server is a necessity, it feels good. In particular in the RDBMS world it hurts… Very bad! Including when you believe you are doing the right thing, such as applying patches, CUs or other fixes. Some have paid dearly for this very serious mistake…
It is strongly advised never to shut down an MS SQL Server instance. This practice is the worst of all. In