Someone changed the keyboard shortcuts in my SSMS 2012 at a conference. Here is how to reset keyboard shortcuts back to the default settings.
Splitting Work Into Equal-Sized Batches With NTILE
NTILE deals 100 customers into eight batches in one query. The catch is keeping those batches stable while new rows arrive.
How to Read a Stored Procedure You Did Not Write
Learn to read stored procedure code by tracing inputs, writes, transactions, errors, and dependencies before trying to understand every line.
Interview Questions That Actually Reveal SQL Skill
Use SQL Server interview questions that reveal reasoning about joins, NULLs, performance, and recovery instead of rewarding memorised trivia.
CODEPAGE 65001: Importing UTF-8 Text Files Without Garbled Accents
Your import turned Élodie into odd symbols. Here is how CODEPAGE 65001 fixes the reading, and why the column type still matters.
Temp Table Caching: Why Some Temp Tables Get Reused
Understand temp table caching in stored procedures, avoid cache blockers, inspect creation counters, and review retained statistics.
Why SQL Server Has No Result Cache: Buffer Pool and Plan Cache
A second run is faster, but SQL Server did not remember your answer. A tiny demo shows what really gets reused: pages and plans.