Inside Microsoft SQL Server 2008 T-SQL Programming

Inside Microsoft SQL Server 2008 T-SQL Programming

Inside Microsoft SQL Server 2008 T-SQL Programming

Inside Microsoft SQL Server 2008 T-SQL Programming

eBook

$30.99  $40.79 Save 24% Current price is $30.99, Original price is $40.79. You Save 24%.

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now

Related collections and offers


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 this programming language—solving complex problems with real-world solutions.

Discover how to:

  • Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
  • Handle transactions, concurrency, and error handling.
  • Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
  • Evaluate when to use set-based programming techniques and when to use cursors.
  • Work with dynamic SQL in an efficient and secure manner.
  • Treat date- and time-related data in a robust manner.
  • Develop CLR user-defined types and learn about temporal support in the relational model.
  • Use XML and XQuery and implement a dynamic schema solution.
  • Work with spatial data using the new geometry and geography types and spatial indexes.
  • Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.
  • Use Service Broker for controlled asynchronous processing in database applications.

All the book’s code samples will be available for download from the companion Web site.


Product Details

ISBN-13: 9780735646476
Publisher: Pearson Education
Publication date: 09/23/2009
Series: Developer Reference
Sold by: Barnes & Noble
Format: eBook
Pages: 832
File size: 5 MB

About 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.

Table of Contents

  • Dedication
  • Foreword
  • Acknowledgments
  • Introduction
  • Chapter 1: Views
  • Chapter 2: User-Defined Functions
  • Chapter 3: Stored Procedures
  • Chapter 4: Triggers
  • Chapter 5: Transactions and Concurrency
  • Chapter 6: Error Handling
  • Chapter 7: Temporary Tables and Table Variables
  • Chapter 8: Cursors
  • Chapter 9: Dynamic SQL
  • Chapter 10: Working with Date and Time
  • Chapter 11: CLR User-Defined Types
  • Chapter 12: Temporal Support in the Relational Model
  • Chapter 13: XML and XQuery
  • Chapter 14: Spatial Data
  • Chapter 15: Tracking Access and Changes to Data
  • Chapter 16: Service Broker
  • Companion to CLR Routines
  • About the Authors
From the B&N Reads Blog

Customer Reviews