Summary

What you learned in today's lesson is one of the least used features of SQL Server. BLOB data is seldom used because of the complexity of manipulating it. The only tables I have seen that use BLOB data are employee tables that store a photo or formatted resume. For most application databases, there are usually better, easier, faster, and less complicated ways of storing data. You just have to think about how you are going to be using the data before deciding on how to store it.

Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.