Tag Archives: T-SQL

Identity Gaps–#SQLNewBlogger

Posted on December 26, 2018 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Many people think that that an identity property will ensure a consistent, increasing numerical value. I ran across this … Continue reading →

Posted in Blog | Tagged , , | 6 Comments

2018 Advent of Code–Day 1

Posted on December 24, 2018 by way0utwest

I enjoy when the Avent of Code comes around each year. I seem to make this a December (or sometimes New Year’s) resolution to get through them all, but life usually gets in the way. In any case, I decided … Continue reading →

Posted in Blog | Tagged , , | Comments Off on 2018 Advent of Code–Day 1

Restarting a Sequence–#SQLNewBlogger

Posted on December 20, 2018 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. As part of my experiments with the sequence object, I wanted to see what allows me to restart a … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Restarting a Sequence–#SQLNewBlogger

The Default Frame for Window Functions

Posted on December 13, 2018 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This bites me constantly, and I was reminded of this while watching Kathi talk at #SQLintheCity. When you write … Continue reading →

Posted in Blog | Tagged , , | 1 Comment