How to create a nonclustered index in SQL Server

Learn how to create a nonclustered index in SQL Server to speed up queries, with a T-SQL example and how to check it is…