New capabilities of SQL server 2008 for persisting BLOB data
What are the new capabilities of SQL server 2008 for persisting BLOB data?
Expert
SQL Server 2008 for persisting BLOB data came along with two new capabilities as follows:
a. FILESTREAM: This is an attribute that can be set upon a ‘varbinary’ column for data persistence upon the file streams. It enables the benefits from quick storage capabilities and streaming capabilities.
b. Remote BLOB storage: This is a client-side API that reduces the application building complexity and relies upon an external persistence for relational data and for BLOBs and a database.
SQL Server 2008 will also carry on the support for standard BLOB type by the data type ‘varbinary’.
Illustrate the SQL Deadlock in Structure Query Language?
Explain about the given commands: TTITLE and BTITLE, COLUMN and SET.
Define the Synonyms in Structure Query Language.
Define the Notification services.
Explain about the file stream storage of sql server 2008?
Explain about Enhanced database mirroring in SQL server 2008.
How do you control the maximum size of a HEAP table?
In MySql table how many TRIGGERS are allowed?
Define the term Posting in database.
Explain about the sparse columns of sql server 2008.
18,76,764
1952723 Asked
3,689
Active Tutors
1439006
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!