{"product_id":"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. \u003cbr\u003e \u003cbr\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","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":46619145437425,"sku":"9780735685048","price":79.79,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0674\/5433\/7265\/files\/9780735685048_p0.jpg?v=1765183388","url":"https:\/\/shop.barnesandnoble.com\/products\/9780735685048","provider":"Barnes \u0026 Noble","version":"1.0","type":"link"}