{"product_id":"t-sql-querying-itzik-ben-gan-9780735685048","title":"T-SQL Querying","description":"\u003cb\u003eT-SQL insiders help you tackle your toughest queries and query-tuning problems\u003c\/b\u003e \u003cbr\u003eSqueeze 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 optimizing response time and resource usage. Emphasizing 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. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eWrite faster, more efficient T-SQL code: \u003c\/b\u003e \u003cbr\u003e \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 optimized bulk import tools\u003c\/li\u003e \u003cli\u003eAvoid date\/time pitfalls that lead to buggy, poorly performing code\u003c\/li\u003e \u003cli\u003eCreate optimized 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 \u003cbr\u003e \u003cb\u003eAbout This Book\u003c\/b\u003e \u003cbr\u003e \u003cul\u003e \u003cli\u003eFor experienced T-SQL practitioners\u003c\/li\u003e \u003cli\u003eIncludes coverage updated from\u003cb\u003e\u003ci\u003e Inside Microsoft SQL Server 2008 T-SQL Querying\u003c\/i\u003e\u003c\/b\u003e and \u003cb\u003e\u003ci\u003eInside Microsoft SQL Server 2008 T-SQL Programming\u003c\/i\u003e\u003c\/b\u003e\n\u003c\/li\u003e \u003cli\u003eValuable to developers, DBAs, BI professionals, and data scientists\u003c\/li\u003e \u003cli\u003eCovers many MCSE 70-464 and MCSA\/MCSE 70-461 exam topics\u003c\/li\u003e \u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Itzik Ben-Gan, Adam Machanic, Dejan Sarka\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 0735685045\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9780735685048\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Microsoft Press\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 03\/16\/2015\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 864\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 3.00lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 7.30w x 1.60d","brand":"Itzik Ben-Gan","offers":[{"title":"Paperback","offer_id":44201711567103,"sku":"9780735685048","price":59.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_44b7cab4-3fbf-4fd4-b438-f8ab49b73c50.jpg?v=1691490958","url":"https:\/\/www.whiterainbookhouse.com\/products\/t-sql-querying-itzik-ben-gan-9780735685048","provider":"WR Book House","version":"1.0","type":"link"}