/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

 sqlserverfast.com
Plansplaining part 28 - The curious case of the missing FIRST_VALUE function - SQLServerFast
| | barneylawrence.com
T-SQL Tuesday #168 - FIRST_VALUE, LAST_VALUE and NULL Handling - Barney Lawrence - A Blog
2.4 parsecs away

Travel
| | FIRST_VALUE and LAST_VALUE had limited uses when they were first released to the world back in 2012, but with the introduced of the ability to ignore nulls in SQL Server 2022 they become a lot more useful. Let's take a look at some examples of why.
| | curatedsql.com
Explaining FIRST_VALUE() and LAST_VALUE() Execution Plans - Curated SQL
1.2 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.
| | www.nigeldba.com
T-SQL Tuesday #158 -Implementing Worst Practices - nigelDBA
2.5 parsecs away

Travel
| | T-SQL Tuesdayis the blog party started by Adam Machanic (b|t) over a decade ago and is now maintained by Steve Jones (b|t) on tsqltuesday.com. Each month, lots of people blog their thoughts on a common topic. This month's T-SQL Tuesday is from Raul Gonzalez (b|t) who is asking us to reveal all about our use of Worst Practices, and explain...
| | www.lucasnotes.com
T-SQL Tuesday #171 - Describe the Most Recent Issue You Closed | Lucas Notes
25.2 parsecs away

Travel
| SQL Server DBA notes about databases, programming, system administration, and troubleshooting.