{"product_id":"t-sql-querying-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\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eItzik Ben-Gan\u003c\/b\u003e is a mentor for and co-founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik has authored several T-SQL books as well as articles for \u003ci\u003eSQL Server Pro\u003c\/i\u003e, \u003ci\u003eSolidQ Journal\u003c\/i\u003e, and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQL Server Connections, SolidQ events, and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for its T-SQL-related activities. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eDejan Sarka\u003c\/b\u003e, MCT and SQL Server MVP, is an independent consultant, trainer, and developer focusing on database and business intelligence applications. His specialties are advanced topics like data modeling, data mining, and data quality. On these tough topics, he works and researches together with SolidQ and the Data Quality Institute. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of 11 books about databases and SQL Server, with more to come. He also has developed and is continuing to develop many courses and seminars for SolidQ and Microsoft. He has been a regular speaker at many conferences worldwide for more than 15 years, including Microsoft TechEd, PASS Summit, and others. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAdam Machanic\u003c\/b\u003e is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has contributed to several books on SQL Server, including \u003ci\u003eT-SQL Querying\u003c\/i\u003e (Microsoft Press, 2015) and \u003ci\u003eSQL Server 2008 Internals\u003c\/i\u003e (Microsoft Press, 2009). He regularly speaks at international conferences and training events on a variety of SQL Server topics. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eKevin Farlee\u003c\/b\u003e has over 25 years in the industry, in both database and storage-management software. In his current role as a Storage Engine Program Manager on the Microsoft SQL Server team, he brings these threads together. His current projects include the SQL Server Project \"Hekaton\" In-Memory OLTP feature. \u003cp\u003e\u003c\/p\u003e\u003cbr\u003e","brand":"Microsoft Press","offers":[{"title":"Default Title","offer_id":50514343690514,"sku":"9780735685048","price":55.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_2afb49c7-2407-4858-b19e-dc483ebfc8e3.jpg?v=1730980251","url":"https:\/\/surprise-castle.myshopify.com\/products\/t-sql-querying-9780735685048","provider":"Surprise Castle","version":"1.0","type":"link"}