Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions



Bookstore > Books > Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

Price$26.72 - $39.91
Rating
AuthorItzik Ben-Gan
PublisherMicrosoft Press
Published2012
Pages244
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-100735658366
ISBN-139780735658363
EBook Hardcover Paperback

Optimize your queries - and obtain simple and elegant solutions to a variety of problems - using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you're a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.


  1. (4 books)



4 5 57

Similar Books


SQL Server 2012 Query Performance Tuning, 3rd Edition

SQL Server 2012 Query Performance Tuning, 3rd Edition

by Grant Fritchey

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 20...

Price:  $46.34  |  Publisher:  Apress  |  Release:  2012

What's New in SQL Server 2012

What's New in SQL Server 2012

by Rachel Clements, Jon Reade

Microsoft SQL Server has been part of the enterprise database landscape since SQL Server 7 arrived in 1998 and has evolved into the relational and BI platform of choice by businesses around the globe. The performance and full feature set of SQL Server has been widely recognized by the business community and it is viewed as a powerful weap...

Price:  $20.99  |  Publisher:  Packt Publishing  |  Release:  2012

Microsoft SQL Server 2012 with Hadoop

Microsoft SQL Server 2012 with Hadoop

by Debarchan Sarkar

With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indee...

Price:  $23.99  |  Publisher:  Packt Publishing  |  Release:  2013

SQL Server 2017 Query Performance Tuning

SQL Server 2017 Query Performance Tuning

by Grant Fritchey

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.This book covers ...

Price:  $44.98  |  Publisher:  Apress  |  Release:  2018

Microsoft SQL Server 2008 High Availability

Microsoft SQL Server 2008 High Availability

by Hemantgiri S. Goswami

Install various SQL Server High Availability options in a step-by-step manner. A guide to SQL Server High Availability for DBA aspirants, proficient developers and system administrators. Learn the pre and post installation concepts and common issues you come across while working on SQL Server High Availability. Tips to enhance performance...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2011

Microsoft SQL Server 2012 T-SQL Fundamentals

Microsoft SQL Server 2012 T-SQL Fundamentals

by Itzik Ben-Gan

Gain a solid understanding of T-SQL and write better queries.Master the fundamentals of Transact-SQL - and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you'll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in eac...

Price:  $4.83  |  Publisher:  Microsoft Press  |  Release:  2012

Introducing Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012

by Ross Mistry, Stacia Misner

Introducing Microsoft SQL Server 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, a...

Price:  $17.99  |  Publisher:  Microsoft Press  |  Release:  2012

Microsoft SQL Server 2012 Internals

Microsoft SQL Server 2012 Internals

by Kalen Delaney, Bob Beauchemin, Conor Cunningham, Jonathan Kehayias, Paul S. Randal, Benjamin Nevarez

Explore the core engine of Microsoft SQL Server 2012 - and put that practical knowledge to work. Led by a team of SQL Server experts, you'll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases - whether you...

Price:  $49.99  |  Publisher:  Microsoft Press  |  Release:  2013