In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do ...
As mentioned in my post on VLDBs, one of the key pieces of a high performing solution is the use of Read-only Filegroups.
In my last blog entry, I talked about VLDBs. One of the tactics suggested was to use as many data files on as many drives as ...