You assign a table to filegroups from the Properties window.You can specify the
filegroup for the table itself, plus a separate filegroup for TEXT, NTEXT, and IMAGE data.
When creating indexes, the screen interface is similar, as you can see in Figure 4-5.
Figure 4-5. Specifying a filegroup for indexes
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 82
All in all, it pays to specify a filegroup for a table or an index when you create the
object initially. Whenever possible, you should design your table and index layout across
filegroups before building the actual database.
PLANNING FOR EXTREMES
When planning or designing a new database, someone will often say something like, ???It??™s only going to
be a 500MB database at maximum, so a single data file will do.??? These often turn out to be ???famous
last words.??? There was a time when someone declared, ???No one will ever use more than 640K of physical
memory.??? That statement led to an architecture design that limited memory for operating systems
from DOS to Windows Millennium Edition (Me). Whoops.
I??™ve run into many SQL Server databases in the 20-50GB range that started as Microsoft Access
databases.
Pages:
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182