 |
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach View Larger Image | Joseph Sack
Apress, Paperback, Published December 2005, 768 pages, ISBN 159059570X | List Price: $59.99
Our Price: $36.50
You Save: $23.49 (39% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 1 Average Customer Rating:   Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Inside Microsoft SQL Server 2005: T-SQL Programming; Dejan Sarka, et al, $28.50, 37% Off!
- Pro SQL Server 2005 Database Design and Optimization; Louis Davidson, et al, $36.50, 39% Off!
- Microsoft SQL Server 2005 Administrator's Companion; Edward Whalen, et al, $37.50, 37% Off!
- Professional SQL Server 2005 Integration Services; Brian Knight, et al, $30.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands?
Not finding what you need from SQL Server books online? Or perhaps you just want
to familiarize yourself with the practical application of new T-SQL-related features.
SQL Server 2005 T-SQL Receipes: A Problem-Solution Approach is an ideal book,
whatever your level as a DBA or developer.
This "no-fluff" desk reference offers direct access to the information
you need to get the job done. It covers basic T-SQL data manipulation, the use
of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database
security and maintenance. It also provides hundreds of practical recipes that
describe the utilities of features and functions, with a minimim of background
theory.
Additionally, this book provides "how-to" answers to common SQL Server
T-SQL questions, conceptual overviews, and highlights of new features introduced
in SQL Server 2005. It also features concise T-SQL syntax examples, and you
can use the book to prepare for a SQL Server-related job interview or certification
test.
Table of Contents
About the Author xxiii
About the Technical Reviewer xxv
Acknowledgments . xxvii
Introduction xxix
CHAPTER 1 SELECT 1
CHAPTER 2 INSERT, UPDATE, DELETE 61
CHAPTER 3 Transactions, Locking, Blocking, and Deadlocking 83
CHAPTER 4 Tables 109
CHAPTER 5 Indexes 155
CHAPTER 6 Full-Text Search 173
CHAPTER 7 Views 191
CHAPTER 8 SQL Server Functions 209
CHAPTER 9 Conditional Processing, Control-Of-Flow, and Cursors 255
CHAPTER 10 Stored Procedures 271
CHAPTER 11 User-Defined Functions and Types 289
CHAPTER 12 Triggers 313
CHAPTER 13 CLR Integration 337
CHAPTER 14 XML 355
CHAPTER 15 Web Services 375
CHAPTER 16 Error Handling 393
CHAPTER 17 Principals 407
CHAPTER 18 Securables and Permissions 433
CHAPTER 19 Encryption 459
CHAPTER 20 Service Broker 485
CHAPTER 21 Configuring and Viewing SQL Server Options 517
CHAPTER 22 Creating and Configuring Databases 523
iiiCHAPTER 23 Database Integrity and Optimization 571
CHAPTER 24 Maintaining Database Objects and Object Dependencies 589
CHAPTER 25 Database Mirroring 595
CHAPTER 26 Database Snapshots 615
CHAPTER 27 Linked Servers and Distributed Queries 621
CHAPTER 28 Performance Tuning 637
CHAPTER 29 Backup and Recovery 683
INDEX 717
About the Author
Joseph Sack is a database administration and developer consultant based in
Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL
Server environments for clients in the financial services, IT consulting, manufacturing,
and real estate industries. Sack received his bachelor's degree in psychology
from the University of Minnesota. He is the author of SQL Server 2000 Fast Answers
for DBAs and Developers and a Microsoft Certified Database Administrator (MCDBA).
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Sep 12, 2006 Michael Morrison from USA
Excellent book on T-SQL
SQL developers experienced with non-Oracle databases or sqlserver developers who are looking for a good reference manual should definitely pick up a copy of this book. Inexperienced SQL developers will probably get more out of other excellent book T-SQL. This book begins exactly the way experienced developers would expect-it starts out at a running pace. The book takes the next hundred-or-so pages just discussing T-sql basics to extremes. Where this book excels is in its examples. Each and every SQL example is clearly illustrated with many clear and relevant examples. The author then begins into a discussion of advanced T-SQL techniques, which includes a discussion of cursors, built-in functions, and records. This discussion naturally leads into advanced T-SQL techniques including transactions, and various built-in T-SQL code. The author discusses use and retrieval of data in this format. I would highly recommend this book to experienced and beginner or even Oracle developers who want to sharpen their T-SQL skills or who are looking for a really good T-SQL reference. This is a must-have book for anyone serious about theirT-SQL development work.
|
|
