Lock (In)Compatability
If you want to go ‘nuts’ on locks and I mean not the SM-way .. learning this can also be painful as well… And here are the old red an new blue matrix, both have 22 columns, I think…
Nolock read as ‘No Loco’
In the StackOverflow2013 database all users with the DisplayName not equal to ‘alex’ are update with a long location. SQL Server has to fit the data on pages and shuffles data around. If we do not care about the exact…
Row versioning versus Locking Isolation Levels
/* Isolation Levels */ /*In SQL Server, isolation levels can be broadly categorized as locking, row versioning, and Read uncomitted. Locking Isolation Levels: Row Versioning Isolation Levels: Uncategorized: Locking Isolation Levels: The locking isolation levels work directly with data in…
Generating data the Itzik Ben Gan way..
Select Union All as a cartesion product. I normally create for example a set of 4mrd records and use the numeric values to add columns and generate data based on the value. I often use modulo (%) to narrow down…
AI in SQL Server 2025
And..
Performance tuning
Execution plans