Microsoft Transact-SQL: the Definitive Guide: The Definitive Guide - Tapa blanda

Garbus, Jeffrey

 
9780763784164: Microsoft Transact-SQL: the Definitive Guide: The Definitive Guide
Tapa blanda
ISBN 10: 0763784168 ISBN 13: 9780763784164
Editorial: Jones and Bartlett Publishers, Inc, 2010

Sinopsis

According to industry studies, 7 -8 % 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 2 8 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.

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

CEO, Soaring Eagle Consulting, Ltd., Tampa, Florida

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
Jones and Bartlett Publishers, Inc
Año de publicación
2010
Idioma
Inglés
ISBN 10 
0763784168
ISBN 13 
9780763784164
Encuadernación
Tapa blanda
Número de edición
1
Número de páginas
516
Contacto del fabricante
no disponible
Persona responsable
no disponible

Otras ediciones populares con el mismo título

9781556223730: Microsoft Transact-SQL: The Definitive Guide

Edición Destacada

ISBN 10:  1556223730 ISBN 13:  9781556223730
Editorial: Wordware Publishing Inc., 2005
Tapa blanda