Question: What are included columns?
- A new feature in SQL Server 2005
- Non key columns included in addition to the index key columns in an index structure.
Explanation: In SQL Server 2005, a nonclustered index can be extended by including nonkey columns in addition to the index key columns. The nonkey columns are stored at the leaf level of the index b-tree.
You can read detail at –
Note: The Question is taken from SQLServercentral.com.