Accompanying CD doesn't seem to have all scripts referenced in the book specifically..amalgam.innocuous_wait_types. Is there someplace to get the missing items.

Sue, I found the files missing from the CD as well, even though they are mentioned in the book.

I just tried registering the book at www.awprofessional.com in order to get the files and the support/download portion of their web-site does not work.(The entire AW site seems a bit convoluted.) I even tried the 45day Safari on-line option and still no downloadable files. This will most likely be the last Addison-Wesley book I purchase even if the author(s) have a good reputation....wasted too much valuable time already.

I asked Ken (in direct email) the same question regarding the CD and missing samples and look what he answered me:

We're about to post an update to the CD on the web.  Are you subscribed to

my MSDN blog?  I will announce it there once it's ready. Should be there by

Monday at the latest.

It was on January 31 and today is Wednesday, actually...

Hi, Ken

Ch1 Page 6 of your new book (SQL 2005 troubleshooting) said,

"The session-level focus also.........Both sysprocesses and sys.dm_os_waiting_tasks display only the session ID of the blocking......."

should it be sys.dm_exec_requests rather than sys.dm_os_waiting_tasks?

Thank you,

Bill

Hi, Ken

Ch1 Page 6 of your new book (SQL 2005 troubleshooting) said,

"The session-level focus also.........Both sysprocesses and sys.dm_os_waiting_tasks display only the session ID of the blocking......."

should it be sys.dm_exec_requests rather than sys.dm_os_waiting_tasks?

Thank you,

Bill

I attempted to acces the web page,  http://www.khen.com/sspt.htm, in order to access the cd changes.  I also purchased the book and was disappointed to find missing code as referenced as early as page 5.  However, this page is not available.  Any additional info to guide us to the full cd contents???

Please forward response to jeffreydjoy@hotmail.com