SQL2012 Windowing Functions In The Data Warehouse–2. Reporting
This is the second post of a diptych on the magical windowing functions in data warehouse scenarios. With these functions you can greatly simplify the TSQL you write. Many complex queries with CTE’s, temp tables and sub queries can be rewritten to simpler, better...Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world
Top Posts & Pages
Blogroll
- Chris Webb (181)
- Data Chant (150)
- Excelerator BI (130)
- In2BI (21)
- Power BI (453)
- powerbi (1)
- PowerPivotPro (146)
- SQL Chick (55)
- SQL Girl (50)
Recent Posts
- Learn how Power BI can help with extracting data from a website
- Communities Wins Silver Stevie Award for Innovation
- Power BI Premium and Azure Analysis Services
- Testing Performance Of Power BI Reports In The Browser, Part 2
- Learn how to connect Azure DevOps API in a secure way
- Power BI Service and Mobile October and November 2019 feature summary
- Testing Performance Of Power BI Reports In The Browser, Part 1
- “Power BI is a Data Visualization Tool”
- On-premises data gateway November 2019 update is now available
- Learn How Power BI and Accessibility Work Together