Tag Archives: T-SQL

T-SQL Tuesday #191 Round Up

Posted on October 28, 2025 by way0utwest

I hosted this month, late as it turns out, but we still had a few entries. Here’s a look at the blogs people published. First as always, Rob Farley writes about the complexity of string parsing, using TVFs. He also … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

T-SQL Tuesday #191: Invitation–Your Favorite String Parsing

Posted on October 12, 2025 by way0utwest

It’s that time of the month, and I’m late. My apologies. I had a mix-up with a host and was on vacation all last week, so no invite. I’m extending T-SQL Tuesday #191 a week to have people write on … Continue reading →

Posted in Blog | Tagged , , | 8 Comments

The Challenge of Implicit Transactions: #SQLNewBlogger

Posted on September 24, 2025 by way0utwest

I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another post for me that is simple and hopefully serves as an … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

Adding a Named Default Constraint to a Table: #SQLNewBlogger

Posted on August 11, 2025 by way0utwest

As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a constraint, however, I want to ensure this is named explicitly and … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Adding a Named Default Constraint to a Table: #SQLNewBlogger