Close
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Search
Microsoft Transact-SQL: The Definitive Guide

Microsoft Transact-SQL: The Definitive Guide (Paperback)

£41.99
Currently unavailable. Foyles can order for despatch to customer when the publisher is re-supplied on 30/09/2017.
Email me when back in stock

Synopsis

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 books by Jeffrey Garbus

Leave Review

Delivery

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.

Location 1st Book Each additional book Average Delivery Time
UK Second Class Available free for ALL orders. No charge for each additional book. 3-7 Days
UK First Class £4.50 £1.00 1-2 Days
UK Courier £7.00 £1.00 1-2 Days
Western Europe** Courier £17.00 £3.00 2-3 Days
Western Europe** Airmail £5.00 £1.50 4-14 Days
USA / Canada Courier £20.00 £3.00 2-4 Days
USA / Canada Airmail £7.00 £3.00 4-14 Days
Rest of World Courier £22.50 £3.00 3-6 Days
Rest of World Airmail £8.00 £3.00 7-21 Days

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

Delivery Help & FAQs

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

You might also like

Oracle of the Unicorns: A Realm of...
(Books & other media combined)
Cordelia F. Brabbs; Selina Fenech
 
£16.99
£15.99
6%
Oracle Database Upgrade and Migration...
(Paperback)
Y. V. RaviKumar; K. M. Krishna Kumar;...
 
 
£26.99
 
The Cloud DBA-Oracle: Managing Oracle...
(Paperback)
Abhinivesh Jain
 
 
£29.99
 
Oracle Database 12c Release 2...
(Paperback)
Anton Els; Franck Pachot
 
 
£45.99
 
Latest Blog
#FoylesFive: Elsewhere-Elsewhen
18/09/2017

Jen from the Web Team shares a selection of books that will transport the reader to another time and place.

Growler: The Inspiration for the Now Iconic Bear
18/09/2017

James Campbell describes how the groundbreaking approach to illustration adopted by Milne and Shepard came about, which bear provided the inspiration for the drawings and which of the characters was Shepard's secret favourite.

Blog - Sound and Silence: Emma Viskic on Creating a Profoundly Deaf Protagonist
14/09/2017

In this exclusive blog Emma Viskic describes how she came to learn sign language in order to get closer to her deaf protagonist in her debut, Resurrection Bay.

View all Blog Entries
Twitter
Show/Hide Tweets
© W&G Foyle Ltd