Errata for Microsoft SQL Server 2012 Internals
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted by |
Date submitted |
| PDF |
Page 16
title: optimistic currency |
should read optimistic concurrency.....
|
praveen lokanathan |
Mar 06, 2014 |
| PDF |
Page 172
2nd paragraph |
although the writes to the log are "asynchronous"...should read "synchronous" similar to what it states on page 16 line 2 from the top
|
praveen lokanathan |
Mar 06, 2014 |
| Printed, |
Page 123456789
various - see detail |
Chapter 3 p1 says ??limit is 231?1 (more than 2 billion) objects? this should be 231-1, also number 1524,272 TB should be 1,524,272 TB.
Chapter 5, p 177 says log reading tools for 2012 do not yet exist, you can see one here: www.apexsql.com/sql_tools_Log_features.aspx
Ch7 sub-headings in Tools for analyzing indexes section not consistent i.e. Using the dm_db_index_physical_stats DMV and Using sys.dm_db_Database_page_allocations (sys. and DMV inconsistent)
Ch 7 in Tools for analyzing indexes section, output cols of sys,dm_db_index_physical_stats not described, but those of sys.dm_db_Database_page_allocations are, why the inconsistency?! Tells me sys.dm_db_index_physical_stats used for system health, but doesn?t go into any detail? some detail in given later in ?Analyzing a clustered index structure? section
P619 has English errors ??in this manner because it simplifies reason about the set??? also p619 has ??duplicated many times in the sazxszme query.?
In Chapter 12, in caching mechanisms, uses term autoparameterization, later uses the term ?simple parameterization? heading when discussing detail. Doesn?t say they are the same! Please be consistent else explain? (know they are cas says Drawbacks of simple parameterization : A feature of autoparameterization that?)
Chapter 12 p752 says ??to come up with a new fplan?? fplan should be plan.
Chapter 14 p853 has error in title: Enablilng parallelism should be Enabling parallelism
Note from the Author or Editor:
Each error needs to be reported individually so that they can be processed by the publisher. |
Ian Stirk |
Jan 13, 2014 |