Clustered vs. Nonclustered Index Structures in SQL Server
Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries.
Blog post on primary key vs. the clustered index:
http://voluntarydba.com/post/2012/10/...
CREATE INDEX statement reference:
http://technet.microsoft.com/en-us/li...
ALTER INDEX statement reference:
http://technet.microsoft.com/en-us/li...
Index navigation internals by example:
http://sqlblog.com/blogs/paul_white/a...
Sample index data is from the AdventureWorksLT2008R2 sample database:
http://awlt2008dbscript.codeplex.com/...
Visit my channel for more database administration videos:
/ voluntarydba
Subscribe to get notified about my latest videos:
https://www.youtube.com/voluntarydba?...
Read additional content on my blog:
http://voluntarydba.com
Follow on Twitter:
/ voluntarydba
Like on Facebook:
/ voluntarydba
