Free SQL Performance Tool Worth Checking
First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur). This is...
2012-01-17
1,620 reads
First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur). This is...
2012-01-17
1,620 reads
Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself...
2012-01-17
812 reads
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
942 reads
SQL Server has means built into it to track possible missing indexes. This used to be found through the use...
2012-01-17 (first published: 2012-01-12)
3,769 reads
Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011...
2012-01-17
486 reads
Once again, I’m the moderator for a webinar coming up at the end of the month, on Jan 31, 2012....
2012-01-17
821 reads
I have been working with SQL Server for quite a few years now, and it still happens quite often that...
2012-01-17
6,136 reads
Should an average Jane or Joe professional use twitter?
Yes.
Why?
Because, I’m using it.
Not enough reasons? <grumpy face> I knew you wouldn’t...
2012-01-16
667 reads
I wrote a post recently on capacity planning, and then thought of one more thing. In addition to planning for...
2012-01-16
1,959 reads
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...
2012-01-16 (first published: 2012-01-11)
5,132 reads
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
Given the following table and query, this will return any records(based on message_id) that...
How to merge two tables with unlike fields. I have two table with one...
Hello, First of all, I find it odd/annoying that I can't exclude a Project...
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