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 ...
Horizontal partitioning isn't new to SQL Server. Horizontally partitioning SQL Server 7.0 and later tables to multiple files and filegroups improves performance by reducing average table and index ...
In a previous blog entry, I talked about the new FILESTREAM data capability in SQL Server 2008 where we can store Binary Large Object (BLOB) data on the file system but have it transactionally part of ...