Inside Microsoft Sql Server 2005

Overview

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the ...

See more details below
Paperback (REV)
$34.59
BN.com price
(Save 23%)$44.99 List Price
Other sellers (Paperback)
  • All (38) from $1.99   
  • New (6) from $4.58   
  • Used (32) from $1.99   
Sending request ...

Overview

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming language—solving complex problems with real-world solutions.

Discover how to:

  • Understand when to apply set-based programming techniques
  • Design and implement date and time-related XML and CLR datatypes
  • Use temporary objects, including temporary tables, table variables, and table expressions
  • Work with T-SQL and CLR user-defined functions, stored procedures, and triggers
  • Support user input-based queries and variable data with dynamic execution
  • Work with transactions and new exception handling constructs
  • Apply a concurrency model to support simultaneous users
  • Use Service Broker for controlled asynchronous processing in database applications

    This book includes code samples on the Web.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
If you’re an experienced T-SQL programmer, or a database pro who writes or reviews T-SQL code, Inside Microsoft SQL Server 2005: T-SQL Programming will take your T-SQL skills to a whole new level.

We’ve praised this book’s companion volume, Inside Microsoft SQL Server 2005: T-SQL Querying, elsewhere. Here, Microsoft SQL Server MVP Itzik Ben-Gan turns from set-based querying to programmatic T-SQL constructs, while also offering extensive coverage of both XML and .NET integration.

Ben-Gan opens by discussing several crucial datatype-related programming problems. You’ll learn how to avoid trouble with DATETIME arising from misconceptions about its storage format, or differences in its representation conventions. You’ll also gain important pointers on character manipulation, from pattern matching and parsing to case sensitivity.

Next, Ben-Gan turns to another common task: materializing data temporarily. He compares temporary tables to other alternatives, shows how to use the right temporary object for each task, and helps programmers avoid abusing temporary tables and variables. There’s a full chapter on cursors: when they still make sense and why they so often don’t.

After thorough discussions of dynamic execution and views, Ben-Gan and contributing author Dejan Sarka turn to XML and .NET integration via user-defined types and functions, stored procedures, and triggers (both CLR and DDL). You’ll find extensive code samples, available in both C# and Visual Basic .NET.

The book’s full chapter on transactions introduces SQL Server 2005’s new snapshot-based isolation levels and shows how they minimize blocking. Finally, another guest author -- Roger Wolter -- is singularly well qualified to write this book’s Service Broker coverage. He’s the Microsoft program manager who helped create it. Bill Camarda, from the June 2006 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9780735621978
  • Publisher: Microsoft Press
  • Publication date: 5/24/2006
  • Series: PRO-Developer
  • Edition description: REV
  • Pages: 536
  • Product dimensions: 7.36 (w) x 8.96 (h) x 1.34 (d)

Meet the Author

Dejan Sarka is MCT and MCDBA certified and a Microsoft MVP for SQL Server. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

Read More Show Less

Table of Contents

Foreword

Preface

Acknowledgments

Introduction

Chapter 1: Datatype-Related Problems, XML, and CLR UDTs

Chapter 2: Temporary Tables and Table Variables

Chapter 3: Cursors

Chapter 4: Dynamic SQL

Chapter 5: Views

Chapter 6: User-Defined Functions

Chapter 7: Stored Procedures

Chapter 8: Triggers

Chapter 9: Transactions

Chapter 10: Exception Handling

Chapter 11: Service Broker

Appendix A: Companion to CLR Routines

Appendix : About the Contributors

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 4 Customer Reviews
  • Posted November 30, 2009

    more from this reviewer

    T-SQL

    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  No   Report this review
  • Anonymous

    Posted October 21, 2006

    Top notch

    A must have for everyone who is serious about SQL Server 2005

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    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  No   Report this review
  • Anonymous

    Posted November 9, 2008

    No text was provided for this review.

Sort by: Showing all of 4 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)