Microsoft Transact-SQL: The Definitive Guide - Brossura

Garbus, Jeffrey; Ratchev, Plamen; Chang, Alvin; Celko, Joe

 
9780763784164: Microsoft Transact-SQL: The Definitive Guide
Brossura
ISBN 10: 0763784168 ISBN 13: 9780763784164
Casa editrice: Jones & Bartlett Learning, 2010

Sinossi

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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull?autore

Jeffrey Garbus is a leading database consultant and the CEO of Soaring Eagle Consulting, Ltd. He has over 20 years of experience consulting, tuning, and training on the Microsoft SQL Server. A frequent conference speaker, Mr. Garbus has written a dozen books and countless magazine articles on SQL, SQL Server and Sybase® He is also the host of the Accelerated SQL Performance Series, a webinar series designed to improve SQL performance.
Palamen Ratchev is the founder of Tangra, a firm specializing in relational database applications analysis, imokelementation and tuning Mr. Ratchev has a master's degree in Computer Science and holds numerous Microsoft certifications including Most Valuable Professional (MVP) for SQL Server.
Alvin Chang is a database systems consultant, technical trainer, and author of several books and training materials on SQL Server. He has been working with SQL Server for over 10 years.
Joe Celko served for 10 years on the ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards He is the author of over 800 columns and eight books on SQL.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Editore
Jones & Bartlett Learning
Data di pubblicazione
2010
Lingua
Inglese
ISBN 10 
0763784168
ISBN 13 
9780763784164
Rilegatura
Copertina flessibile
Numero edizione
1
Numero di pagine
521
Contatto del produttore
non disponibile
Persona responsabile
non disponibile

Altre edizioni note dello stesso titolo

9781556223730: Microsoft Transact-SQL: The Definitive Guide

Edizione in evidenza

ISBN 10:  1556223730 ISBN 13:  9781556223730
Casa editrice: Wordware Publishing Inc., 2005
Brossura