There was an error while loading. Please reload this page.
Add plain-English 'How URLs are shortened' page Non-technical explainer of the import-time URL cleaning that keeps SharePoint/Teams deep-link URLs within the urls.full_url (nvarchar(850)) column: strip the temporary xsdata token, else reduce to the page path, else truncate as a last resort. Adds a sidebar entry and cross-links with the technical 'URLs Full URL Shrink Upgrade' page. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
Update URLs Full URL Shrink Upgrade for nvarchar(850) (Greek/Unicode fix) Corrects the operator guide for the nvarchar(850) change (issue #122 / PR #123): column is now nvarchar(850) not varchar(1700); the lossy/representability pre-flight check is removed (only the >850 length abort remains); documents the new UrlFullUrlNvarchar migration and the two lossless upgrade-from states; fixes the operator probes and post-upgrade sanity SQL; notes nvarchar storage is ~2 bytes/char so headroom budget is larger; benchmark annotated as measured on the superseded varchar form.
Add 'URLs Full URL Shrink Upgrade' page with measured 10M-row baseline Companion guide for PR #108 (ShrinkUrlsFullUrlColumn migration), mirroring the structure of the existing 'Audit Events FK Upgrade' page. Headline measurement: ShrinkUrlsFullUrlColumn on 10M urls rows (avg 152 chars, SQL 2025 Standard Developer Edition, Azure VM with Standard HDD) ran end-to-end in 6 min 6 sec. Per-step: ~2.5s too-long scan, ~41s lossy-varchar scan, ~2m13s ALTER COLUMN, ~3m10s CREATE INDEX (offline). Storage: urls grows from 3.27 GB to 8.19 GB (URLs move from LOB to inline + new 1.68 GB index). Includes: - Per-step measured breakdown and 'how many rows do you have' diagnostics - Extrapolation tables for VM (1M to 500M rows on Standard HDD) and Azure SQL DB (S3-S7 DTU tiers) using the measured ~6 GB log-write per 10M rows scaling - Operator checklist (stop web jobs, data file headroom, log space, scale up) - 'If the migration aborts' section for too-long or lossy URLs - Post-upgrade sanity check, including dm_db_index_usage_stats query to confirm IX_urls_full_url is actually being used by importers Sidebar entry placed next to 'Audit Events FK upgrade' (both are upgrade-time guides). Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>