Get Free Shipping on orders over $89
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.99

$61.75

35%OFF

or 4 interest-free payments of $15.44 with

 or 
In Stock and Ships next day
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 Computer Science

Empire of AI : Inside the reckless race for total domination - Karen Hao
How We Learn : The New Science of Education and the Brain - Stanislas Dehaene
We Are Not Machines : The Fight for the Future of Work - Sarah O'Connor
Microsoft 365 Excel All-in-One For Dummies : Excel for Dummies - David H. Ringstrom
Co-Intelligence : Living and Working with AI - Ethan Mollick

RRP $36.99

$29.75

20%
OFF
Artificial Intelligence in Detecting Autism - Ram Kumar Chenthur Pandian

RRP $263.00

$228.75

13%
OFF
Artificial Intelligence : A Modern Approach, 4th Global Edition - Peter Norvig