What's the difference between using the text in row storage feature and using the varchar data type, and which will buy me better response time when I'm storing and retrieving arbitrarily long character strings?

If you're running SQL Server releases earlier than SQL Server 2000, you have two choices for storing and retrieving arbitrarily long character strings. If you choose the varchar data type, you might have to break the data across several rows to avoid hitting the 800...