Twitter, John, Building a Blog and #MEME15
I saw an interesting post this morning care of the micro-blogging/social networking site twitter that really got me thinking about...
2012-01-15
1,459 reads
Blog Posts
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Data
One of the ways that I learn new things...
2012-01-14
1,703 reads
PASS: Time to Change the By-Laws
Yesterday Bill Graziano announced the appointment of two Directors (Kendal Van Dyke and James Rowland-Jones) to fill vacancies on the...
2012-01-14
935 reads
Using TDD To Create A Working Application In C# : Part 2
Last FM Wrapper
You know that web project we created? You can completely forget about that for now as this is...
2012-01-14
44 reads
Answer the Question Asked
“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get...
2012-01-13
831 reads
Ethics and Power
Power corrupts.
A famous quote, and it’s one of the the most true quotes I’ve seen in my life. When someone...
2012-01-13
1,280 reads
File Group Backups - Intro
What is File Group backup?
Backing up a portion of a database, say a File Group is termed as Filegroup...
2012-01-13
488 reads
Friday SQL Nugget #1
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like...
2012-01-13
1,433 reads
HP DL980…now this is a server!
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
945 reads
Moving Database Files and Replication
Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database...
2012-01-13
681 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
Find rows with very close time stamps
Given the following table and query, this will return any records(based on message_id) that...
How to merge two tables with unlike fields
How to merge two tables with unlike fields. I have two table with one...
Visual Studio 22 / SSIS Project / (Project) Connection problem
Hello, First of all, I find it odd/annoying that I can't exclude a Project...
Question of the Day
The LAGging NULL
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