Go To Homepage



Book Details
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach book cover
  • By Joseph Sack
  • 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.

Submit Errata
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach (978-1-59059-980-8)

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.