A future world without the SQL Server Image/Text/NText data types. Now's the time to start planning for that future...
By : Gregs Cool [Insert Clever Name] of the Day | On : 2008 March 23
Jose Barreto's Blog - SQL Server 2008 and Unstructured Data "SQL Server 2008 introduces two new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005. IMAGE Back in SQL Server 2000 and SQL Server 7 days, we used the IMAGE data type to store binary large objects (a.k.a. BLOBs). Large, by the way, is defined as anything that would not fit a SQL Server data page (around 8,000 bytes). This data type is still present in SQL Server 2005 today, bu...
|
|
|
Total:
 |
Click here to continue on details
Content Ownership
The content of this posting is wholly owned by Gregs Cool [Insert Clever Name] of the Day, and as such: the same retains sole copyright for the content. softlogger.com is not responsible for this content.
Recommended Related Readings :
ASP.NET Dynamic Data - Displaying, Inserting and Editing Images in SQL Server Database
ASP.NET Dynamic Data - Displaying, Inserting and Editing Images in SQL Server Database by Dav...
SQL Server Express with Full-Text Indexing
Did you know that SQL Server Express now has Full-Text Indexing? With the soon to be ...
Encrypting Data In SQL Server 2005
I've been looking at the new encryption functionality in SQL Server 2005. Here's some sql that...
Returning the First Day of the Month from a Given Date/Time value in SQL Server
First off, it's been a long time since my last post, close to a month! Things have been very b...
SYSK 333: What Query Plans Are Cached in SQL Server?
It’s well known that, to improve performance, SQL Server caches query execution plans in memor...
SQL Server 2005 Express and Full-Text Indexing
Here is a video tutorial on setting up SQL Server 2005 Express and Full-Text Indexing. It b...
Scripting SQL Server Database Data
There have been many times when I've needed to script the creation of SQL Server database data...
