Before I proceed, God bless you for the nice article.
I resumed a new job recently and an issue was reported to me about the database transaction log file(.ldf) expanding very fast. This also in a way affects the system memory, and delays transaction operations at the particular hour when a whole lot of transactions are performed.
I discovered they do shrink the database whenever this occurs so I began thinking of a permanent solution.
What came to my mind at first was:
1. index rebuilding/ reorganizing.
2. "Is database shrinking a good idea?"
So while searching for articles on that online, I came across yours. After going through your comprehensive article, I decided a periodic shrink and index reorganizing while I also advice for an increase in the system RAM and Disc space.
Please is this a good idea (Expecially for an Enterprise app)?