a nonclustered index in MSSQL

I took the SQL I wrote here and put a nonclustered index (an index that does NOT require unique values) on the Name column in the Person table like so:

CREATE NONCLUSTERED INDEX myindex ON [Person] ( [Name] ASC ) ON [PRIMARY]

 
 

I could then use it like so:

SELECT * FROM Person WITH (INDEX (myindex))

 
 

I could eventually wash my hands of it like this:

DROP INDEX myindex ON [Person]

 
 

Some helpful links:

• http://blog.sqlauthority.com/2010/01/06/sql-server-unique-nonclustered-index-creation-with-ignore_dup_key-on-a-transactional-behavior/
• http://sqlskills.com/BLOGS/KIMBERLY/category/Nonclustered-Indexes.aspx
• http://msdn.microsoft.com/en-us/library/ms176118.aspx