How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower - Microsoft Community Hub
Max Text Replication Size – When you might have to care about this number ! | SQLSailor
Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000).
How can I visualize the value of nvarchar(max), with max>65535, from SQL Server database? - Stack Overflow
What Is the Max Character Limit For a Variable With the Datatype of NVARCHAR (Max) : r/SQLServer
SQL varchar data type deep dive
Avoid SQL Server nvarchar(max) data type mapping in Databricks – ETL/BI-blogger
SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave
SQL Server - Using TEXTSIZE to limit the display Select statement | Interface Technical Training
SQL SERVER - Increase Characters Displayed in Text Results - SQL Authority with Pinal Dave
sql - Size limit for nvarchar(max) , Print issue - Stack Overflow
nvarchar(n) vs nvarchar(max) performance in MS-SQL Server – Hung Doan
sql server - SQL NVARCHAR and VARCHAR Limits - Stack Overflow
sql server - How do you view ALL text from an ntext or nvarchar(max) in SSMS? - Stack Overflow
