- Shopping Bag ( 0 items )
Posted November 30, 2009
Inside Microsoft SQL Server 2005: T-SQL Programming, by Itzik Ben-Gan. The book covers a lot on t-sql programming from temp tables, cursors to user defined functions. The book has a lot of code samples you can use. I have to mention that the book is dedicated to Itzik Ben-Gan's grandparents. This is a great book when you want to get to know t-sql. This is an excellent book for an intermediate/advanced developer. There is so much new stuff in SQL Server 2005 compared to 2000 to help you with tuning queries that you probably want to read each chapter several times. The Dynamic Management Views are a big help and this book shows you how to use them. Some other cool stuff in this book is the discussion of internal tables, undocumented DBCC commands and undocumented trace flags to discover information which could help you determine much faster what the cause of a performance problem might be. Some pages are packed with so much information that you need to pause for a second and process all that info (I have read some pages two to three times in a row). You will also find out that there are more joins besides left, full and outer. Page 137 for example has a nice table with the three Physical Join Operators: Nested Loop Join, Hash Join and Merge Join. This table lists the characteristics for each of these joins. If you are an intermediate to advanced developer then I highly recommend this book.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted October 21, 2006
Posted November 28, 2006
A wonderful T-SQL Programming reference book
'Inside SQL Server: T-SQL Programming' is an excellent book, invaluable to both SQL Server DBA or Developer and has something for even the most experienced programmer. This book will help you take full advantage of all the new T-SQL features of SQL 2005.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted November 9, 2008
No text was provided for this review.