I spoke with Christian Kleinerman, Program Manager for the SQL Engine team, about the decision to create the MAX data types instead of extending TEXT and IMAGE. He mentioned that the TEXT and IMAGE data types, "have many behaviors [the SQL Server team doesn't] quite like – the main one being the fact that physical addresses [are] exposed via TEXTPTR()."
For those who haven't experienced the absolute rapture of updating TEXT data, getting a pointer to the data using TEXTPTR() is one of the necessary steps for using the READTEXT and WRITETEXT functions. Those functions, unfortunately, are the only methods available for updating large documents stored in columns using the TEXT data type. And while these restrictions are the bane of developers everywhere, Kleinerman mentions that, "trying to improve some things in TEXT and IMAGE and at the same time deprecate some of [their] behaviors would have been a confusing proposition that would have likely resulted in yet another set of seemingly arbitrary restrictions – with backwards incompatibilities of course."
The SQL Server team, unfortunately, cannot work in a bubble. Customers will simply not stand for breakage to their legacy code, and Microsoft has certainly shown its commitment in the past for supporting even the most esoteric legacy software in order to keep customers happy. The TEXT and IMAGE data types are no different. Klinerman noted that the move to the MAX data types "would ensure backward compatibility" by not breaking TEXT and IMAGE – and give these less-than-loved types a "peaceful death" in the future!
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Adam Machanic
Migrating to SQL Server 2005 from SQL Server 2000 is a hefty feat when compared to upgrading from 7.0 to SQL Server 2000. Site expert Adam Machanic ... Continue Reading
Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ... Continue Reading
SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.