How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower - Microsoft Tech Community
In SQL Server, nvarchar (max) is not index compliant, but there is a workaround
nvarchar(n) vs nvarchar(max) performance in MS-SQL Server – Hung Doan
Strange Behaviour Converting NVARCHAR(MAX) to BINARY - CodeProject
A Quick Story of Tiny_TDS, Sequel, Ruby, MS SQL Server, and NVARCHAR(MAX)
SQL: Text vs Varchar(max) - in row vs out of row storage - The Bit Bucket
Avoid SQL Server nvarchar(max) data type mapping in Databricks – ETL/BI-blogger
SQL Server VARCHAR VS NVARCHAR - SqlSkull
Get column length using Col_Length – SQL Server | SQL Server Rider
sql server - What is the difference between varchar and nvarchar? - Stack Overflow
SQL Server VARCHAR VS NVARCHAR - SqlSkull
VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types – SQL Server Performance
SQL Server — Should I use varchar(n), varchar(8000) or varchar(MAX)? | by Tamás Hudák | Medium
Size limit for nvarchar(max) , Print issue - Stack Overflow
SSIS Import and Export VARCHAR(MAX) Data
Avoid SQL Server nvarchar(max) data type mapping in Databricks – ETL/BI-blogger
Varchar Vs NVarchar in SQL. Varchar Vs NVarchar: | by mayuri budake | Medium
VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types – SQL Server Performance
In SQL Server, nvarchar (max) is not index compliant, but there is a workaround
The Length Limitations of LEN()? – The Non-Cluttered Index
Why is nvarchar(max) size limited to 4000 characters
Comparison of the VARCHAR(max) and VARCHAR(n) SQL Server Data Types
sql server - nvarchar(max) vs NText - Stack Overflow
SQL SERVER - Solution to Puzzle - REPLICATE over 8000 Characters - SQL Authority with Pinal Dave
SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave
