/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

 barneylawrence.com
T-SQL Tuesday #168 - FIRST_VALUE, LAST_VALUE and NULL Handling - Barney Lawrence - A Blog
| | sqlserverfast.com
Plansplaining part 28 - The curious case of the missing FIRST_VALUE function - SQLServerFast
2.5 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...
| | curatedsql.com
Explaining FIRST_VALUE() and LAST_VALUE() Execution Plans - Curated SQL
1.7 parsecs away

Travel
| | [AI summary] The article explains the execution plans for the FIRST_VALUE() and LAST_VALUE() analytical functions in SQL Server, discussing their behavior and how SQL Server handles their absence as internal aggregate functions.
| | nocolumnname.blog
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests - No Column Name
2.0 parsecs away

Travel
| | The Good, the Bad, and the Bug-ly.
| | bronowski.it
How to change Excel metadata using PowerShell? - Mikey Bronowski - Blog
13.5 parsecs away

Travel
| [AI summary] The blog posts highlight Microsoft Azure SQL Database updates, community tech events, and invitations to write about AI and IT ticketing on the TSQL2SDay blog.