CURRENTLY SOLD OUT

Expert T-SQL Window Functions in SQL Server by Kathi Kellenberger, Clayton Groom (Paperback, 2015)

About this product

Product Information

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developments in SQL in a decade, and every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Begin using windowing functions like ROW_NUMBER and LAG, and you will discover more ways to use them every day. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, they will be easier to write, and they will be easier to deconstruct and maintain and enhance in the future. Just knowing and using these functions is not enough. You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server explains clearly how to get the best performance. The book also covers the rare cases when older techniques are the best bet. Stop using cursors and self-joins to solve complicated queries. Become a T-SQL expert by mastering windowing functions. Teaches you how to use all the window functions introduced in 2005 and 2012. Provides real-world examples that you can experiment with in your own database. Explains how to get the best performance when using windowing functions.

Product Identifiers

Publisher
Apress
ISBN-13
9781484211045
eBay Product ID (ePID)
212287427

Product Key Features

Author
Kathi Kellenberger, Clayton Groom
Publication Name
Expert T-Sql Window Functions in Sql Server
Format
Paperback
Language
English
Subject
Computer Science
Publication Year
2015
Type
Textbook
Number of Pages
152 Pages

Dimensions

Item Height
235mm
Item Width
155mm
Item Weight
2409g

Additional Product Features

Title_Author
Clayton Groom, Kathi Kellenberger
Country/Region of Manufacture
United States

Best Selling in Adult Learning & University

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Best Selling in Adult Learning & University

Australian Guidebook for Structural Engineers by Lonnie Pack (Paperback, 2019)
No ratings or reviews yet.
AU $84.19 New
---- Used
Eduqas GCSE (9-1) Religious Studies Route B: Catholic Christianity and Judaism by Deirdre Cleary, Andrew Barron, Joy White, Patrick Harrison (Paperback, 2017)
No ratings or reviews yet.
AU $100.97 New
---- Used
The Ethnic Cleansing of Palestine by Ilan Pappe (Paperback, 2007)
5.0 out of 5 stars based on 1 product rating
AU $30.02 New
---- Used

Save on Adult Learning & University

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Save on Adult Learning & University

The Australian Native Bee Hive Book: Keeping Stingless Sugarbag OATH Tim Heard
AU $31.98
Trending at AU $35.55
Weed Forager's Handbook: A Guide to Edible and Medicinal Weeds in Australia by A
AU $19.95
Trending at AU $20.64
Netter Atlas of Human Anatomy: Classic Regional Approach
AU $113.94
Trending at AU $122.07
The Indoctrinated Brain: How to Successfully Fend Off the Global Attack on Your
AU $49.95
Trending at AU $57.80
George Hrabovsky Leonard Susskind Classical Mechanics (Paperback)
AU $27.49
Trending at AU $31.57
Havard's Nursing Guide to Drugs
AU $74.99
Trending at AU $76.69

Shop by category

Expert T-SQL Window Functions in SQL Server by Kathi Kellenberger, Clayton Groom (Paperback, 2015)

About this product

Product Information

Product Identifiers

Product Key Features

Dimensions

Additional Product Features

Best Selling in Adult Learning & University

Australian Guidebook for Structural Engineers by Lonnie Pack (Paperback, 2019)

Eduqas GCSE (9-1) Religious Studies Route B: Catholic Christianity and Judaism by Deirdre Cleary, Andrew Barron, Joy White, Patrick Harrison (Paperback, 2017)

The Ethnic Cleansing of Palestine by Ilan Pappe (Paperback, 2007)

Save on Adult Learning & University

The Australian Native Bee Hive Book: Keeping Stingless Sugarbag OATH Tim Heard

Weed Forager's Handbook: A Guide to Edible and Medicinal Weeds in Australia by A

Netter Atlas of Human Anatomy: Classic Regional Approach

The Indoctrinated Brain: How to Successfully Fend Off the Global Attack on Your

George Hrabovsky Leonard Susskind Classical Mechanics (Paperback)

Havard's Nursing Guide to Drugs

You may also like

Kathy Reichs Fiction Paperback Fiction & Books

Non-Fiction Functionalism Paperback Fiction & Books

Non-Fiction Paperback Fiction & Grooming Books

Kathy Reichs Fiction Hardcover Books

Windows Non-Fiction Paperback Fiction & Books

Kathy Reichs Fiction & Fiction Books