We have an app that stores documents in the database as a varbinary(max) column. Our current average document size is about 475KB ...

Using SQL Server Management Studio To restore files and filegroups After you connect to the appropriate instance of the [!INCLUDE ssDEnoversion], in Object Explorer, click the server name to expand ...

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 ...

- The system administrator who is restoring the files and filegroups must be the only person currently using the database to be ...