Guru's Guide to Transact-Sql
Ken Henderson
ISBN 10: 0201615762 ISBN 13: 9780201615760
Published by Addison-Wesley Professional February 2000, 2000
Used
Trade Paperback
From
Colorado's Used Book Store, Englewood, CO, U.S.A.
Seller rating 2 out of 5 stars
AbeBooks Seller since August 20, 2012
This specific item is no longer available.
About this Item
Description:
Light edge and cover wear. Unmarked pages. All Orders Shipped With Tracking And Delivery Confirmation Numbers. Seller Inventory # 452307
Synopsis:
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.
About the Author:
Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences.
0201615762AB07032003
"About this title" may belong to another edition of this title.
Bibliographic Details
Title: Guru's Guide to Transact-Sql
Publisher: Addison-Wesley Professional February 2000
Publication Date: 2000
Binding: Trade Paperback
Condition: Very Good
Top Search Results from the AbeBooks Marketplace
Stock Image
The Guru's Guide to Transact-SQL
Published by
Addison-Wesley Professional, 2000
ISBN 10: 0201615762
ISBN 13: 9780201615760
Used
Paperback
Seller: Open Books, Chicago, IL, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. General wear from age and use. Heavy edge wear. Open Books is a nonprofit social venture that provides literacy experiences for thousands of readers each year through inspiring programs and creative capitalization of books. Seller Inventory # mon0000808666
Quantity: 1 available
Stock Image
Gurus Guide to TransactSQL The
Published by
Addison-Wesley Professional, 2000
ISBN 10: 0201615762
ISBN 13: 9780201615760
Used
Softcover
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00067757974
Quantity: 5 available
Stock Image
Gurus Guide to Transact-SQL, The
Seller: Country House Library, Gloucester, GLOS, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Used; Very Good. Dispatched, from the UK, within 48 hours of ordering. Though second-hand, the book is still in very good shape. Minimal signs of usage may include very minor creasing on the cover or on the spine. Damaged book. Slightly damaged in some way typically, a grazed corner or torn cover. Highlighting on some pages of the book. Seller Inventory # CHL10367107
Quantity: 1 available
Stock Image
Gurus Guide to TransactSQL The
Published by
Addison-Wesley Professional, 2000
ISBN 10: 0201615762
ISBN 13: 9780201615760
Used
Softcover
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00069888794
Quantity: 2 available
Stock Image
Guru's Guide to Transact-SQL, The
Published by
Addison-Wesley Professional (edition First Edition), 2000
ISBN 10: 0201615762
ISBN 13: 9780201615760
Used
Paperback
First Edition
Seller: BooksRun, Philadelphia, PA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. First Edition. Supplements included. It's a preowned item in good condition and includes all the pages. It may have some general signs of wear and tear, such as markings, highlighting, slight damage to the cover, minimal wear to the binding, etc., but they will not affect the overall reading experience. Seller Inventory # 0201615762-11-1-116
Quantity: 1 available
Stock Image
The Guru's Guide to Transact SQL
Seller: AwesomeBooks, Wallingford, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. The Guru's Guide to Transact SQL This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 7719-9780201615760
Quantity: 2 available
Stock Image
The Guru's Guide to Transact SQL
Seller: Bahamut Media, Reading, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 6545-9780201615760
Quantity: 2 available
Stock Image
Guru's Guide to Transact-SQL, The
Published by
Pearson Education Limited, United Kingdom, Harlow, 2000
ISBN 10: 0201615762
ISBN 13: 9780201615760
Used
Paperback
Seller: WorldofBooks, Goring-By-Sea, WS, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. 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. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Seller Inventory # GOR002653693
Quantity: 2 available
Stock Image
The Guru's Guide to Transact-SQL
Published by
Pearson Education, Limited, 2000
ISBN 10: 0201615762
ISBN 13: 9780201615760
Used
Softcover
First Edition
Seller: Better World Books Ltd, Dunfermline, United Kingdom
Seller rating 5 out of 5 stars
Condition: Very Good. 1st. Ships from the UK. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # GRP83661983
Quantity: 1 available
Stock Image
The Guru's Guide to Transact-Sql
Published by
Addison-Wesley Professional, 2000
ISBN 10: 0201615762
ISBN 13: 9780201615760
Used
Paperback
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less 2.05. Seller Inventory # G0201615762I5N00
Quantity: 1 available