Explore >> Select a destination
|
You are here 
|
barneylawrence.com | ||
| | | | |
nocolumnname.blog
|
|
| | | | | The Good, the Bad, and the Bug-ly. | |
| | | | |
sqlserverfast.com
|
|
| | | | | 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
|
|
| | | | | [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. | |
| | | | |
sqlkover.com
|
|
| | | It's #TSQL2sday time! This month's invitation has been sent out by Brent Ozar and he asks us to describe the most recent issue - or the last ticket - we closed. In my case, I actually blogged about it in this blog post: Azure Function App doesn't retrieve most recent secret value from Azure Key | ||
