Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag BLOB Manipulation Rss

Search for any content tagged blob manipulation

   Items 1 to 7 of 7   
 

SQL Server Unique Constraints for Large Text Columns

We are storing large text and URLs that are over 900 bytes in some of our tables and have a requirement to enforce uniqueness in those columns. But SQL Server has a limitation that index size can't be over 900 bytes. How do I enforce uniqueness in these columns and is it possible to achieve this in SQL Server 2005 and above? What are my different options to solve this problem? I heard that we can use CHECKSUM to create a hash, but is it possible to avoid collisions in the hash value as we are storing millions of rows?  Read more...
By Additional Articles 2009/11/05 | Source: MSSQLTips.com | Category: constraints
Rating:  Rate this |   Briefcase | 2,608 reads

Remote BLOB Store Provider Library Implementation Specification

This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.  Read more...
By Additional Articles 2009/07/03 | Source: TechNet Blogs | Category: blob manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 1,030 reads

Binary Files Import and Export

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.  Read more...
By Sergey Benner 2008/08/28 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 8,889 reads

Storing Images and BLOB files in SQL Server Part 4

Part 4 of this series focuses on storing BLOBs on the Windows File System and using Microsoft SQL Server to organize them from a web page.  Read more...
By Additional Articles 2008/04/14 | Source: Database Journal | Category: blob manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 3,112 reads

Storing Images and BLOB files in SQL Server Part 2

Part two of this article focuses on using the SQL Server Binary data type to store small image files.  Read more...
By Additional Articles 2008/02/21 | Source: Database Journal | Category: blob manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 3,120 reads

Revenge of the BLOB

Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.  Read more...
By Andrew Sears 2008/01/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,773 reads

Storing Images and BLOB files in SQL Server

This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.  Read more...
By Additional Articles 2008/01/24 | Source: Database Journal | Category: sql server 2005
Rating:  Rate this |   Briefcase | 3,967 reads
   Items 1 to 7 of 7