The Guru's Guide to Transact-SQL eBook: Ken Henderson, Joe Celko: Amazon.de: Kindle-Shop

Kurzbeschreibung

Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management.

This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical computations to the bevy of undocumented features in the language, The Guru's Guide to Transact-SQL imparts the knowledge you need to become a virtuoso of the language as quickly as possible.

In this book, you will find the information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Some 600 code examples not only illustrate important concepts and best practices, but also provide working Transact-SQL code that can be incorporated into your own real-world DBMS applications.

Your journey begins with an introduction explaining language fundamentals such as database and table creation, inserting and updating data, queries, joins, data presentation, and managing transactions. Moving on to more advanced topics, the journey continues with in-depth coverage of:

Transact-SQL performance tuning using tools such as Query Analyzer and Performance Monitor
Nuances of the various T-SQL data types
Complex statistical calculations such as medians, modes, and sliding aggregates
Run, sequence, and series identification and interrogation
Advanced Data Definition Language (DDL) and Data Management Language (DML) techniques
Stored procedure and trigger best practices and coding methods
Transaction management
Optimal cursor use and caveats to look out for
Full-text search
Hierarchies and arrays
Administrative Transact-SQL
OLE Automation
More than 100 undocumented commands and language features, including numerous unpublished DBCC command verbs, trace flags, stored procedures, and functions

Comprehensive, written in understandable terms, and full of practical information and examples, The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code.

Synopsis

In The Guru's Guide to Transact-SQL, one of the world's leading Microsoft SQL Server 7 developers has written the ideal combination of tutorial and reference, bringing together all the information and skills developers need to create outstanding database applications. Beginners and intermediate developers will appreciate the comprehensive tutorial that walks step-by-step through building a real client/server database, from concept to deployment and beyond -- and points out key pitfalls to avoid throughout the process. Experienced users will appreciate the book's comprehensive coverage of the Transact-SQL language, from basic to advanced level; detailed ODBC database access information; expert coverage of concurrency control, and more. The book includes thorough, up-to-the-minute guidance on building multi-tier applications; SQL Server performance tuning; and other crucial issues for advanced developers. For all database developers, system administrators, and Web application developers who interact with databases in Microsoft-centric environments.

Alle Produktbeschreibungen

Kundenrezensionen

5 Sterne

4 Sterne

3 Sterne

2 Sterne

1 Sterne

32 Rezensionen

4.8 von 5 Sternen

Kundenrezension verfassen

Die hilfreichsten Kundenrezensionen

1 von 1 Kunden fanden die folgende Rezension hilfreich

If you want to become a T-SQL guru yourself, get this book 18. September 2000

Von Chris J. Parsons

Format:Taschenbuch

Ah, where to begin. This book is a masterpiece. It is over the top. It distills, in one volume, all that's worth knowing about advanced Transact-SQL. If you've read the Books Online, this book is a natural next step in your T-SQL education. It took me from a rank amateur to an advanced coder within days. It gave me insights into new ways of coding that I'd never have thought of on my own. It showed me how to work in harmony with T-SQL and SQL Server, rather than try to get them to do things they weren't designed to do.

The best chapters, are, IMHO, these:

- DML Insights

- DDL Insights

- The Mighty SELECT

- Statistical Functions

- Transactions

- Cursors

- Sets

- Arrays

- Stored Procedures and Triggers

- T-SQL Performance Tuning

- Administrative T-SQL

- OLE Automation

- Undocumented T-SQL

There's so much good info in this book, it's hard to pick a list of the "best chapters." To be sure, there's not a weak chapter in the book, and you should read every last one of them.

Another reviewer called this book the ultimate magnum opus for T-SQL. He was right. This book is a must-read for anyone serious about coding in Transact-SQL.

Kommentar |

War diese Rezension f�r Sie hilfreich?

Nein

The best practical guide on Transact-SQL around 18. September 2000

Von Shawn B.

I love this book because it's so practical. It doesn't have the obligatory fluff that most computer books have. It cuts to the chase and gets right down to business immediately. I like that. And I like the fact that it focuses on things not in the Books Online. Want to learn how to do full-text searching from Transact-SQL? See Chapter 18. Want to learn how cursors really work and when you should and shouldn't use them? See Chapter 14. Want to learn advanced techniques and pitfalls to watch out for? See Chapter 15. This book has it all. If you want to become an expert SS practitioner, get this book.

Comprehensive, brilliant, witty, insightful... 18. September 2000

Von Bill T. Evans

This is a wonderfully insightful book. I learned more in the first chapter than I've learned in the entirety of other SQL books. For example, I learned that row positioning problems (e.g., computing a median) don't require a cursor. This one insight alone opened a whole new way of coding SQL for me. I learned how transactions *really* work - something no other book gave me. I carry this book to and from the office with me - that should tell you how much I value it.