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
Blogroll
- Chris Webb (331)
- Data Chant (213)
- Excelerator BI (190)
- In2BI (21)
- Power BI (879)
- powerbi (1)
- PowerPivotPro (174)
- SQL Chick (55)
- SQL Girl (50)
Recent Posts
- Monitoring Power Query Online Memory And CPU Usage
- Preview data is now available in the dataset details page
- Cancelling Power BI Dataset Refreshes With The Enhanced Refresh API
- Top 10 Reasons to Use Power Apps
- Power BI June 2022 Feature Summary
- Updates to full report attachments for email subscriptions in Premium Gen2
- How The “Maximum Connections Per Data Source” Property On Power BI DirectQuery Datasets Can Affect Report Performance
- May Release of SQL Server Reporting Services 2022
- Build Web Sites And Embed Power BI Reports In Them Using Power Pages
- Enhanced refresh with the Power BI REST API is now generally available