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’.
What are the differences between a primary key and a unique key?
Create a procedure named BASKET_ADD_SP that accepts a product id, basket id, price, quantity, size code(1or2) and from code(3 or 4) and that uses this information to add a new item to the BB_BASKETITEM table.
What is the difference between BLOB and TEXT?
In MySql table how many TRIGGERS are allowed?
Explain about encryption of whole databases without the requirement for application changes in SQL server 2008.
Illustrates the term Linked Server in the SQL Statement?
Describe benefits of SQL Server 2008 for automatic auditing.
What is TEXT?
Explain about the plan freezing in SQL server 2008.
18,76,764
1933531 Asked
3,689
Active Tutors
1438958
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!