SQL Server 2012 Create non clustered index
This video shows two items. First, it shows how to display the estimated execution plan. This plan illustrates the objects SQL Server will utilize to efficiently complete a query.
The sample database is borrowed from Petkovic, Dušan, Microsoft SQL Server 2012: A Beginner's Guide, 5th Edition, McGraw Hill, 2012, 978-0-07-176160-4 .
The second item shown is how to create an index using SSMS. One column and the fill factor option is included.
The end of the video re-displays the estimated execution plan proving that the index will be used.