TSQL

Your Twitter feed is probably already full of Wordle posts, so I thought, why not add one more? I’m starting the series with one goal - find the optimal way to play.

How can 15 be less than 13? Let’s have a look at this unexpected, but fully documented behaviour.

I’ve come up with an efficient way to monitor only specific data changes in a table.

I was investigating a mysterious Intent Shared lock in a deadlock report. Especially confusing, since the database was using an Optimistic Concurrency.

Sometimes the quickest help you can get is to help yourself. I’ve compiled a list of common problems when I’m helping out in the SQL community.

This month’s invitation is from John McCormack. I’m sharing few handy short snippets that I use on regular basis.

I’m using this trick to find potential problems with a new feature I’m considering.