Think of the indexes you might see in your everyday life—those in books and other documents. Suppose that you’re trying to create an index in SQL Server using the CREATE INDEX statement and you’re using two SQL Server references to find out how to write the statement. One reference is the (hypothetical) Microsoft SQL Server Transact-SQL Language Reference Manual, referred to here as the “T-SQL Reference.” Assume that the T-SQL Reference is just an alphabetical list of all the SQL Server keywords, commands, procedures, and functions. The other reference is this book: Microsoft SQL Server 2012 Internals. You can find information quickly in either book about indexes, even though the two books are organized differently.

In the T-SQL Reference, ...

Get Microsoft SQL Server 2012 Internals now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.