Tag Archives: SQLNewBlogger

Identity Gaps–#SQLNewBlogger

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

Restarting a Sequence–#SQLNewBlogger

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 , ,

The Default Frame for Window Functions

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

Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. A good habit to get into is to explicitly name your constraints. I try to do this when I … Continue reading

Posted in Blog | Tagged , , | 1 Comment