October 12, 2017
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