Comparing VARCHAR(max) vs VARCHAR(n) data types in SQL Server
Avoid SQL Server nvarchar(max) data type mapping in Databricks – ETL/BI-blogger
sql server - SQL query on xml stored as nvarchar(max) - Stack Overflow
SQL Server - Using TEXTSIZE to limit the display Select statement | Interface Technical Training
Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000).
SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave
In SQL Server, nvarchar (max) is not index compliant, but there is a workaround
The Length Limitations of LEN()? – SQLServerCentral
sql server - How do you view ALL text from an ntext or nvarchar(max) in SSMS? - Stack Overflow
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? - Interview Question of the Week #218 - SQL Authority with Pinal Dave
Max Text Replication Size – When you might have to care about this number ! | SQLSailor
sql server 2016 - how to resolve The data types nvarchar(max) and uniqueidentifier are incompatible in the add operator - Database Administrators Stack Exchange
The Length Limitations of LEN()? – SQLServerCentral
SQL varchar data type deep dive
What Is the Max Character Limit For a Variable With the Datatype of NVARCHAR (Max) : r/SQLServer
The Length Limitations of LEN()? – SQLServerCentral
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower - Microsoft Community Hub
