Artículos relacionados a T-SQL Querying (Developer Reference)
Sinopsis
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
"Sinopsis" puede pertenecer a otra edición de este libro.
Acerca del autor
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.
"Sobre este título" puede pertenecer a otra edición de este libro.
Comprar nuevo
Ver este artículo
EUR 43,02
EUR 19,49 gastos de envío desde Alemania a España
Destinos, gastos y plazos de envío
Resultados de la búsqueda para T-SQL Querying (Developer Reference)
Imagen de archivo
T-SQL Querying (Developer Reference)
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
Paperback
Librería: WorldofBooks, Goring-By-Sea, WS, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Nº de ref. del artículo: GOR009804158
Cantidad disponible: 1 disponibles
Imagen del vendedor
T-SQL Querying (Developer Reference)
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
Tapa blanda
Librería: -OnTimeBooks-, Phoenix, AZ, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: good. A copy that has been read, remains in good condition. All pages are intact, and the cover is intact. The spine and cover show signs of wear. Pages can include notes and highlighting and show signs of wear, and the copy can include "From the library of" labels or previous owner inscriptions. 100% GUARANTEE! Shipped with delivery confirmation, if youâre not satisfied with purchase please return item for full refund. Ships via media mail. Nº de ref. del artículo: OTV.0735685045.G
Cantidad disponible: 1 disponibles
Imagen de archivo
T-SQL Querying (Developer Reference)
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
Tapa blanda
Librería: medimops, Berlin, Alemania
Calificación del vendedor: 5 de 5 estrellas
Condición: good. Befriedigend/Good: Durchschnittlich erhaltenes Buch bzw. Schutzumschlag mit Gebrauchsspuren, aber vollständigen Seiten. / Describes the average WORN book or dust jacket that has all the pages present. Nº de ref. del artículo: M00735685045-G
Cantidad disponible: 1 disponibles
Imagen de archivo
T-SQL Querying
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
Paperback
Librería: ThriftBooks-Dallas, Dallas, TX, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 3.23. Nº de ref. del artículo: G0735685045I3N00
Cantidad disponible: 1 disponibles
Imagen de archivo
T-SQL Querying (Developer Reference)
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
paperback
Librería: Stephen White Books, Bradford, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
paperback. Condición: Good. Ex-library book, usual marking. Clean copy in good condition. Quick dispatch from UK seller. Nº de ref. del artículo: mon0000549098
Cantidad disponible: 1 disponibles
Imagen de archivo
T-SQL Querying (Developer Reference)
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
Tapa blanda
Librería: Sharehousegoods, Colgate, WI, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: Good. This book has been examined carefully and the cover shows some wear. There may be some highlighting or writing inside, but the pages are mostly clean. Fast Shipping - Safe and Secure Mailer - Our goal is to deliver a better item than what you are hoping for! If not we will make it right! Nº de ref. del artículo: 1XGOUS001NZB
Cantidad disponible: 1 disponibles
Imagen de archivo
TSQL Querying Developer Refere
Librería: SecondSale, Montgomery, IL, Estados Unidos de America
Calificación del vendedor: 4 de 5 estrellas
Condición: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Nº de ref. del artículo: 00088996256
Cantidad disponible: 1 disponibles
Imagen de archivo
T-SQL Querying (Developer Reference)
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
paperback
Librería: SN Books Ltd, Thetford, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
paperback. Condición: Very Good. Orders shipped daily from the UK. Professional seller. Nº de ref. del artículo: mon0000485953
Cantidad disponible: 1 disponibles
Imagen del vendedor
T-SQL Querying
Publicado por
Microsoft Press, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Antiguo o usado
Tapa blanda
Librería: GreatBookPrices, Columbia, MD, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: As New. Unread book in perfect condition. Nº de ref. del artículo: 21639934
Cantidad disponible: 2 disponibles
Imagen del vendedor
T-SQL Querying
Librería: moluna, Greven, Alemania
Calificación del vendedor: 5 de 5 estrellas
Condición: New. This book gives students a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. Readers will tackle the toughest set-based querying and query tuning problems-guided by an author team with in-depth, inside knowled. Nº de ref. del artículo: 25043521
Cantidad disponible: Más de 20 disponibles