My new book "SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach" has been printed and will be shipped in less than two weeks (December 12th). You can pre-order it now. As of today, Amazon is selling it for $37.79 at this link. Amazon hasn't updated the book information with the latest page count and description - but this should be updated soon. In the meantime, you can check out the up-to-date book specs on Apress here.
On a side note - my Grandmother told me she doesn't like the author photo. I told her that luckily it will be on the back of the book, and not the front.
I wrote SQL Server 2005 T-SQL Recipes in a problem/solution style, including hundreds of "How To" scenarios for SQL Server development and administration tasks. The table of contents is as follows (I don't include the detailed chapter break-out here - as that's several pages long):
CHAPTER 1 SELECT
CHAPTER 2 INSERT, UPDATE, DELETE
CHAPTER 3 Transactions, Locking, Blocking, and Deadlocking
CHAPTER 4 Tables
CHAPTER 5 Indexes
CHAPTER 6 Full-Text Search
CHAPTER 7 Views
CHAPTER 8 SQL Server Functions
CHAPTER 9 Conditional Processing, Control-Of-Flow, and Cursors
CHAPTER 10 Stored Procedures
CHAPTER 11 User-Defined Functions and Types
CHAPTER 12 Triggers
CHAPTER 13 CLR Integration
CHAPTER 14 XML
CHAPTER 15 Web Services
CHAPTER 16 Error Handling
CHAPTER 17 Principals
CHAPTER 18 Securables and Permissions
CHAPTER 19 Encryption
CHAPTER 20 Service Broker
CHAPTER 21 Configuring and Viewing SQL Server Options
CHAPTER 22 Creating and Configuring Databases
CHAPTER 23 Database Integrity and Optimization
CHAPTER 24 Maintaining Database Objects and Object Dependencies
CHAPTER 25 Database Mirroring
CHAPTER 26 Database Snapshots
CHAPTER 27 Linked Servers and Distributed Queries
CHAPTER 28 Performance Tuning
CHAPTER 29 Backup and Recovery
I hope that readers find it useful, and I'm looking forward to hearing the feedback.