Microsoft SQL Server 2012 Internals

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. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed, PDF, ePub, Safari Books Online
Page http://my.safaribooksonline.com/book/databases/microsoft-sql-server/9780735670174/2dot-the-sqlos/ch0

Section "Workload groups" contains: "This group is used for the internal activities of SQL Server. Users canít add sessions to the internal group or affect its resource usage." Users can affect resource usage of internal group with Dedicated Administrator Connection.

Note from the Author or Editor:
Replace "Users canít add sessions to the internal group or affect its resource usage." with "In general, users canít add sessions to the internal group or affect its resource usage. The only exception is when a SQL Server administrator is using the Dedicated Administrator Connection."

Karen Abgaryan  Jan 13, 2014 
Printed
Page 16
Unordered list of concurrency models, Pessimistic concurrency

Typo in sentence "Every version of SQL Server prior to SQL Server 2005 used this currency model exclusively..." should be "concurrency" instead of "currency".

Note from the Author or Editor:
currency should be replaced with concurrency

Reshetnyak Eugene  Jan 17, 2014 
PDF
Page 29
6th paragraph

The section on "Backup Compression DEFAULT" indicate that only the Enterprise Edition of SQL 2012 can perform compressed backups. This is actually not the case as the Enterprise, Standard, Business Intelligence and Developer editions can perform compressed backups (only the Web and Express editions cannot). Details at http://technet.microsoft.com/en-us/library/cc645993.aspx#High_availability

Note from the Author or Editor:
This should be corrected, Change this sentence "Although only Enterprise edition instances can create a compressed backup, any edition of SQL Server 2012 can restore a compressed backup." to "As of SQL Server 2008R2, instances running Enterprise, Business Intelligence and Standard edition of SQL Server can create a compressed backup, and any edition of SQL Server 2008 or later can restore a compressed backup."

Nic Cain  Dec 12, 2013 
Printed, PDF
Page 30
First paragraph

" .... consider using Resource Governor ..." Perhaps here it should be mentioned that Resource Governor is only available in Enterprise Edition, especially since Backup compression is available in Standard Edition (as I mentioned in an earlier errata).

Note from the Author or Editor:
At the end of the first paragraph on page 30, add a parenthetical note after maximum CPU utilization. Add: "(Resource Governor, which is available only with Enterprise Edition, is discussed in Chapter 2."

Anonymous  Dec 29, 2013