SQL Server Performance

FILESTREAM datatype

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Akthar, Oct 1, 2007.

  1. Akthar New Member

    someone can please provide some additional info of the filestream datatype!!!! Will be part of SQL 2008 ... What are the implications on performance???
  2. satya Moderator

    Have you looked in to the CT4 Books online?
    As you have referred initially, this FileStream data type which allows large binary data to be stored in the file system and yet remain an integral part of the database with transactional consistency.
    Applications can use a new storage type “VARBINARY(MAX) FILESTREAM” to define table columns and store large binary data as files in the file system instead of as a SQL BLOB. Applications can use T-SQL SELECT/INSERT/UPDATE/DELETE statements to query and modify FILESTREAM data.
    With regard to the performance and its implications, you might need to wait until next CTP releases that will have more information.
    The FILESTREAM type leverages Win32 rich set of streaming APIs which is proven to be more efficient and faster the larger the data gets.
  3. dineshasanka Moderator

    http://blogs.msdn.com/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx

Share This Page