Are there any disadvantages to always using nvarchar(MAX)?

by

Same question was asked on MSDN Forums:

From the original post (much more information there):

When you store data to a VARCHAR(N) column, the values are physically stored in the same way. But when you store it to a VARCHAR(MAX) column, behind the screen the data is handled as a TEXT value. So there is some additional processing needed when dealing with a VARCHAR(MAX) value. (only if the size exceeds 8000)

VARCHAR(MAX) or NVARCHAR(MAX) is considered as a ‘large value type’. Large value types are usually stored ‘out of row’. It means that the data row will have a pointer to another location where the ‘large value’ is stored…

More Related Contents:

  1. Add a column with a default value to an existing table in SQL Server
  2. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. The multi-part identifier could not be bound
  5. How to return multiple values in one column (T-SQL)?
  6. SQL – Subtracting a depleting value from rows
  7. Turn off constraints temporarily (MS SQL)
  8. Get the week start date and week end date from week number
  9. Pass table as parameter into sql server UDF
  10. Can a Check constraint relate to another table?
  11. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  12. How to Replace Multiple Characters in SQL?
  13. SELECT FOR UPDATE with SQL Server
  14. EXISTS vs JOIN and use of EXISTS clause
  15. SQL comma-separated row with Group By clause
  16. How to copy a huge table data into another table in SQL Server
  17. How to split string using delimiter char using T-SQL?
  18. Should I use SQL_Variant data type?
  19. Performance of SQL Server 2005 Query
  20. OPENXML with xmlns:dt
  21. SQL server select distinct rows using most recent value only
  22. Script to save varbinary data to disk
  23. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  24. How to select date without time in SQL
  25. What is the internal representation of datetime in sql server?
  26. Eliminate and reduce overlapping date ranges
  27. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  28. SQL Sort Order with Null values last
  29. Insert all values of a table into another table in SQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment