Inside Microsoft® SQL Server® 2008: T-SQL Programming (Developer Reference)

4.36 avg rating
( 45 ratings by Goodreads )
 
9780735626027: Inside Microsoft® SQL Server® 2008: T-SQL Programming (Developer Reference)
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Ben-Gan, Itzik; Sarka, Dejan; Wolter, Roger; Low, Greg; Katibah, Ed; Kunen, Isaac
Published by Microsoft Press
ISBN 10: 0735626022 ISBN 13: 9780735626027
New PAPERBACK Quantity Available: 1
Seller:
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Microsoft Press. PAPERBACK. Condition: New. 0735626022 New Condition. Seller Inventory # NEW7.0283679

More Information About This Seller | Contact this Seller

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

2.

Itzik Ben-Gan, Dejan Sarka, Roger Wolter
Published by Microsoft Press (2009)
ISBN 10: 0735626022 ISBN 13: 9780735626027
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Microsoft Press, 2009. Paperback. Condition: New. Never used!. Seller Inventory # P110735626022

More Information About This Seller | Contact this Seller

Buy New
US$ 65.45
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

3.

Itzik Ben-Gan, Dejan Sarka, Roger Wolter
Published by Microsoft Press (2009)
ISBN 10: 0735626022 ISBN 13: 9780735626027
New Paperback Quantity Available: 2
Seller:
Save With Sam
(North Miami, FL, U.S.A.)
Rating
[?]

Book Description Microsoft Press, 2009. Paperback. Condition: New. Brand New!. Seller Inventory # VIB0735626022

More Information About This Seller | Contact this Seller

Buy New
US$ 65.45
Convert Currency

Add to Basket

Shipping: US$ 3.00
Within U.S.A.
Destination, Rates & Speeds

4.

Ben-gan, Itzik/ Sarka, Dejan/ Low, Greg/ Katibah, Ed/ Kunen, Isaac/ Wolter, Roger
Published by Microsoft Press,U.S. (2009)
ISBN 10: 0735626022 ISBN 13: 9780735626027
New Paperback Quantity Available: 1
Seller:
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Microsoft Press,U.S., 2009. Paperback. Condition: Brand New. 1st edition. 640 pages. 9.25x7.50x2.00 inches. In Stock. Seller Inventory # zk0735626022

More Information About This Seller | Contact this Seller

Buy New
US$ 119.93
Convert Currency

Add to Basket

Shipping: US$ 8.28
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, Isaac Kunen
Published by Microsoft Press (2009)
ISBN 10: 0735626022 ISBN 13: 9780735626027
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Microsoft Press, 2009. Paperback. Condition: New. 1. Seller Inventory # DADAX0735626022

More Information About This Seller | Contact this Seller

Buy New
US$ 775.13
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds