Model
I see very few implementations that use the model database (that is, it??™s been changed
from its default settings). Remember that with the model database, you can not only
change the default settings for a new database??”such as the initial file sizes and growth
percentage??”but you can also include actual tables. I often use custom statistic gathering
for performance and capacity planning. Rather than create all of the custom tables I use
for holding data (plus a few seed tables that hold code values), I just add them to the
model database of a server.
If you work with the model database in any fashion, make sure you have the most
current version backed up??”it can save you a lot of time and headaches. In the scenario
I just described where I had a significant number of customizations made to the model
database, there was one instance when I forgot to back it up. The entire server crashed,
and I had no written record of how I had it set up. It took a lot of manual work comparing
reports and documentation I had delivered to a client to recreate the original model
settings.
Pages:
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161