In SQL Server, nvarchar (max) is not index compliant, but there is a workaround
nvarchar and nvarchar(max) errors with default ASP.NET Core 3.0 project and Identity option · Issue #865 · PomeloFoundation/Pomelo.EntityFrameworkCore.MySql · GitHub
SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave
SQL varchar data type deep dive
Nvarchar Vs Varchar Data Types In SQL Server | My Tec Bits
VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types – SQL Server Performance
Including nvarchar(max) columns in select clause dramatically increases execution time - Stack Overflow
SQL Server: The dark side of NVARCHAR - {coding}Sight
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower - Microsoft Tech Community
Avoid SQL Server nvarchar(max) data type mapping in Databricks – ETL/BI-blogger
sql server - What is the difference between varchar and nvarchar? - Stack Overflow
Varchar Vs NVarchar in SQL. Varchar Vs NVarchar: | by mayuri budake | Medium
SQL SERVER NVARCHAR - SqlSkull
NVARCHAR Data Type - Essential SQL
SQL Server: why does order by change the string splicing result of variables | Develop Paper
The Length Limitations of LEN()? – SQLServerCentral
VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types – SQL Server Performance
sql server 2016 - how to resolve The data types nvarchar(max) and uniqueidentifier are incompatible in the add operator - Database Administrators Stack Exchange
Size limit for nvarchar(max) , Print issue - Stack Overflow
Increased the default XEvent trace: system_health size and retention policy are in SQL Server – Run SQL Server BLOG
Max Text Replication Size – When you might have to care about this number ! | SQLSailor
Script to bulk add SysAdmins to SQL Server - Steve Stedman
