It’s handy syntax. just a reminder for myself, as I don’t use sql often.
Transactions are usually when you have insert, update or delete statements with the “atomic” behaviour. However, in a highly concurrent application, it could happen that data you’ve… Read more “Use transactions for select statements”
Indexing columns is a joy and adventure. I have just indexed a datetime column to boost performance. The query had a date range, and the column didn’t… Read more “Indexing CreatedDate”