CREATE NONCLUSTERED INDEX DBA_tpSupportStatusHistory_SortOrder_201604221421 ON dbo.tpSupportStatusHistory ( SortOrder, SupportRequestHeaderID ) INCLUDE (InnerHeaderID, OperationDate, SupportStatusCode) WITH( PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON NONCLUSTEREDIDXFG GO ALTER TABLE dbo.tpSupportStatusHistory SET (LOCK_ESCALATION = TABLE) GO COMMIT
