Technical details
Mac compatibility |
N |
Number of pages |
798 pages |
Written by |
Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, Isaac Kunen |
Inside Microsoft SQL Server 2008: T-SQL Programming
Master the mechanics behind advanced T-SQL programming - and deliver more robust solutions
Get a detailed look inside the programming constructs and internals of Transact-SQL (T-SQL) - the database programming language built into SQL Server. Guided by T-SQL expert Itzik Ben-Gan and his colleagues inside the Microsoft SQL Server team and beyond - you'll gain practical approaches and advanced techniques to optimize your code's performance.
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference.
Database developers & 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 & 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 & secure manner;
- Treat date- and time related data in a robust manner;
- Develop CLR user defined types & learn about temporal support in the relational model;
- Use XML & XQuery and implement a dynamic schema solution;
- Work with spatial data using the new geometry & geography types and spatial indexes;
- Track access & 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.