In SQL Server, the clustered index key is automatically used in non-clustered indexes. Therefore, it's recommended to choose a short clustered index key to minimize storage and improve performance.

Keep the length of the index key short for clustered indexes. Additionally, clustered indexes benefit from being created on unique or non-null columns. Columns that are of the ntext, text, image, ...

NOT NULL columns in the index key – memory-optimized indexes do not support nullable columns; all columns in the index key must be declared as NOT NULL. Guidelines for choosing indexes. A few simple ...

With the In-Memory OLTP feature in SQL Server 2014 we introduce two new types of indexes for memory-optimized tables: the memory-optimized NONCLUSTERED indexes, and the memory-optimized HASH indexes.

SQL Server 2012 has a lot of metadata about columnstore indexes. For example, sys.indexes show column store indexes as type = 6 and type_desc as ‘NONCLUSTERED COLUMNSTORE.’ There also are two new ...

Various SQL stuff I'm working on...tools, scripts, etc - SQL/Scripts/Find Overlapping Indexes.sql at main · chadbaldwin/SQL ...

A table is made up of columns and rows. Columns contain the column name and data type. Rows contain the records or data for the columns. Basic SQL . Each record has a unique identifier or primary key.