
T-SQL Querying - Developer Reference (Paperback)
Itzik Ben-Gan (author), Adam Machanic (author), Dejan Sarka (author), Kevin Farlee (author)
£44.49
Paperback
864 Pages
Published: 19/03/2015
Published: 19/03/2015
T-SQL insiders help you tackle your toughest queries and query-tuning problems
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 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.
Write faster, more efficient T-SQL code:
Move from procedural programming to the language of sets and logicMaster an efficient top-down tuning methodologyAssess algorithmic complexity to predict performanceCompare data aggregation techniques, including new grouping setsEfficiently perform data-analysis calculationsMake the most of T-SQL's optimized bulk import toolsAvoid date/time pitfalls that lead to buggy, poorly performing codeCreate optimized BI statistical queries without additional softwareUse programmable objects to accelerate queriesUnlock major performance improvements with In-Memory OLTPMaster useful and elegant approaches to manipulating graphs
About This Book
For experienced T-SQL practitionersIncludes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL ProgrammingValuable to developers, DBAs, BI professionals, and data scientistsCovers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics
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 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.
Write faster, more efficient T-SQL code:
Move from procedural programming to the language of sets and logicMaster an efficient top-down tuning methodologyAssess algorithmic complexity to predict performanceCompare data aggregation techniques, including new grouping setsEfficiently perform data-analysis calculationsMake the most of T-SQL's optimized bulk import toolsAvoid date/time pitfalls that lead to buggy, poorly performing codeCreate optimized BI statistical queries without additional softwareUse programmable objects to accelerate queriesUnlock major performance improvements with In-Memory OLTPMaster useful and elegant approaches to manipulating graphs
About This Book
For experienced T-SQL practitionersIncludes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL ProgrammingValuable to developers, DBAs, BI professionals, and data scientistsCovers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics
Publisher: Microsoft Press,U.S.
ISBN: 9780735685048
Number of pages: 864
Weight: 1394 g
Dimensions: 229 x 189 x 43 mm
You may also be interested in...
Please sign in to write a review
Sign In / Register
Not registered? CREATE AN ACCOUNTCREATE A plus ACCOUNT
Sign In
Download the Waterstones App
Would you like to proceed to the App store to download the Waterstones App?
Click & Collect
Reserve online, pay on collection
Thank you for your reservation
Your order is now being processed and we have sent a confirmation email to you at
When will my order be ready to collect?
Following the initial email, you will be contacted by the shop to confirm that your item is available for collection.
Call us on or send us an email at
Unfortunately there has been a problem with your order
Please try again or alternatively you can contact your chosen shop on or send us an email at