/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 curatedsql.com
Explaining FIRST_VALUE() and LAST_VALUE() Execution Plans - Curated SQL
| | www.kevinrchant.com
T-SQL Tuesday 171 - Using SemPy to view DAX in Microsoft Fabric - Kevin Chant
2.1 parsecs away

Travel
| | For this months T-SQL Tuesday contribution I want to cover how I ended up using SemPy to view DAX in Microsoft Fabric.
| | sqlserverfast.com
Plansplaining part 28 - The curious case of the missing FIRST_VALUE function - SQLServerFast
1.2 parsecs away

Travel
| | In part twenty-eight of the plansplaining series, I'll wrap up the six-part mini-series on window functions. After covering the basics, fast-track optimization, window frames ending at UNBOUNDED FOLLOWING, window frames specified with RANGE instead of ROWS, and LAG and LEAD, we will look at the LAST_VALUE and FIRST_VALUE analytical functions, and find that a function...
| | littlekendra.com
Register for Upcoming Free Webcasts on Indexes, Stats Maintenance, Query Tuning, and More
2.1 parsecs away

Travel
| | Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.
| | curatedsql.com
Connecting to Power BI PPU via SQL Server Profiler - Curated SQL
14.1 parsecs away

Travel
| [AI summary] A blog post discusses troubleshooting an error when connecting SQL Profiler to a SQL Server Premium Per User (PPU) dataset, providing a solution for the 'race with the ID' error.