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 |
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 |
|
| Printed, PDF, ePub, |
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, 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 |
|
| 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 |
|