<p>When should I choose one or the other? What are the implications regarding space and (full-text) indexing?</p>

<p>BTW: I'm currently using SQL Server 2005 planing to upgrade to 2008 in the following months.</p>

<p>Thanks</p>

[{'answer_id': 47205, 'author': 'Eugene Yokota', 'author_id': 3827, 'author_profile': 'https://Stackoverflow.com/users/3827', 'pm_score': 2, 'selected': False, 'text': '<p>Once you put it in the blob, it\'s going to be difficult to be used for normal SQL comparison. See <a href="http://msdn.microsoft.com/en-us/library/ms178158.aspx" rel="nofollow noreferrer">Using Large-Value Data Types</a>.</p>\n'}, {'answer_id': 47214, 'author': 'Eric Z Beard', 'author_id': 1219, 'author_profile': 'https://Stackoverflow.com/users/1219', 'pm_score': 5, 'selected': True, 'text': '<p>The new (max) fields make it a lot easier to deal with the data from .NET code.  With <code>varbinary(max)</code>, you simply set the value of a <code>SqlParameter</code> to a byte array and you are done.  WIth the image field, you need to write a few hundred lines of code to stream the data into and out of the field.</p>\n\n<p>Also, the image/text fields are deprecated in favor of <code>varbinary(max)</code> and <code>varchar(max)</code>, and future versions of Sql Server will discontinue support for them.</p>\n'}]
['https://Stackoverflow.com/questions/47203', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2148/']