Tag Archives: SQLNewBlogger

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

Sparse Columns Can Use More Space: #SQLNewBlogger

Posted on September 10, 2025 by way0utwest

I saw this as a question submitted at SQL Server Central, and wasn’t sure it was correct, but when I checked, I was surprised. If you choose to designate columns as sparse, but you have a lot of data, you … Continue reading →

Posted in Blog | Tagged , | 3 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

Better Trigger Design: #SQLNewBlogger

Posted on June 18, 2025 by way0utwest

I had someone ask me about using triggers to detect changes in their tables. This is the third post in the series. The first one Another post for me that is simple and hopefully serves as an example for people … Continue reading →

Posted in Blog | Tagged , , | 1 Comment