Errata

Incorrect Service Pack listed for Windows Server 2003 in software requirements
On page xxvi, the first bullet under Software Requirements reads:



"Microsoft Windows 2003 Server with Service Pack 2 (SP2) or later"



It should read:



"Microsoft Windows 2003 Server with Service Pack 1 (SP1) or later"

Incorrect explanation for practice test question answer In the practice test included on the Companion CD, one of the questions reads: "You are creating a database maintenance plan. Which of the following available maintenance tasks will compact a clustered index?" The third sentence of the answer explanation is incorrect. Change: "The Update Statistics task can be used to compact a clustered index." To: "The Update Statistics task cannot be used to compact a clustered index."

Code sample is not valid SQL Server code On page 7, the code sample in the Real World box is for Oracle, not SQL Server. Change: "Cynics on the Internet (and they abound) list procedures that artificially raise the value of the buffer cache hit ratio and use this information to discredit the use of the counter as a diagnostic tool. Here is one such procedure:" To: "Cynics on the Internet (and they abound) list procedures that artificially raise the value of the buffer cache hit ratio and use this information to discredit the use of the counter as a diagnostic tool. Here is one such procedure (Note that this is not valid SQL Server code, and is only intended as an example):"

The word "maximum" is used in place of "minimum"
On page 107, the last bullet point on the page reads:



"The maximum CPU time, in microseconds, that the plan has ever consumed during a single execution"



It should read:



"The minimum CPU time, in microseconds, that the plan has ever consumed during a single execution"

Operating system referenced in place of SQL Server 2005 instance On page 313, the second bullet point reads: "Prior to beginning the test, ensure that the same hotfixes, service packs, and security updates that are installed on the production computer’s operating system are also installed on the test computer’s SQL Server 2005 instance." It should read: "Prior to beginning the test, ensure that the same hotfixes, service packs, and security updates that are installed on the production computer’s SQL Server 2005 instance are also installed on the test computer’s SQL Server 2005 instance."

Missing backslash in server path name
On page 340, Step 8 reads:



"Set the Path field to localhost eports."



It should read:



"Set the Path field to \localhost eports."

Negative incorrectly included in review question On page 394, the last sentence of question 2 reads: "When Ian creates a package and configures the package protection level, which of the following settings should he not use to ensure that Orin doesn’t have to re-enter sensitive values when he opens the package?" It should read: "When Ian creates a package and configures the package protection level, which of the following settings should he use to ensure that Orin doesn’t have to re-enter sensitive values when he opens the package?"

bin data type referenced in place of bit
On page 445, the answer to Quick Check question 2 reads:



"You would use the bin data type to accomplish this task."



It should read:



"You would use the bit data type to accomplish this task."

UNIQUE constraint referenced in place of DISTINCT On page 516, answer A to question 1 reads: "A SELECT clause with a UNIQUE constraint" It should read: "A SELECT clause with a DISTINCT constraint"

UNIQUE constraint referenced in place of DISTINCT
On page 729, the first sentence of answer A to question 1 of Lesson 2 reads:



"The UNIQUE constraint ensures that a SELECT statement does not return duplicate rows in a result set."



It should read:



"The DISTINCT constraint ensures that a SELECT statement does not return duplicate rows in a result set."

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.