As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...
2024-05-20 (first published: 2024-05-02)
183 reads
Can we normalize a couple of things? 1 – Trade Schools. Back in the 80’s trade classes in high school and post high school were frowned upon, or looked...
2024-05-08
15 reads
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...
2023-12-18 (first published: 2023-12-01)
544 reads
What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like: Thanks...
2023-11-08 (first published: 2023-10-25)
203 reads
Please continue doing your backups! Backups are Disaster Recovery, yes…but not HA. Some will argue with this (in the comments most likely), but I broadly define “High Availability” as...
2023-11-01 (first published: 2023-10-17)
307 reads
Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...
2023-09-06
26 reads
Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...
2023-09-05
24 reads
Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...
2023-08-21 (first published: 2023-08-01)
168 reads
Pain Point: Something bad happened and you need to restore a SQL Server database. Pain Point you didn’t know you had: The backup files are all corrupt due a...
2023-07-25
277 reads
(for your reading pleasure, written by Jules. –ed) We have all had that sinking feeling of defeat: you’ve just finished explaining a very important and highly technical thing to...
2023-07-05 (first published: 2023-06-20)
401 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