How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? - Interview Question of the Week #218 - SQL Authority with Pinal Dave
SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave
The Length Limitations of LEN()? – SQLServerCentral
Comparing VARCHAR(max) vs VARCHAR(n) data types in SQL Server
SQL SERVER - Solution to Puzzle - REPLICATE over 8000 Characters - SQL Authority with Pinal Dave
sql server - SQL NVARCHAR and VARCHAR Limits - Stack Overflow
sql server 2016 - how to resolve The data types nvarchar(max) and uniqueidentifier are incompatible in the add operator - Database Administrators Stack Exchange
How can I visualize the value of nvarchar(max), with max>65535, from SQL Server database? - Stack Overflow
SQL Server: The dark side of NVARCHAR - {coding}Sight
What Is the Max Character Limit For a Variable With the Datatype of NVARCHAR (Max) : r/SQLServer
SQL SERVER - Increase Characters Displayed in Text Results - SQL Authority with Pinal Dave
nvarchar(n) vs nvarchar(max) performance in MS-SQL Server – Hung Doan
Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000).
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
In SQL Server, nvarchar (max) is not index compliant, but there is a workaround
