Filestream Data
Although the flexible methods that SQL Server uses to store large object data in the database give you many advantages over data stored in the file system, they also have many disadvantages. Some of the benefits of storing large objects in your database include the following:
Transactional consistency of your large object data can be guaranteed.
Your backup and restore operations include the large object data, allowing you integrated, point-in-time recovery of your large objects.
All data can be stored using a single storage and query environment.
Some of the disadvantages of storing large objects in your database include the following:
Large objects can take a very large number of buffers in cache.
Updating large objects can cause extensive ...
Get Microsoft® SQL Server® 2008 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
