Diagnose an index seek that reads far more rows than it returns by checking residual predicates, Actual Rows Read and index key order.
Readable File Sizes: Converting Bytes to KB, MB and GB
Turn raw bytes into friendly sizes without losing accuracy. Includes the overflow trap and the 500 GB drive that shows as 465.7.
Escaping Wildcards in LIKE: Searching for % and _ Literally
Handle escaping wildcards in SQL Server LIKE searches with brackets, ESCAPE, and a reusable function that preserves literal input.
Integer Division in T-SQL: Why Your Percentages Come Out Zero
Fix integer division in T-SQL percentages from COUNT, SUM and window calculations with decimal types and rounding at the right step.
Converting Deprecated TEXT, NTEXT and IMAGE Columns Safely
Inventory deprecated TEXT, NTEXT and IMAGE columns, convert to MAX types, move small values in row, and measure logging and space costs.
Keeping ACID Across More Than One Server
Understand a distributed transaction through two-phase commit, uncertain outcomes, coordinator recovery, and alternative business guarantees.
The Four Window Functions You Will Actually Use
Learn four practical window functions with SQL examples for numbering rows, ranking ties, comparing previous values, and calculating running totals.