T-SQL Querying

T-SQL Querying - Itzik Ben-gan

T-SQL Querying


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
Citeste mai mult

transport gratuit

302.53Lei

Sau 30253 de puncte

!

Fiecare comanda noua reprezinta o investitie pentru viitoarele tale comenzi. Orice comanda plasata de pe un cont de utilizator primeste in schimb un numar de puncte de fidelitate, In conformitate cu regulile de conversiune stabilite. Punctele acumulate sunt incarcate automat in contul tau si pot fi folosite ulterior, pentru plata urmatoarelor comenzi.

Livrare in 3-5 saptamani

Descrierea produsului


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
Citeste mai mult

Detaliile produsului

De acelasi autor

De pe acelasi raft

Parerea ta e inspiratie pentru comunitatea Libris!

Noi suntem despre carti, si la fel este si

Newsletter-ul nostru.

Aboneaza-te la vestile literare si primesti un cupon de -10% pentru viitoarea ta comanda!

*Reducerea aplicata prin cupon nu se cumuleaza, ci se aplica reducerea cea mai mare.

Ma abonez image one
Ma abonez image one