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.
Version |
Location |
Description |
Submitted By |
Date submitted |
Date corrected |
Printed |
Page 454-455
"More Info" boxes |
References for "Designing SQL Server Endpoints" pointed to Chapter 8, should be pointed to Chapter 11.
Note from the Author or Editor: Please change the More Info note from Chapter 8 to Chapter 11.
|
Rich Weissler |
Jul 08, 2011 |
Jul 22, 2011 |
Printed |
Page 411
Table |
http://technet.microsoft.com/en-us/library/cc757143%28WS.10%29.aspx
Windows Server 2003 Standard Edition allows one to use NLB Clusters, but not MSCS clustering, which is required for clustering SQL Server.
(This is also important on page 408 when considering which operating system to use. Windows Server 2008 Standard Edition is fine for a two node cluster, fortunately.)
Note from the Author or Editor: In Table 14-2, please remove the first entry for Windows Server 2003 Standard Edition. There is no replacement or other correction.
|
Rich Weissler |
Jul 05, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 18
3rd paragraph of Collation Sequences |
In the following text, the same collation sequence is used for both examples. The second one should be SQL_Latin1_General_CP1_CI_AS and accent-sensitive (AI) should be accent-sensitive (AS).
"For example, if you use the collation sequence of SQL_Latin1_
General_CP1_CI_AI, you get support for a Western European character set that is case-insensitive
and accent-insensitive. SQL_Latin1_General_CP1_CI_AI treats e, E, ?, ?, ?, and ? as the same character
for sorting and comparison operations, whereas a case-sensitive (CS), accent-sensitive (AI) French
collation sequence treats each as a different character."
Note from the Author or Editor: Change "accent-sensitive (AI) French" to "accent-sensitive (AS) French"
|
Anonymous |
Jun 01, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 567
1st 3 lines |
Gives answer D as correct with the following reasoning:
'Correct: Because the Color column is nullable, the most efficient index for this query includes only the values that were not nullable. In addition, by including the ProductType and WoodSpecies columns, the query could be satisfied entirely by the index.'
This is not accurate, the query could not be satisfied entirely by the index because the query also selects the ProductName column which has not been included in the index.
Note from the Author or Editor: Chapter 4: Lesson 2: Answer D. Change "the query could be satisfied entirely by the index." to "the query could return data from the ProductAttributes table entirely from the index."
|
John Daisley |
May 22, 2011 |
Jul 22, 2011 |
Printed |
Page 106
Practice task 2 |
The task requires the reader to reorganise an index on the Person.Person table.
This table does not exist in AdventureWorks, but DOES exist in AdventureWorks2008, against which the requested task is successful.
The requirements at the start of the chapter state AW, rather than AW2008. This should updated, or the task restated appropriately.
Note from the Author or Editor: Page 85. Second bullet point underneath Before You Begin. Change AdventureWorks to AdventureWorks2008.
|
Simon Bailey |
Apr 24, 2011 |
Jul 22, 2011 |
Printed |
Page 74
3rd paragraph |
The line "Both global and local temporary tables are dropped automatically when the connection that created the tables is terminated." is incorrect.
It is true that local tables are dropped when the connection that created it is terminated. However, global temporary tables persist until all connections that are accessing it have been terminated, even when the connection that created it has long been terminated.
This is backed up by Books Online (http://msdn.microsoft.com/en-us/library/ms186986(v=SQL.100).aspx): "Local temporary tables are deleted after the user disconnects from the instance of SQL Server. Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server."
Note from the Author or Editor: Page 74, last sentence of paragraph 3. Change "Both global and local temporary tables are dropped automatically when the connection that created the tables is terminated." to "Local temporary tables are dropped automatically when the connection that created them is terminated. Global temporary tables are dropped when the last connection using them is terminated."
|
Anonymous |
Apr 24, 2011 |
Jul 22, 2011 |
Printed |
Page 29
In the practice section |
In the practice section on page 29, the user is directed to execute the following command:
EXEC sp_configure 'Database Mail XPs', 1
GO
RECONFIGURE;
GO
This produced an error stating 'Database Mail XPs' did not exists.
After researching I discovered that the following steps have to be performed first.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
The instructions should read as follows:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Database Mail XPs', 1
GO
RECONFIGURE;
GO
Note from the Author or Editor: Page 29, practice. Change the T-SQL in step 1 to:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
EXEC sp_configure 'Database Mail XPs', 1
GO
RECONFIGURE WITH OVERRIDE;
GO
NOTE TO EDITOR. This adds 4 more lines within the pagination, which creates a bit of an issue in trying not to make major formatting changes. So, the following changes can also be made at your discretion to consolidate and keep everything on the same page that it currently is. Change step 2 to include the text from step 3. Combine Step 6 and 7 into a single step and renumber the steps appropriately.
|
Anonymous |
Feb 10, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 548
Technical Requirements |
The Bookings and Customers databases
instead of
The Orders and Customers databases
Note from the Author or Editor: Page 548, Table 17-2. Change Bookings to Orders.
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 546
Paragraph Case Scenario: Planning for High Availability |
Delete " before beginning the next chapter".
This is a typical cut-an-paste-error of a lazy author. There is no next chapter. If the student imitates this laziness he just skips half of the book.
Note from the Author or Editor: Case Scenario: Planning for High Availability. Remove the text "before beginning the next chapter" in the paragraph.
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 501
line 12 |
12-14 hours of latency
in stead of
12-14 hours or latency
Note from the Author or Editor: Page 501, 4th paragraph. Change "12-14 hours or latency" to "12-14 hours of latency"
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 425
Step 40 and Figure 14-10 |
In step 40 lookup check box should be spelled with lower case l.
In figure 14-10 the Enable LMHOSTS lookup check box should be cleared.
Note from the Author or Editor: Page 425, step 40. Change "LMHOSTS Lookup" to "LMHOSTS lookup".
Figure 14-10, "LMHOSTS lookup" checkbox cleared
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 418
Practice step 6 |
sqldata.vhd
instead of
Qqldata.vhd
Note from the Author or Editor: Page 418, step 6, change "Qqldata.vhd" to "Sqldata.vhd"
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 377
first paragraph, lines 6 and 8 |
classifier function
instead of
classification function
Note from the Author or Editor: Page 377. Change all occurrences of "classifier function" to "classification function".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 376
Resource Governor - 3rd bullet |
- Classifier functions
instead of
- Classification functions
Note from the Author or Editor: Page 376. Change all occurrences of "classifier function" to "classification function".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 347
first line |
look very closely at Figure 12-13,
instead of
look very closely at Figure 12-11,
Note from the Author or Editor: Page 347, first line of text. Change "Figure 12-11" to "Figure 12-13".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 283
Lesson Summary - last bullet |
provide a means to elevate permissions
instead of
provide a means to escalate permissions
Note from the Author or Editor: Page 283, last bullet point of chapter summary. Change "escalate" to "elevate".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 280
top of page |
SELECT DocumentSummary, Title, FileName FROM Production.Document
instead of
SELECT DocumentNode, Title, FileName FROM Production.Document
Note from the Author or Editor: Not correctable as previously noted. The version of the AdventureWorks database has changed since the book was written and would require a major re-write to correct to the current version.
|
Otto ter Haar |
Feb 02, 2011 |
|
Printed, PDF |
Page 279
Step 4 |
SELECT DocumentSummary, Title, FileName FROM Production.Document
instead of
SELECT DocumentNode, Title, FileName FROM Production.Document
Note from the Author or Editor: Not correctable as previously noted. The version of the AdventureWorks database has changed since the book was written and would require a major re-write to correct to the current version.
|
Otto ter Haar |
Feb 02, 2011 |
|
Printed, PDF |
Page 274
top of page |
GRANT VIEW DEFINITION TO <user>
If you grant VIEW ANY DEFINITION to a login,
instead of the obvious spelling errors.
Note from the Author or Editor: Page 274. 3rd line. Code has an extraneous space in it. It should read "GRANT VIEW DEFINITION TO <user>"
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 226
Practice step 1 |
CREATE DATABASE AdventureWorksSnap ON
(NAME = N'AdventureWorks_Data',
instead of N'AdventureWorks2008_Data',
Note from the Author or Editor: Not correctable. These were the names of my database files, which differ from the current version of the AdventureWorks database on CodePlex. The reader can also change these names.
|
Otto ter Haar |
Feb 02, 2011 |
|
Printed, PDF |
Page 220
Practice 1 step 3 |
delete the AdventureWorks_Data.mdf file. Make certain that you do not delete the AdventureWorks_Log.ldf file.
The names of the files differ from the book.
Note from the Author or Editor: Not correctable since the files names have changed within the CodePlex files currently available and the reader can change these names to anything that they want.
|
Otto ter Haar |
Feb 02, 2011 |
|
Printed, PDF |
Page 101
Quick Check Answers 2. |
2. The FILLFACTOR option reserves space only on the leaf levels of the index.
and not on the intermediate levels as is emphasized on page 97.
Note from the Author or Editor: Page 101. Quick Check answer #2. Remove the text "intermediate and".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 152
penultimate bullet |
The source or target table cannot participate in replication
participate instead of participatie
Note from the Author or Editor: Page 152, bullet 6. Replace "participatie" with "participate"
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 147
line 8 from below |
CREATE NONCLUSTERED INDEX idx_employeefirstname
The s in firstname is missing
Note from the Author or Editor: Page 147 T-SQL script in Creating a Partitioned Index section. Change "CREATE NONCLUSTERED INDEX idx_employeefirtname" to "CREATE NONCLUSTERED INDEX idx_employeefirstname"
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 146
line 13 from below |
,to which the partition function will be applied.
The period at the end of the sentence is missing.
Note from the Author or Editor: Page 146, 13 lines from the bottom of page. There is a period missing after the word "applied".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 140
practice step 3 line 7 |
FILENAME = 'c:\test\db.mdf', SIZE = 3 MB),
The primary file file must be at least 3 MB to accommodate a copy of the model database.
Note from the Author or Editor: Page 140. Change "2MB" to "3MB".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 130
Practice 1 Step 5 |
first line: you now receive 43 rows of data
Note from the Author or Editor: This is not correctable due to the major changes that were done to AdventureWorks following publication of this book.
|
Otto ter Haar |
Feb 02, 2011 |
|
Printed, PDF |
Page 106
practice step 2 |
Table Person.Person does not exist.
Step 2 needs to be corrected or deleted.
Note from the Author or Editor: Same issue on this one. The structure of the AdventureWorks database was fundamentally changed after the release of this book and fixing this issue would require a major re-write of sections of the book.
|
Otto ter Haar |
Feb 02, 2011 |
|
Printed, PDF |
Page 102
Practice step 3 |
Table Person.Address does not contain a column named SpatialLocation.
Step 3 needs to be repaired or deleted.
Note from the Author or Editor: This is not fixable since they dramatically changed the structure of the AdventureWorks database after the release of this book. Correcting this would mean a major re-write of this section of the book.
|
Otto ter Haar |
Feb 02, 2011 |
|
Printed, PDF |
Page 100
first line of paragraph Tessellation |
second half of first line should read: "each row of spatial data is read and"
Note from the Author or Editor: Page 100, first sentence after the heading Tessellation. Change "each row is read of spatial" to "each row of spatial".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 44
First step of the practice |
Add the following sentence before step 1: Create a folder c:\test if it does not exist already.
Note from the Author or Editor: Page 44. Practice. Change the first sentence to "In this practice, you will create a database with multiple files that is enabled for FILESTREAM storage in the c:\test folder.
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 25
Practice 3 Step 2 |
Step 2 should read: 2. Navigate to the SQL Server 2008 product sample databases and download AdventureWorks2008_SR4.exe.
Note from the Author or Editor: Page 25, step 2. Change "AdventureWorks2008*.msi" to "AdventureWorks2008_SR4.exe"
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 24
top of page |
Step 8 comes after Step 9. The steps should change place.
Note from the Author or Editor: Page 24. Change order of steps 8 and 9. Step 8 should be step 9. Step 9 should be step 8.
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 3
Table 1.1 |
Athelon should be Athlon
Note from the Author or Editor: Page 3. Change "Athelon" to "Athlon".
|
Otto ter Haar |
Feb 02, 2011 |
Jul 22, 2011 |
Printed |
Page 66
Table 3-3 |
The character data type table lists maximum values for unicode and non-Unicode characters. Each data type (char,varchar,nchar and nvarchar) state "...up to a maximum of x bytes."
This is incorrect. The values listed are the maximum number of characters, not bytes. It should be changed to read:
"...up to a maximum of x characters."
Note from the Author or Editor: Page 66, table 3-3. Change "bytes" to "characters".
|
Alan Williamson |
Jan 23, 2011 |
Jul 22, 2011 |
Printed |
Page 37
Paragraph 1, Line 4 |
You will also learn how check and manage the integrity of a database.
should be
You will also learn how to check and manage the integrity of a database.
Note from the Author or Editor: Page 37, paragraph 1. Change the last sentence to read "You will also learn how to check and manage the integrity of a database."
|
Shahzad Ansari |
Dec 28, 2010 |
Jul 22, 2011 |
Printed |
Page 34
Case Scenario, Question 3. |
bsuiness should be business
Note from the Author or Editor: page 34. Change "bsuiness" to "business"
|
Shahzad Ansari |
Dec 28, 2010 |
Jul 22, 2011 |
Printed, PDF |
Page 562
Second Paragraph. Chapter 1 Lesson 3 1st Answer. |
As per the Step 6 of Practice-3 of Lesson-3 in Chapter-1 pg 25 we execute the following script to restore the Adventureworks database and the AdventureworksDW database on the installed SQL Server 2008 instance.
EXEC sp_configure 'filestream_access_level', 2;
GO
RECONFIGURE
GO
RESTORE DATABASE AdventureWorks FROM DISK='C:\Program Files\Microsoft SQL
Server\100\Tools\Samples\AdventureWorks2008.bak' WITH RECOVERY;
GO
RESTORE DATABASE AdventureWorksDW FROM DISK='C:\Program Files\Microsoft
SQL Server\100\Tools\Samples\AdventureWorksDW2008.bak' WITH RECOVERY;
GO
As per the script we use sp_configure to enable Filestream but in the Lession review answers of the first question the answer is marked as sp_filestream_configure.
This is quite misleading.
Note from the Author or Editor: Page 562, lesson 3, #1.
Correct answer is C.
Change answer C to "Correct. sp_configure is used to enable and change the support level for FILESTREAM"
Change answer D to "Incorrect. sp_filestream_configure was a stored procedure that was included in an early beta version of SQL Server 2008. This was removed in favor of using sp_configure."
|
Anonymous |
Dec 26, 2010 |
Jul 22, 2011 |
Printed |
Page 27
Lesson Review, Question 2, Choice 'C.' |
The choice was printed as follows:
C. QL Server Configuration Manager
it should be
C. SQL Server Configuration Manager.
Since this is the correct answer to the question, I got the answer wrong because of the typo.
Note from the Author or Editor: Page 27, Lesson Review, Question 2, Choice C. Change "QL Server" to "SQL Server".
|
Shahzad Ansari |
Dec 23, 2010 |
Jul 22, 2011 |
Printed, PDF |
Page 12
Table 1-2 Hardware support |
Table 1-2 seems to disagree with this information on the Microsoft site:
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
Note from the Author or Editor: Page 12. Table 1-2. Change to the following:
# of CPUs
Standard: 4
Workgroup: 2
Express: 1
Compact: OS Maximum
Database Size
Standard: 524PB
Workgroup: 524PB
Express: 10GB
Compact: 4GB
RAM
Standard: 64GB
Workgroup: 4GB
Express: 1GB
Compact: OS Maximum
|
Anonymous |
Oct 10, 2010 |
Jul 22, 2011 |
|
72
1st bulleted item in the list for row size limitation |
It says: "Reduce the data within a row so that the maximum row size is greater than 4,009 bytes"
Shouldn't it say: "Reduce the data within a row so that the maximum row size is less than 4,009 bytes"
Note from the Author or Editor: Page 72. First bullet point. Change "Reduce the data within a row so that the maximum row size is greater than 4,009 bytes" to "Reduce the data within a row so that the maximum row size is less than 4,009 bytes"
|
Anonymous |
Jul 26, 2010 |
Jul 22, 2011 |
Printed |
Page CD-ROM
|
Incorrect answers to Readiness Review question
In the practice test included on the Companion CD, one of the questions has several answers included incorrectly.
The question reads:
“Which of the following commands produces a list of SQL Server Agens Jobs that have been cancelled?”
Change:
“sp_help_jobhistory @run_status=5”
To:
“sp_help_jobhistory @run_status=3”
Change:
“sp_help @execution_status=1”
To:
“sp_help_job @execution_status=1”
Change:
“sp_help @execution_status=4”
To:
“sp_help_job @execution_status=4”
|
Microsoft Press |
Jul 13, 2010 |
|
Printed |
Page CD-ROM
|
Practice test question is incorrect
In the practice test included on the Companion CD, one of the questions is incorrect.
Change:
"You need to grant John the ability to create logins but not to assign permissions or reset passwords.
To which fixed server role should you add John?"
To:
"You need to grant John the ability to create logins, assign permissions, and reset passwords.
To which fixed server role should you add John?"
|
Microsoft Press |
Jul 13, 2010 |
|
Printed |
Page 13
|
No should be 16
On page 13, the Multiple Instances line of Table 1-3 is incorrect.
Change:
Multiple Instances No No No NoTo:
Multiple Instances 16 16 16 16
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 19
|
Note is incorrect
On page 19, the NOTE is incorrect and should be disregarded.
Note from the Author or Editor: Note deleted for the 7/22/2011 printing.
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 22
|
Additional step needed to create another account
On page 22, Practice 1 requires an additional step after Step 5 to create the SQL2008TK432FullText account.
Add the following line after Step 5:
"6. Repeat steps 3 and 4 to create another account named SQL2008TK432FullText."
Note from the Author or Editor: Step 5 changed from:
"5. Repeat steps 3 and 4 to create another account named SQL2008TK432SQLAgent."
to:
"5. Repeat steps 3 and 4 to create another account named SQL2008TK432SQLAgent, and again to create an account named SQL2008TK432FullText."
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 25
|
Step 6 is no longer required for sample database installation
On page 25, Step 6 is not required as the current AdventureWorks database installers from the CodePlex website install the database without the need for any additional tasks. This step should be removed and Step 7 should be renumbered to Step 6.
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 27
|
Lesson Review question needs to be removed
On page 27, Lesson 3 Review question 1 includes concepts not convered in the Lesson or Chapter and should be removed.
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 64
|
Exponents not printed
On page 64, some of the numbers in Table 3-1 should be printed as exponents, but are not.
Change:
INT -231 to 231-1 4 bytes
BIGINT -263 to 263-1 8 bytes
DECIMAL(P,S) and
NUMERIC(P,S) -1038+1 to 1038-1 5 to 17 bytes
SMALLMONEY -214,748.3648 to 214,748.3647 4 bytes
MONEY -922,337,203,685,477.5808 to
922,337,203,685,477.5807 8 bytes
REAL -3.438 to -1.1838, 0, and 1.1838 to 3.438 4 bytes
FLOAT(N) -1.79308 to -2.23308, 0, and 2.23308 to
1.79308 4 bytes or 8 bytes
To:
INT -2^31 to 2^31-1 4 bytes
BIGINT -2^63 to 2^63-1 8 bytes
DECIMAL(P,S) and
NUMERIC(P,S) -10^38+1 to 10^38-1 5 to 17 bytes
SMALLMONEY -214,748.3648 to 214,748.3647 4 bytes
MONEY -922,337,203,685,477.5808 to
922,337,203,685,477.5807 8 bytes
REAL -3.4^38 to -1.18^38, 0, and 1.18^38 to 3.4^38 4 bytes
FLOAT(N) -1.79^308 to -2.23^308, 0, and 2.23^308 to
1.79^308 4 bytes or 8 bytes
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 203
|
CONTINUE_PAST_ERROR should be CONTINUE_AFTER_ERROR
On page 203, the first sentence is incorrect.
Change:
"To continue past the error and back up as many pages as possible, you can specify the CONTINUE_PAST_ERROR option."
To:
"To continue past the error and back up as many pages as possible, you can specify the CONTINUE_AFTER_ERROR option."
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 562
|
Lesson Review question 1 needs to be removed
On page 562, the answer to question 1 under Lesson 3 is an answer that hasn't had it's concepts reviewed in the Lesson or Chapter and should be removed.
Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.
|
Microsoft Press |
Jul 13, 2010 |
Jul 22, 2011 |
Printed |
Page 12
Tables 1-2 through 1-7 on pages 12-14 |
In the note on SQL Server editions it states "we will discuss only the editions that can be deployed into production environments: Express, Workgroup, Standard, and Enterprise." However in the six tables following the features of Standard, Workgroup, Express, and Compact are listed with no mention of Enterprise. My assumption is that Enterprise includes all these features, but this should either be explicitly stated before the tables or Enterprise should be given its own column in the tables.
Note from the Author or Editor: Page 12. Last sentence of Note. Change "Express, Workgroup, Standard, and Enterprise" to "Compact, Express, Workgroup, Standard, and Enterprise". Add the following sentence to the note: "Enterprise Edition supports all features and available hardware options."
|
Anonymous |
May 19, 2010 |
Jul 22, 2011 |
Printed |
Page 561
Lesson 1, #2, answer B |
The last word of the sentence says "Code" but should read "Core".
Note from the Author or Editor: Page 561 Lesson 1, #2, answer B. Change "Code" to "Core".
|
Anonymous |
May 19, 2010 |
Jul 22, 2011 |
Printed |
Page 217
Under "Restore a Corrupt Page", first paragraph, second sentence; |
Page contents can become consistent when the page checksum does not match the contents of the page or a row is only partially written to the page.
should say:
Page contents can become inconsistent when the page checksum does not match the contents of the page or a row is only partially written to the page.
Note from the Author or Editor: Page 217 Under "Restore a Corrupt Page", first paragraph, second sentence. Change "consistent" to "inconsistent".
|
Anonymous |
Mar 24, 2010 |
Jul 22, 2011 |