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.

Acerca del autor

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

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

Descripci�n de la librer�a

BooksRun helps to save money on textbooks. We are committed to providing each customer with the highest standard of customer service. Please pay close attention to the description of the book and its condition you are ordering. If you have any questions or issues, please make sure to contact us first so we could resolve them. All orders are shipped on the same or the next business day. It usually takes 1 to 5 business days to receive your item if you choose expedited shipping. All orders submitted are eligible for a return within 30 days after the delivery. Thanks for shopping with us!