Explore >> Select a destination
|
You are here 
|
barneylawrence.com | ||
| | | | |
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. | |
| | | | |
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... | |
| | | | |
nocolumnname.blog
|
|
| | | | | The Good, the Bad, and the Bug-ly. | |
| | | | |
tracyboggiano.com
|
|
| | | This month's T-SQL Tuesday is brought to us by Jason Brimhall. We are writing about times someone took chances with the databases that the DBAs felt were not worth it. I am going to talk about taking chances with your backups, our #1 job as DBAs is to have backups. Let's start with the scenario. | ||
