Inside Microsoft® SQL ServerTM 2005 T-SQL Querying

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...

Descripción completa

Detalles Bibliográficos
Autor principal: Sarka, Dejan (-)
Otros Autores: Ben-Gan, Itzik, Kollar, Lubor
Formato: Libro electrónico
Idioma:Inglés
Publicado: Sebastopol : Microsoft Press 2009.
Edición:1st edition
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627326206719
Descripción
Sumario: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 processingApply a methodology to optimize query tuningSolve relational division problemsUse CTEs and ranking functions to simplify
Notas:Description based upon print version of record.
Descripción Física:1 online resource (0 p.)
Bibliografía:Includes bibliographical references and index.
ISBN:9780735635258