SQL Server gives us a limit of 900 bytes for clustering keys, and 1700 bytes for non-clustered indexes. 

Have to use full-text index for VARCHAR(MAX) or nVARCHAR(MAX) datatypes.

Last modified: March 16, 2019

Author

Comments

Write a Reply or Comment