{"product_id":"microsoft-transact-sql-the-definitive-guide-the-definitive-guide-paperback-softback-9780763784164","title":"Microsoft Transact-SQL: the Definitive Guide; The Definitive Guide (Paperback \/ softback) 9780763784164","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eMicrosoft Transact-SQL: the Definitive Guide\u003c\/font\u003e\u003cbr\u003e\r\n\u003cfont size=\"5\"\u003eThe Definitive Guide\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\u003cp\u003e\u003cfont size=\"4\"\u003eJeffrey Garbus (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9780763784164\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 4 June 2010\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e516 pages\u003cbr\u003e24.4 x 19.2 x 2.9 cm, 0.85 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003eAccording 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.\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/font\u003e","brand":"Jones \u0026#38; Bartlett Learning","offers":[{"title":"Brand New","offer_id":52531018629400,"sku":"9780763784164","price":37.99,"currency_code":"GBP","in_stock":true}],"url":"https:\/\/freshlyprintedbooks.co.uk\/products\/microsoft-transact-sql-the-definitive-guide-the-definitive-guide-paperback-softback-9780763784164","provider":"Freshly Printed Books","version":"1.0","type":"link"}