Understanding PIVOT operator in SQL Server with Examples – SQLZealots
SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave
Why is nvarchar(max) size limited to 4000 characters
sql server 2016 - how to resolve The data types nvarchar(max) and uniqueidentifier are incompatible in the add operator - Database Administrators Stack Exchange
Max Text Replication Size – When you might have to care about this number ! | SQLSailor
asp.net - How to insert an image into a nvarchar(max) in SQL server - Stack Overflow
VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types – SQL Server Performance