Articoli correlati a T-SQL Querying
Sinossi
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
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
L'autore
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.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
- EditoreMicrosoft Pr
- Data di pubblicazione2015
- ISBN 10 0735685045
- ISBN 13 9780735685048
- RilegaturaCopertina flessibile
- LinguaInglese
- Numero di pagine836
Compra nuovo
Visualizza questo articolo
EUR 65,22
EUR 2,38 per la spedizione in U.S.A.
Destinazione, tempi e costi
Risultati della ricerca per T-SQL Querying
Foto dell'editore
T-SQL Querying (Developer Reference)
Da: HPB-Red, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: 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! Codice articolo S_425198125
Quantità: 1 disponibili
Foto dell'editore
T-SQL Querying (Developer Reference)
Da: Sharehousegoods, Colgate, WI, U.S.A.
Valutazione del venditore 4 su 5 stelle
Condizione: 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! Codice articolo 1XGOUS001NZB
Quantità: 1 disponibili
Foto dell'editore
T-SQL Querying (Developer Reference)
Da: HPB-Emerald, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Codice articolo S_433596535
Quantità: 1 disponibili
Immagini fornite dal venditore
T-SQL Querying (Developer Reference)
Da: WeBuyBooks, Rossendale, LANCS, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: Like New. Most items will be dispatched the same or the next working day. An apparently unread copy in perfect condition. Dust cover is intact with no nicks or tears. Spine has no signs of creasing. Pages are clean and not marred by notes or folds of any kind. Codice articolo wbs3191174399
Quantità: 1 disponibili
Immagini fornite dal venditore
T-SQL Querying
Da: GreatBookPrices, Columbia, MD, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: As New. Unread book in perfect condition. Codice articolo 21639934
Quantità: 2 disponibili
Foto dell'editore
T-SQL Querying (Developer Reference)
Da: Brit Books, Milton Keynes, Regno Unito
Valutazione del venditore 4 su 5 stelle
Paperback. Condizione: Used; Very Good. ***Simply Brit*** Welcome to our online used book store, where affordability meets great quality. Dive into a world of captivating reads without breaking the bank. We take pride in offering a wide selection of used books, from classics to hidden gems, ensuring there is something for every literary palate. All orders are shipped within 24 hours and our lightning fast-delivery within 48 hours coupled with our prompt customer service ensures a smooth journey from ordering to delivery. Discover the joy of reading with us, your trusted source for affordable books that do not compromise on quality. Codice articolo 4217186
Quantità: 1 disponibili
Immagini fornite dal venditore
T-SQL Querying
Da: GreatBookPrices, Columbia, MD, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: New. Codice articolo 21639934-n
Quantità: 2 disponibili
Immagini fornite dal venditore
T-SQL Querying (Paperback)
Editore:
Microsoft Press,U.S., Redmond, 2015
ISBN 10: 0735685045
ISBN 13: 9780735685048
Nuovo
Paperback
Da: Grand Eagle Retail, Fairfield, OH, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: new. Paperback. Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQLs internal architecture and offer advanced practical techniques for optimising response time and resource usage. Emphasising 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-SQLs optimised bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimised 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 Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Codice articolo 9780735685048
Quantità: 1 disponibili
Foto dell'editore
T-SQL Querying
Da: Russell Books, Victoria, BC, Canada
Valutazione del venditore 5 su 5 stelle
Softcover. Condizione: New. Special order direct from the distributor. Codice articolo ING9780735685048
Quantità: Più di 20 disponibili
Immagini fornite dal venditore
T-SQL Querying
Da: GreatBookPricesUK, Woodford Green, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: As New. Unread book in perfect condition. Codice articolo 21639934
Quantità: 2 disponibili