Microsoft Transact-SQL: The Definitive Guide : The Definitive Guide - Jeffrey Garbus

Microsoft Transact-SQL: The Definitive Guide

The Definitive Guide

By: Jeffrey Garbus

Paperback | 4 June 2010 | Edition Number 1

At a Glance

Paperback


RRP $94.95

$61.25

35%OFF

or 4 interest-free payments of $15.31 with

 or 
In Stock and Aims to ship in 1-2 business days

When will this arrive by?

According to industry studies, 70-80% of database performance problems are caused by poorly written transact-SQL code. Microsoft Transact-SQL: The Definitive Guide is a comprehensive guide to the T-SQL language written for the MS SQL Server 2008 developer having performance problems with SQL. The text includes case studies and examples demonstrating how to write or rewrite T-SQL source code. Some Topics covered include several ways of writing code for optimal performance and maintainability such as stored procedures versus dynamic SQL as well as subqueries versus joins; advanced SQL programming techniques including characteristic functions, common table expressions, refactoring, cubes, and dynamic queries; methods for identifying and fixing poorly written code including Profiler, DMVs, third-party tools, and reading query plans.

More in Database Software

Microsoft 365 Access For Dummies - Laurie A. Ulrich

RRP $49.95

$38.75

22%
OFF
Problem Solving Cases In Microsoft Access & Excel : 16th edition - Ellen Monk
Sharing Big Data Safely - Ted Dunning

RRP $47.50

$25.90

45%
OFF
Cloud Computing : 2nd Edition - Kris Jamsa

RRP $199.50

$124.50

38%
OFF
MySQL Pocket Reference 2e : Pocket Reference (O'Reilly) - George Reese
The Art of SQL : O'Reilly Ser. - Stephane Faroult

RRP $104.50

$51.75

50%
OFF
Access Data Analysis Cookbook : Cookbooks Ser. - Ken Bluttman

RRP $95.00

$47.75

50%
OFF
Access 2007 : The Missing Manual - Matthew MacDonald

RRP $66.50

$34.90

48%
OFF
Mastering Oracle SQL 2e : O'Reilly Ser. - Sanjay Mishra

RRP $95.00

$47.75

50%
OFF
Access Hacks : Hacks - Ken Bluttman

RRP $66.50

$34.90

48%
OFF
UNIX for Oracle DBAs Pocket Reference : Command Syntax and Scripts - Donald Burleson
Learning Oracle PL/SQL : Learning Ser. - Bill Pribyl

RRP $95.00

$47.75

50%
OFF
Oracle Data Dictionary Pocket Reference : Views, Columns & Tips - David C. Kreines
Web Database Applications with PHP and MySQL 2e : OREILLY - Hugh E Williams
Transact-SQL Cookbook : Cookbooks Ser. - Ales Spetic

RRP $76.00

$39.40

48%
OFF
Learning GraphQL : Declarative Data Fetching for Modern Web Apps - Alex Banks