Sinossi
Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions.
Discover how to:
- Understand logical and physical query processing
- Apply a methodology to optimize query tuning
- Solve relational division problems
- Use CTEs and ranking functions to simplify and optimize solutions
- Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors
- Use the TOP option in a query to modify data
- Query specialized data structures with recursive logic, materialized path, or nested sets solutions
- PLUS—Improve your logic and get to the heart of querying problems with logic puzzles
Get code and database samples on the Web
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Informazioni sugli autori
Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.
Itzik Ben-Gan is a mentor and cofounder of SolidQ. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the author of Microsoft SQL Server T-SQL Fundamentals and coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.
Lubor Kollar is group program manager with the SQL Server Customer Advisory Team at Microsoft, working on the most challenging SQL Server deployments worldwide. He has 13+ years of experience with SQL Server development.
Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Altre edizioni note dello stesso titolo
Risultati della ricerca per Inside Microsoft SQL Server 2005: T-sql Querying
Foto dell'editore
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
Da: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Codice articolo 00073492121
Compra usato
EUR 5,94
Spese di spedizione:
GRATIS
In U.S.A.
Quantità: 2 disponibili
Foto dell'editore
Inside Microsoft® SQL Server? 2005 : T-Sql Querying
Da: Better World Books, Mishawaka, IN, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Very Good. Used book that is in excellent condition. May show signs of wear or have minor defects. Codice articolo 3968962-6
Compra usato
EUR 6,33
Spese di spedizione:
GRATIS
In U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Inside Microsoft SQL Server 2005: T-SQL Querying
Da: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Codice articolo G0735623139I3N00
Compra usato
EUR 8,25
Spese di spedizione:
GRATIS
In U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Inside Microsoft SQL Server 2005: T-SQL Querying
Da: Half Price Books Inc., 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_446794042
Compra usato
EUR 7,19
Spese di spedizione:
EUR 3,01
In U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Inside Microsoft SQL Server 2005: Tâ"SQL Querying
Da: WorldofBooks, Goring-By-Sea, WS, Regno Unito
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: 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. Codice articolo GOR001378773
Compra usato
EUR 5,62
Spese di spedizione:
EUR 6,37
Da: Regno Unito a: U.S.A.
Quantità: 2 disponibili
Foto dell'editore
Inside Microsoftr SQL ServerT 2005: T-SQL Querying
Da: AwesomeBooks, Wallingford, Regno Unito
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Very Good. Inside Microsoftr SQL ServerT 2005: T-SQL Querying This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Codice articolo 7719-9780735623132
Compra usato
EUR 7,41
Spese di spedizione:
EUR 5,67
Da: Regno Unito a: U.S.A.
Quantità: 2 disponibili
Foto dell'editore
Inside MicrosoftAr SQL ServerTM 2005: T-SQL Querying (Solid Quality Learning)
Da: Bahamut Media, Reading, Regno Unito
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Codice articolo 6545-9780735623132
Compra usato
EUR 7,43
Spese di spedizione:
EUR 7,94
Da: Regno Unito a: U.S.A.
Quantità: 2 disponibili
Foto dell'editore
Inside Microsoft SQL Server 2005: T-SQL Querying
Da: BennettBooksLtd, San Diego, NV, U.S.A.
Valutazione del venditore 5 su 5 stelle
paperback. Condizione: New. In shrink wrap. Looks like an interesting title! Codice articolo Q-0735623139
Compra nuovo
EUR 68,49
Spese di spedizione:
EUR 5,99
In U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Inside Microsoft SQL Server 2005: T-sql Querying
Da: medimops, Berlin, Germania
Valutazione del venditore 5 su 5 stelle
Condizione: 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. Codice articolo M00735623139-G
Compra usato
EUR 5,82
Spese di spedizione:
EUR 105,00
Da: Germania a: U.S.A.
Quantità: 1 disponibili