Index and Column Limits

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.