O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing a storage solution for unstructured data and new collations

The data stored in the database is structured to maintain transactional consistency and concurrency. Data that is stored outside the database such as text files, images, documents, and videos is unstructured data.

SQL Server 2008 integrates the new data type called FILESTREAM, which integrates the database engine with the NTFS file system by storing in the format of VARBINARY(MAX). The storage limit on such data can exceed the 2GB limit on the stored values to take advantage of the relational capabilities of the core database engine, by handling the files on SQL Server. Similarly, the collations affect how characters (data) for a specific language or accent are recognized and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required