|
![]() |
|||
|
||||
OverviewFull Product DetailsAuthor: Kathi Kellenberger , Clayton Groom , Ed PollackPublisher: APress Imprint: APress Edition: 2nd ed. Weight: 0.454kg ISBN: 9781484251966ISBN 10: 1484251962 Pages: 213 Publication Date: 22 October 2019 Audience: Professional and scholarly , Professional & Vocational Format: Paperback Publisher's Status: Active Availability: Manufactured on demand ![]() We will order this item for you from a manufactured on demand supplier. Table of Contents1. Looking through the Window 2. Discovering Ranking Functions 3. Summarizing with Window Aggregates 4. Calculating Running and Moving Aggregates 5. Adding Frames to the Window 6. Taking a Peek at Another Row 7. Understanding Statistical Functions 8. Tuning for Better Performance 9. Hitting a Home Run with Gaps, Islands, and Streaks 10. Time Range Calculations 11. Time Trend CalculationsReviewsAuthor InformationKathi Kellenberger is a data platform MVP and the editor of Simple-Talk at Redgate Software. She has worked with SQL Server for over 20 years. She is also co-leader of the PASS Women in Technology Virtual Group and an instructor at LaunchCode. In her spare time, Kathi enjoys spending time with family and friends, singing, and cycling. Clayton Groom is a data warehouse and analytics consultant at Clayton Groom, LLC. He has worked with SQL Server for 25 years. His expertise lies in designing and building data warehouse and analytic solutions on the Microsoft technology stack, including Power BI, SQL Server, Analysis Services, Reporting Services and Excel. Edward Pollack has over 20 years of experience in database and systems administration and architecture, developing a passion for performance optimization and making things go faster. He has spoken at many SQL Saturdays, 24 Hours of PASS, and PASS Summits, and has coordinated SQL Saturday Albany since its inception in 2014. Tab Content 6Author Website:Countries AvailableAll regions |