As a database professional, I see a lot of instructions from vendors on how they want their SQL Server backend configured. Many times, the recommended configuration stinks. It’s not their fault – the companies typically don’t have anyone on staff whose job it is to lean how to configure each database platform they support for optimum performance.
Today, I came across the opposite situation. I got some recommended SQL Server configurations that were dead-on correct. This was the recommendation:
Do not activate the option “autoshrink” in the database.
And later on, in a different document, there was this:
Do not, by any means, activate the option “autoshrink” in the database.
So kudos to you, UC4! You are making DBAs everywhere happy.