SQL SERVER - Solution to Puzzle - REPLICATE over 8000 Characters - SQL Authority with Pinal Dave
SQL Server: The dark side of NVARCHAR - {coding}Sight
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? - Interview Question of the Week #218 - SQL Authority with Pinal Dave
SQL varchar data type deep dive
nvarchar(n) vs nvarchar(max) performance in MS-SQL Server – Hung Doan
sql - Size limit for nvarchar(max) , Print issue - 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
sql server - SQL NVARCHAR and VARCHAR Limits - Stack Overflow
In SQL Server, nvarchar (max) is not index compliant, but there is a workaround
The Length Limitations of LEN()? – SQLServerCentral
sql - Including nvarchar(max) columns in select clause dramatically increases execution time - Stack Overflow
Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000).
The Length Limitations of LEN()? – SQLServerCentral
SQL Server - Using TEXTSIZE to limit the display Select statement | Interface Technical Training
sql server - How do you view ALL text from an ntext or nvarchar(max) in SSMS? - Stack Overflow
