GitHub

back-up-files-and-filegroups-sql-server.md

[!INCLUDE SQL Server] This topic describes how to back up files and filegroups in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull], [!INCLUDEtsql], or PowerShell. When the database size and ...
Ars Technica

SQL Server, varbinary(max), Filegroups and Filestream questions

We have an app that stores documents in the database as a varbinary(max) column. Our current average document size is about 475KB, so these are not large documents by any means, but there are a fair ...
Network World

VLDB? Use Read-only Filegroups if you can…

As mentioned in my post on VLDBs, one of the key pieces of a high performing solution is the use of Read-only Filegroups. If a significant part of your data is not changing, then why not tell SQL ...
GitHub

restore-files-and-filegroups-sql-server.md

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