{"product_id":"t-sql-querying-9780735685048","title":"T-SQL Querying","description":"\u003cp\u003e • Author(s): Itzik Ben-Gan\u003cbr\u003e • Publisher: Microsoft Press\u003cbr\u003e • Publisher Imprint: Microsoft Press\u003cbr\u003e • BISAC: Database Administration \u0026amp; Management\u003c\/p\u003e\u003cp\u003e\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. \u003c\/p\u003e\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","brand":"Microsoft Press","offers":[{"title":"Paperback","offer_id":45503667404951,"sku":"9780735685048","price":5141.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780735685048.webp?v=1767162733","url":"https:\/\/atlanticbooks.com\/products\/t-sql-querying-9780735685048","provider":"Atlantic Books","version":"1.0","type":"link"}