External profiles need a stable scoped identity key. Keep mutable email values separate and reject duplicate identities.
Checking Data Fits Before Narrowing a Column Data Type
Check existing values before narrowing a column, account for dependencies and data loss, and plan the locking cost of the change.
Whole Unit Allocation: Keep a Proportional Split Exact
Whole unit allocation keeps a fixed budget intact. I’d calculate base shares first, then distribute residual units using a stable tie rule. Check equal weights, a zero budget and zero-weight members.
PAGEIOLATCH_SH Waits: Slow Storage or Too Many Reads
Diagnose PAGEIOLATCH_SH waits by comparing file read latency with Query Store physical reads before blaming storage or changing indexes.
SQL SERVER – Import CSV File into Database Table Using SSIS
How to import CSV file into database table using SSIS, step by step with images, so you can automate the load instead of running Bulk Insert by hand.
hierarchyid Ordering: Paths Follow Depth-First Order
hierarchyid ordering follows the hierarchy value. Sorting rendered path text can arrange numeric-looking components differently, so keep presentation text separate from traversal order.
SQL Assessment API Findings: From Scan to Action
SQL Assessment API findings can guide a health review, provided the scan’s scope and evidence are clear. I separate collection problems from recommendations before deciding what to change. A short list is useful only when I know what was checked.