Difference between nvarchar vs ntext SQL Server

In SQL Server, the difference between nvarchar and ntext data types is their maximum storage capacity and their usage.

nvarchar is a variable-length, Unicode data type that can store up to 4,000 characters.
ntext is a variable-length, Unicode data type that can store large amounts of text data, up to 2^30-1 characters (1 GB).
The nvarchar data type is generally used for storing smaller amounts of text data, such as names, addresses, and descriptions. The ntext data type is typically used for storing large amounts of text data, such as articles, blog posts, and product descriptions.

It’s worth noting that ntext is no longer recommended for use, instead varchar(max) and nvarchar(max) is preferable.