Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while hot data stays on premises. Microsoft has since discontinued it.
SQL SERVER – How Much Free Space I Have in My Database?
Free Space inside data files differs from unused space on the Windows volume. I check both when planning growth.
Sort Query Using Dynamic Variables Without EXEC – Interview Question of the Week #074
How do you sort query results by a column passed in a variable? Here is how to sort query output dynamically without EXEC or sp_executesql.
SQL SERVER – Puzzle – Solve Splitting Strings Puzzle
A Splitting Strings puzzle: take a column holding delimited values, split them and return how many values each row has. How would you solve it?
What is NOT NULL Constraint? – Interview Question of the Week #073
A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.
SQL Server – InMemory OLTP Hash Collisions Performance Overhead
A customer’s InMemory OLTP tables ran slowly because of a very low hash bucket count. Here is the hash collisions performance overhead and how to avoid it.





