Inside Microsoft SQL Server 2008: T-SQL Programming
- ISBN-10
- 0735626022
- ISBN-13
- 9780735626027
- Category
- Computers / Languages / SQL
- Pages
- 798
- Language
- English
- Published
- 2010
- Publisher
- Microsoft Press
- Author
- Itzik Ben-Gan
Description
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.
Get the book
Other editions
Similar books
-
Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying
By Dejan Sarka, Itzik Ben-Gan, Lubor KollarTackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL.
-
Microsoft SQL Server 2008 Management and Administration
By Ross Mistry, Hilary CotterIf you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for.
-
Inside Microsoft SQL Server 2008 T-SQL Programming: T-SQL Programming
By Greg Low, Dejan Sarka, Itzik Ben-GanGet a detailed look at the internal architecture of T-SQL with this comprehensive programming reference.
-
Microsoft SQL Server 2008 Step by Step
By Mike HotekTeach yourself SQL Server 2008—one step at a time.
-
T-SQL Querying
By Adam Machanic, Dejan Sarka, Itzik Ben-GanWrite faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation ...
-
Beginning Microsoft SQL Server 2008 Programming
By Robert VieiraWith this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.
-
Microsoft SQL Server 2005 Integration Services
By Kirk HaseldenThe interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.
-
Applied Microsoft SQL Server 2008 Reporting Services
By Teo LachevProvides information on the features and functions of Reporting Services to turn enterprise data into a variety of reports.
-
Microsoft SQL Server 2008 Administration with Windows PowerShell
By Ananthakumar Muthusamy, Yan PanThe definitive guide to automating SQL Server admnistration with Powershell scripts If you're a SQL Server database administrator, this book will make your life easier.
-
Programming Microsoft SQL Server 2008
By Andrew Brust, Leonard G. Lobel, Stephen ForteThis is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.