- ISBN13: 978-1-59059-980-8
- ISBN10: 1-59059-980-2
- 872 pp.
- Published Jul 2008
- Print Book Price: $59.99
- eBook Price: $41.99
Errata Submission
If you think that you've found an error in SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.
Errata
| Issue | Author's Response |
|---|---|
| Chapter 2, Page 83 Near the top of the page, "garage collector" should be "garbage collector." |
Thanks very much for submitting this feedback. If there is a second printing, we will include this correction in a future edition. Best Regards, Joe Sack |
| Chapter 2, Page 87 DELETE Production.ProductProductPhoto FROM Production.Example_ProductProductPhoto ppp LEFT OUTER JOIN Production.Product p ON ppp.ProductID = p.ProductID WHERE p.ProductID IS NULL This query deletes all the rows in the Production.ProductProductPhoto table, instead of deleting rows from Production.Example_ProductPeroductPhoto that don't match the Product table. It should be DELETE Production.Example_ProductProductPhoto |
Thanks for your feedback - I'll make sure this modification makes it on the next version (should there be a reprint). Best Regards, Joe |
| Chapter 3 Page 136 This is only a slight (perhaps typing error)correction of the 'session_id 53' written in "How It Works" section. I think session_id 53 instead have typed 'session_id 54' that was returned as a result of the given query on the previous page (i.e page 135): SELECT blocking_session_id, wait_duration_ms, session_id FROM sys.dm_os_waiting_tasks WHERE blocking_session_id IS NOT NULL |
Thanks for your feedback - I'll make to have this fixed in a future reprint. Much appreciated. Best Regards, Joe |
| Chapter 3 Page 136 This is only a slight (perhaps typing error)correction of the 'session_id 53' written in "How It Works" section. I think session_id 53 instead have typed 'session_id 54' that was returned as a result of the given query on the previous page (i.e page 135): SELECT blocking_session_id, wait_duration_ms, session_id FROM sys.dm_os_waiting_tasks WHERE blocking_session_id IS NOT NULL |
Thanks for your feedback - I'll make sure this change gets in to a future reprint. Thanks again and Best Regards, Joe |
| Page 707. Missing SET command | Will correct, Thanks! |
| On page 754 "How it works," you say that ID 2, AdventureWorks has the highest number stalls. However, the result set shows that tempdb, file 1, and AdventureWorks, file 1, are both higher. | Thanks. This will be fixed in a future reprint. |
| Page 117 - "ROLLBACK TRANSACTION AND COMMIT TRANSACTION decrements @@TRANCOUNT by 1" should read "ROLLBACK TRANSACTION decrements @@TRANCOUNT to 0." | Will be resolved in future edition. Thanks for the submission! |
| The example in chapter 12 page 390 claims to restrict logons from between 7 AM and 5 PM, but actually restricts them from 7 AM to 6 PM (exclusive), due to stripping off the minutes, seconds, and milliseconds using the DATEPART function. | Hello, Thanks for submitting the feedback. You are correct that this value would include time leading up to 6PM, so I will address that sentence in a future reprint. Best Regards, Joe Sack |
| There were a couple of changes that I submitted to CE but were not included in the book: Chapter 2, Page 91 - the CTP6 version of the MERGE syntax, instead of the RC0 version was used. Here is the corrected, RC0 version of the syntax: MERGE INTO HumanResources.CorporateHousing p USING dbo.StagingCorporateHousing s ON p.UnitNBR = s.UnitNBR WHEN MATCHED AND s.IsRentedIND <> p.IsRentedIND THEN UPDATE SET IsRentedIND = s.IsRentedIND WHEN NOT MATCHED BY TARGET THEN INSERT (UnitNBR, IsRentedIND) VALUES (s.UnitNBR, s.IsRentedIND) WHEN NOT MATCHED BY SOURCE THEN DELETE; Chapter 2, Page 98 - the @partition_switch argument should be removed from sys.sp_cdc_enable_table |
This is actually errata submitted by the author (Joseph Sack). I wanted to have this documented on the Apress site, Thanks. |
