SQL: Text vs Varchar(max) - in row vs out of row storage

added by DotNetKicks
3/7/2019 3:18:26 PM

1 Kicks, 509 Views

There was an interesting discussion on a local mailing list about the performance of a table that was just used for logging. One of the things that intrigued me was that the developer had used the text data type to store his log messages. Now text, along with ntext and image, was deprecated back in ...