Synopsis
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 logic
- Master an efficient top-down tuning methodology
- Assess algorithmic complexity to predict performance
- Compare data aggregation techniques, including new grouping sets
- Efficiently perform data-analysis calculations
- Make the most of T-SQL’s optimized bulk import tools
- Avoid date/time pitfalls that lead to buggy, poorly performing code
- Create optimized BI statistical queries without additional software
- Use programmable objects to accelerate queries
- Unlock major performance improvements with In-Memory OLTP
- Master useful and elegant approaches to manipulating graphs
About This Book
- For experienced T-SQL practitioners
- Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming
- Valuable to developers, DBAs, BI professionals, and data scientists
- Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics
"synopsis" may belong to another edition of this title.
About the Author
Itzik Ben-Gan 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 SQL Server Pro, SolidQ Journal, 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.
Dejan Sarka, 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.
Adam Machanic 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 T-SQL Querying (Microsoft Press, 2015) and SQL Server 2008 Internals (Microsoft Press, 2009). He regularly speaks at international conferences and training events on a variety of SQL Server topics.
Kevin Farlee 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.
"About this title" may belong to another edition of this title.
Other Popular Editions of the Same Title
Search results for T-SQL Querying (Developer Reference)
Stock Image
T-SQL Querying (Developer Reference)
Seller: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_420908132
Stock Image
T-SQL Querying (Developer Reference)
Seller: Books From California, Simi Valley, CA, U.S.A.
Seller rating 4 out of 5 stars
Paperback. Condition: Very Good. Seller Inventory # mon0003944601
Stock Image
T-SQL Querying
Seller: Hamelyn, Madrid, M, Spain
Seller rating 4 out of 5 stars
Condition: Muy bueno. : Adéntrate en el mundo de T-SQL con esta referencia para desarrolladores. Cuatro expertos te guiarán a través de la arquitectura interna de T-SQL, ofreciendo técnicas avanzadas para optimizar el tiempo de respuesta y el uso de recursos. Aprenderás a escribir código T-SQL más rápido y eficiente, a dominar una metodología de ajuste de arriba a abajo y a evaluar la complejidad algorítmica para predecir el rendimiento. Este libro es ideal para profesionales de bases de datos y desarrolladores que buscan mejorar sus habilidades en T-SQL. EAN: 9780735685048 Tipo: Libros Categoría: Tecnología Título: T-SQL Querying Autor: Itzik Ben-Gan| Dejan Sarka| Adam Machanic| Kevin Farlee Editorial: Microsoft Press Idioma: en Páginas: 864 Formato: tapa blanda. Seller Inventory # Happ-2026-03-03-371af531
Buy Used
US$ 34.25
US$ 14.89 shipping
Ships from Spain to U.S.A.
Ships from Spain to U.S.A.
Quantity: 1 available
Seller Image
T-SQL Querying
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 21639934
Stock Image
T-SQL Querying (Developer Reference)
Seller: GoldBooks, Denver, CO, U.S.A.
Seller rating 5 out of 5 stars
Condition: new. Seller Inventory # 95M92_90_0735685045
Seller Image
T-SQL Querying
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 21639934-n
Seller Image
T-SQL Querying
Published by
Microsoft Press,U.S., US, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
New
Paperback
Seller: Rarewaves USA, OSWEGO, IL, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: New. 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. Seller Inventory # LU-9780735685048
Stock Image
T-SQL Querying (Developer Reference)
Seller: Ubiquity Trade, Miami, FL, U.S.A.
Seller rating 4 out of 5 stars
Condition: New. Brand new! Please provide a physical shipping address. Seller Inventory # 9780735685048
Seller Image
T-SQL Querying
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 21639934
Buy Used
US$ 75.23
US$ 19.82 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 2 available
Seller Image
T-SQL Querying
Published by
Microsoft Press,U.S., US, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
New
Paperback
Seller: Rarewaves.com USA, London, LONDO, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: New. 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. Seller Inventory # LU-9780735685048
Buy New
US$ 98.85
Free Shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available