Making use of the model Database

All the websites and books talk about how the model database is what all future databases are based on, including tempdb, so add important stuff there. In my experience, there is not a great need to have the same function in every database. In fact, what a pain for maintenance would that be! I’ve had to put a user defined datatype into model once because tempdb required it because the third party app was written that way. The only thing which has proven to be good time and again for me and my model databases is setting file growth to 250MB for the log and data files. Anyone have any other genuine success stories of how configuring the model database saved the world?

This entry was posted in Configuration. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *