My Favorite New Feature in SQL Server 2014 The SQL Herald
This type of inline specification of CLUSTERED and NONCLUSTERED indexes is now available for tables that are disk-based. By creating a table with an inline index is the same as creating a table which is followed by a CREATE INDEX statement. This option should be used for archival or other cases in which you require […]