Viewing 2 posts - 1 through 2 (of 2 total)
Good article. Thanks.
Adding the syntax might help. Looks pretty straightforward:
CREATE NONCLUSTERED INDEX ix_PersonNameType ON Person.Person (LastName, FirstName, MiddleName) INCLUDE(PersonType)
December 9, 2019 at 11:10 am
#3705947
Nice tip, but as a person over 50 I can only give one star.
November 10, 2014 at 5:07 am
#1757397