What is the limit of index size for non clustered index?

In SQL Server 2014 version the limit of index size is 900 bytes.
In SQL Server 2016 version the limit of index size is increased to 1700 bytes for non clustered index 900 bytes for a clustered index.

Add a Comment

Your email address will not be published. Required fields are marked *