How are @@DATEFIRST and SET DATEFIRST related? One sets the first day of the week for your session, the other reads it back, and language matters too.
SQL SERVER – Inserting into ColumnSet with SPARSE Columns
A friend had a table with 1000s of SPARSE columns and asked about inserting into ColumnSet directly. Yes, you can. Here is how it works.
SQL SERVER – InMemory Table Creation Error Message: Msg 41337
My cousin tried InMemory tables on SQL Server 2016 and hit Msg 41337 while creating one. Here is what the error means and how to get past it.
Context Switching Has a Cost: Batch Your Interruptions
Context switching costs more than the seconds it takes to change windows. This post compares attention with SQL Server commits: pay the fixed fee once per batch, not once per ping. It gives concrete ways to batch messages, tickets and reviews, and ends with a short checklist.
Why datetime Turns .999 Milliseconds Into the Next Day
See why 999 milliseconds rounds into tomorrow with datetime, compare datetime2 precision, and use an exclusive next-day report boundary.
max_length in sys.columns: Bytes, Not Characters
Your generated column came out twice as wide as the original. Here is why max_length counts bytes and how to turn it back into a real declaration.
MySQL – Get Latest Identity Value by Inserts
In MySQL, use the LAST_INSERT_ID() function to get the latest identity value after an insert, like @@IDENTITY or SCOPE_IDENTITY() in SQL Server.