The Guru's Guide To Transact-SQL By Robbe Morris

The Guru's Guide To Transact-SQL

By Robbe D. Morris

Printer Friendly Version

Robbe & Melisa Morris

The Guru's Guide To Transact-SQL by Ken Henderson is more of a large collection of elaborate SQL Server Transact-SQL code samples than a book that you or I have become accustomed to purchasing nowadays. That being said, those of you who really need a lot of conceptual background information in order to learn probably will not like this book. However, if you prefer a multitude of complex code samples not covered in most online articles or other technical books, you are going to be in hog heaven.

The author has written a wonderful book that acts like a teacher sitting next to you. Most of the samples are complete stored procedures and not bits and pieces of key sections. This allows you to digest the code and apply it more quickly. Keep in mind, the topics covered are much much more than your typical select * from tablename. Ken goes into great detail with subjects such as Full-Text Search, System and Administration procedures, SQL-DMO, and OLE Automation. Just about anything you might want to do from an administration standpoint is covered in detail. Plus, the section on undocumented features is worth the price of the book alone. With this book, you'll be armed with enough material to be dangerous...maybe a little too dangerous.

Chapters

1.	Introductory Transact-SQL
2.	Transact-SQL Data Type Nuances
3.	Missing Values
4.	DDL Insights
5.	DML Insights
6.	The Might SELECT Statement
7.	Views
8.	Statistical Functions
9.	Runs and Sequences
10.	Arrays
11.	Sets
12.	Hierarchies
13.	Cursors
14.	Transactions
15.	Stored Procedures and Triggers
16.	Transact-SQL Performance Tuning
17.	Administrative Transact-SQL
18.	Full-Text Search
19.	OLE Automation
20.	Undocumented T-SQL
21.	Poppourri


	Robbe has been a Microsoft MVP in C# since 2004. He is also the co-founder of EggHeadCafe which provides .NET articles, book reviews, software reviews, and software download and purchase advice.