SQL SERVER 2016 - InMemory OLTP LOB Datatype Enhancement - SQL Authority with Pinal Dave
SQL Server: The dark side of NVARCHAR - {coding}Sight
SQL SERVER - Solution to Puzzle - REPLICATE over 8000 Characters - 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).
Solution for the error calling SQL Server Stored Procedure which has argument type NVARCHAR(MAX) | Appeon
T-SQL 101: #40 String data types in SQL Server - The Bit Bucket
sql server - How do you view ALL text from an ntext or nvarchar(max) in SSMS? - Stack Overflow
sql server - How do you view ALL text from an ntext or nvarchar(max) in SSMS? - Stack Overflow
Max Text Replication Size – When you might have to care about this number ! | SQLSailor
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 - best way of searching string in sql table column of type " nvarchar(max)" - Stack Overflow
Compress and Decompress in SQL Server 2016 – SQLZealots
Avoid SQL Server nvarchar(max) data type mapping in Databricks – ETL/BI-blogger
SQL UPDATE for VARCHAR, NVARCHAR and VARBINARY using WRITE Clause
asp.net - How to insert an image into a nvarchar(max) in SQL server - Stack Overflow
Understanding PIVOT operator in SQL Server with Examples – SQLZealots
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower - Microsoft Community Hub
The Length Limitations of LEN()? – SQLServerCentral