Re-blog – January 6 – January 12
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-13
641 reads
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-13
641 reads
The raw ones from podcasts in late Nov and Dec 2011.
Dec 2011 Bloopers
Filed under: Blog Tagged: Humor, syndicated
2012-01-12
1,117 reads
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,643 reads
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...
2012-01-12
686 reads
Introduction
In past, many times I have written on Fragmentation of Indexes and how to Defrag them. You can find some...
2012-01-12
15,581 reads
SQL Server has means built into it to track possible missing indexes. This used to be found through the use of the Index Tuning Wizard. The process has improved...
2012-01-12
On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation...
2012-01-12
1,164 reads
In the SAN environment , the Logical Disk Performance objects counters monitor the logical partitions.
I use the Logical Disk Read Bytes/sec ...
2012-01-12
1,842 reads
When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting...
2012-01-12 (first published: 2012-01-05)
4,469 reads
There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up...
2012-01-11
1,731 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...
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...
Hi - I'm looking for advice regarding the best & quickest way to establish...
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