Thanks for the Help with Deadlocks
It's time to start blogging again. And for my first post in a very long time, I mainly want to...
2015-05-08 (first published: 2015-05-02)
7,532 reads
It's time to start blogging again. And for my first post in a very long time, I mainly want to...
2015-05-08 (first published: 2015-05-02)
7,532 reads
SQLSaturday #250 Pittsburgh is in the books, and I'd like to sincerely thank the organizers, sponsors, volunteers, and speakers for...
2013-09-16
467 reads
SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you're anywhere in the...
2012-09-18
741 reads
Hey, did I mention that Pittsburgh is having a SQLSaturday this year?
Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...
2012-07-30
1,542 reads
Man it's tough to get in all that you want to do, isn't it? I've been trying to get my...
2012-07-21
697 reads
It's official, there's going to be a SQL Saturday in Pittsburgh this year!
The date is October 6th, and the...
2012-07-18
588 reads
I was running some tests on some purchased data this morning, and was getting a little perturbed because I was...
2011-06-16
596 reads
Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.
2010-01-26
5,981 reads
The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.
2010-01-18
14,272 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