Microsoft Transact-SQL: The Definitive Guide
Autor Jeffrey Garbus, Plamen Ratchev, Alvin Changen Limba Engleză Paperback – 30 apr 2010
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.
Topics Covered:
* 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
* Tactics for troubleshooting T-SQL queries
Preț: 270.53 lei
Preț vechi: 338.16 lei
-20% Nou
Puncte Express: 406
Preț estimativ în valută:
51.78€ • 53.85$ • 43.39£
51.78€ • 53.85$ • 43.39£
Carte tipărită la comandă
Livrare economică 13-27 martie
Preluare comenzi: 021 569.72.76
Specificații
ISBN-13: 9780763784164
ISBN-10: 0763784168
Pagini: 512
Dimensiuni: 188 x 229 x 30 mm
Greutate: 0.89 kg
Editura: Jones and Bartlett Publishers, Inc
ISBN-10: 0763784168
Pagini: 512
Dimensiuni: 188 x 229 x 30 mm
Greutate: 0.89 kg
Editura: Jones and Bartlett Publishers, Inc
V-ar putea interesa
-
On the Foundations of ComputingGiuseppe Primiero-27%Preț: 337.41 lei463.55 lei -
Algorithms Are Not EnoughHerbert L. Roitblat-20%Preț: 215.82 lei269.77 lei -
Blockchain Chicken FarmXiaowei WangPreț: 93.22 lei -
Possible Minds: Twenty-Five Ways of Looking at AIJohn Brockman-34%Preț: 75.23 lei113.68 lei -
-20%Preț: 448.83 lei561.05 lei -
The Zynq BookLouise H CrockettPreț: 277.95 lei -
Algorithms Illuminated (Part 2)Tim Roughgarden-20%Preț: 92.70 lei115.88 lei -
Database SystemsRamez Elmasri-20%Preț: 486.43 lei608.04 lei -
SQL Server AlwaysOn RevealedPeter Carter-20%Preț: 122.16 lei152.69 lei -
T-SQL FundamentalsItzik Ben-Gan-20%Preț: 232.12 lei290.16 lei -
Problem Solving with Algorithms and Data Structures Using PythonBradley N. MillerPreț: 369.03 lei -
tmux 2Brian P. Hogan-20%Preț: 93.09 lei116.36 lei -
The Revolutionary PhenotypeJean-François GariépyPreț: 117.92 lei -
AdventureJamie LendinoPreț: 122.60 lei -
Reporting with Microsoft SQL Server 2012James Serra-20%Preț: 206.51 lei258.14 lei -
Microsoft SQL Server 2012 with HadoopDebarchan Sarkar-20%Preț: 233.35 lei291.69 lei -
Building Interactive Queries with LinqpadSebastien FinotPreț: 315.45 lei -
-20%Preț: 384.78 lei480.98 lei -
The Alignment ProblemBrian Christian-40%Preț: 53.81 lei90.29 lei -
-20%Preț: 304.36 lei380.46 lei -
Preț: 446.59 lei -
Peeling Design PatternsNarasimha KarumanchiPreț: 301.86 lei -
FUZZY SETS,FUZZY LOGIC,& FUZZY SYS (V6)G J Klir Bo Yuan-20%Preț: 739.01 lei923.77 lei
Descriere
"Microsoft Transact-SQL" 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.
Notă biografică
Jeffrey Garbus is a database consultant and the CEO of Soaring Eagle Consulting, Ltd., based in Tampa, Florida. He has spoken at user conferences, and has written many magazine articles and books. He is also the lead author for Jeffrey Garbus' Official Sybase ASE 12.5 Library from Wordware Publishing, which includes Sybase ASE 12.5 Performance and Tuning and Sybase ASE 12.5 High Availability.