Store hashtags in a tag and bridge table, normalize input, query any or all requested tags, and count weekly trends without scans.
SQL SERVER – Soft Delete – IsDelete Column – Your Opinion
Soft delete with an IsDelete column marks rows as deleted but keeps them. Michael J Swart dislikes it, and I agree. I share a similar story and ask your opinion.
Data, Log and tempdb File Placement: Checking Where Everything Lives
Check file placement for data, logs, and tempdb, inspect volume free space, and plan a Windows file move with a verified recovery path.
Keeping a Change Log for Every Database
A change log for every database records what changed, when, why, and by whom, with a simple table and a habit of updating it.
Return Codes: Keep Procedure Status Separate From Data
Return codes carry procedure status separately from application values. This private demonstration compares result sets, captured output and omitted OUTPUT. It also separates an optional no-work request from a genuine raised error.
Monitoring Log Growth and VLF Counts
Monitor VLF counts and transaction log growth with SQL Server DMVs, then choose file growth settings that keep recovery and maintenance predictable.
SQL SERVER – Getting Started with Execution Plans
Execution plans connect a query with the work SQL Server chooses. I start with a small question and inspect the relevant properties.