- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
If the ID is a primary key, a new record will be added to the table relative to the PK's position to the table. With NEWID(), this could be anywhere on the table as the GUID is not sequential. With NEWSEQUENTIALID(), it will always add the record at the end of the table which generates a rightmost leaf in the index and is more efficient. http://www.verynoisy.com/sql-indexing-dummies/ has an explanation of indexing nodes.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/56827/