Design soft delete with an IsDeleted flag, filtered unique keys and indexes, a live-row view, and a measured archive process.
Overlapping Chunks: Splitting Long Text With GENERATE_SERIES
Split long text into overlapping pieces with one short query. Plus the quiet traps: NULL text, a step that is too big, and chopped words.
Narrow Index Keys: Why the Clustered Key Width Matters Everywhere
Evaluate narrow index keys by comparing clustered GUID and integer designs, measuring index pages, and preserving natural uniqueness.
Table-Valued Parameters: Sending Thousands of Rows in One Call
Send thousands of rows in one call with table-valued parameters, compare round trips, and handle missing column statistics accurately.
Standard Developer vs Enterprise Developer Edition in SQL Server 2025
Choose Standard Developer or Enterprise Developer in SQL Server 2025, inspect the edition, and test against production features.
An Index Seek That Reads Millions of Rows: Residual Predicates
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.