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