InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 15:48:52 GMT20http://www.sqlservercentral.com/Forums/Topic866919-357-1.aspxWhat are included columns with respect to SQL Server indexing?A new type of index was developed in SQL Server 2005 and beyond that assists in situations where a covering index is needed.Indexes with Included Columns are non clustered indexes that have the following benefits:1. Columns defined in the include statement, called non-key columns, are not counted in the number of columns by the database engine.2. Columns that previously could not be used in queries, like nvarchar(max), can be included as a non-key column.3. A maximum of 1023 additional columns can be used as non-key columns.Tue, 16 Apr 2013 01:32:06 GMTegpotushttp://www.sqlservercentral.com/Forums/Topic866919-357-1.aspxTest question? Interview question? Search in Books Online for 'Include columns' you should find several entries.Wed, 17 Feb 2010 06:23:45 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic866919-357-1.aspxDatabase Design - What are included columns with respect to SQL Server indexing?Wed, 17 Feb 2010 05:50:52 GMTSree Arjun Div