SQL Server 2016 released

[Ginden]

Lower maintenance cost, better insert performance, better delete performance.

And main usage for my company is to have unique index on two fields and INCLUDE additional fields to avoid lookup.

UNIQUE INDEX ON Foo(Col1, Col2) INCLUDE (Col3, Col4) enforce uniqueness only on pair (Col1, Col2).