Also, you may want to protect certain tables from changes. I??™ve run into situations
where DBAs have used two databases for a single application: one holding updateable
information, and one holding read-only information (with the entire database set to
read-only). This requires two different permission sets and more maintenance than is
needed.
It??™s easy to underestimate the usefulness of a read-only filegroup. Of course, there??™s
the possible performance gain. You could also use a read-only filegroup to protect specific
tables from accidental or intentional changes. Plus, you only need to back it up after
it is populated (more on that shortly).
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 85
Partitioning Tables
SQL Server 2005 Enterprise Edition provides new functionality called partitioned
tables. The concept is similar to a partitioned view, but it??™s implemented on a much
more focused level. Multiple filegroups are defined to hold horizontal slices of a table
or index, and a partitioning scheme is defined to automatically place data on the
appropriate filegroup.
Pages:
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188