FILESTREAM and FileTable 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 require a very large number of buffers in cache.

  • The upper limit on ...

Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.