What is the limit of columns that can be included in an index

For SQL Server 2012 the limit of columns that can be included in the index is 16.
SQL Server 2016 has limit of 32 columns which can be included in the index

Add a Comment

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