{"product_id":"9780133986624","title":"T-SQL Querying","description":"Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimising response time and resource usage. Emphasising a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012. \u003cbr\u003e \u003cbr\u003e Write faster, more efficient T-SQL code: \u003cul\u003e  \u003cli\u003eMove from procedural programming to the language of sets and logic \u003c\/li\u003e  \u003cli\u003eMaster an efficient top-down tuning methodology \u003c\/li\u003e  \u003cli\u003eAssess algorithmic complexity to predict performance \u003c\/li\u003e  \u003cli\u003eCompare data aggregation techniques, including new grouping sets \u003c\/li\u003e  \u003cli\u003eEfficiently perform data-analysis calculations \u003c\/li\u003e  \u003cli\u003eMake the most of T-SQL’s optimised bulk import tools \u003c\/li\u003e  \u003cli\u003eAvoid date\/time pitfalls that lead to buggy, poorly performing code \u003c\/li\u003e  \u003cli\u003eCreate optimised BI statistical queries without additional software \u003c\/li\u003e  \u003cli\u003eUse programmable objects to accelerate queries \u003c\/li\u003e  \u003cli\u003eUnlock major performance improvements with In-Memory OLTP \u003c\/li\u003e  \u003cli\u003eMaster useful and elegant approaches to manipulating graphs \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eThe full text downloaded to your computer\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eWith eBooks you can:\u003c\/p\u003e \u003cul\u003e  \u003cli\u003esearch for key concepts, words and phrases \u003c\/li\u003e  \u003cli\u003emake highlights and notes as you study \u003c\/li\u003e  \u003cli\u003eshare your notes with friends \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eeBooks \u003c\/strong\u003eare downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps. \u003c\/p\u003e \u003cp\u003eUpon purchase, you will receive via email the code and instructions on how to access this product.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003e\u003cu\u003eTime limit\u003c\/u\u003e\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eThe \u003cstrong\u003eeBooks\u003c\/strong\u003e products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.\u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":46527103238385,"sku":"9780133986624","price":57.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0674\/5433\/7265\/files\/9780133986624_p0.jpg?v=1765842791","url":"https:\/\/shop.barnesandnoble.com\/products\/9780133986624","provider":"Barnes \u0026 Noble","version":"1.0","type":"link"}