Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...
2020-10-20 (first published: 2020-10-13)
307 reads
Thank you all for your service!
I was fortunate to have attended PASS Summit again this year. As an added bonus...
2018-11-11
159 reads
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
192 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
265 reads
This month’s topic: Folks Who Have Made a Difference
T-SQL Tuesday is a monthly blog party for the SQL Server community...
2017-11-14
289 reads
This month’s topic: Let’s get all Posh – What are you going to automate today?
T-SQL Tuesday is a monthly blog party...
2017-09-11
286 reads
Today I learned that you can configure tempdb in RDS!
One of the things we DBA’s do is configure tempdb to...
2017-08-28
719 reads
Beware the automated backup window when running native SQL Server backups in RDS
If you’ve ever fired up an RDS instance...
2017-08-04
1,914 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-06-13
315 reads
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-05-25 (first published: 2017-05-09)
1,655 reads
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Comments posted to this topic are about the item The Cloud Security Problem
Comments posted to this topic are about the item Virtualizing AWS data by using...
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers