Tag Archives: SQLNewBlogger

Adding Row Numbers to a Query: #SQLNewBlogger

Posted on October 9, 2024 by way0utwest

I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit. This post will start with the ROW_NUMBER() function as a gentle … Continue reading →

Posted in Blog | Tagged , , , | 5 Comments

Comparing an Old Running Total to Window Functions

Posted on September 30, 2024 by way0utwest

Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being introduced. After SQL Server 2012, we had better ways to write … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Moving One File Across Git Branches: #SQLNewBlogger

Posted on August 28, 2024 by way0utwest

I was working on some branching and merging with a customer and they wanted to move a file from one branch to another without taking the entire commit. I had to dig in a bit and see how to cherry … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Deleting Old Local Git Branches–#SQLNewBlogger

Posted on July 8, 2024 by way0utwest

I had a lot of local branches for a repo (actually a few repos). I know these are old and not used anymore, so how do I delete them? This post shows how to do that on Windows. Another post … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Deleting Old Local Git Branches–#SQLNewBlogger