Explain filestream storage of sql server 2008?
Submitted by: AdministratorThe complexity of application development and reduces the managing unstructured data cost. The manageability is increased by extending various capabilities which are available only to relational data to non-relational data.
SQL Server 2008 came with 2 new capabilities for persisting BLOB data:
1. FILESTREAM: It is an attribute that can be set on a ‘varbinary' column for data persistence on the file streams. This enables the benefits from fast streaming capabilities and storage capabilities.
2. Remote BLOB storage: It is a client-side API which reduces the application building complexity and relies on an external persistence for BLOBs and a database for relational data.
SQL Server 2008 will also continue the support for standard BLOB type through the data type ‘varbinary'.
Submitted by: Administrator
SQL Server 2008 came with 2 new capabilities for persisting BLOB data:
1. FILESTREAM: It is an attribute that can be set on a ‘varbinary' column for data persistence on the file streams. This enables the benefits from fast streaming capabilities and storage capabilities.
2. Remote BLOB storage: It is a client-side API which reduces the application building complexity and relies on an external persistence for BLOBs and a database for relational data.
SQL Server 2008 will also continue the support for standard BLOB type through the data type ‘varbinary'.
Submitted by: Administrator
Read Online MS SQL Server 2008 Job Interview Questions And Answers
Top MS SQL Server 2008 Questions
☺ | What is Table Value Parameters (TVP)? |
☺ | Explain filtered indexes? |
☺ | What is Intellisense? |
☺ | What is Compound Operators? |
☺ | What is MERGE? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |