MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance

Errata for MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance




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 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, 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 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, 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
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, 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
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, 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
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, 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
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 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
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
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
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, 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
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 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
Safari Books Online
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 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, 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 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 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 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
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, 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 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 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 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 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
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 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
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 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 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 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 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 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 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 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 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
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 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 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
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, 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 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 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
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 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, 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, 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