What problem does it solve? Updating or deleting millions of rows in a single MSSQL statement causes lock escalation, transaction log bloat, and long blocking operations. This Skill generates safe, resumable batched T-SQL scripts with progress tracking and checkpointing for large-scale data operations. ## Core Features & Use Cases - Three Operating Modes: Bulk insert into a tracking table, batched UPDATE, and batched DELETE, all driven by a BulkProcessTracking schema with IsProcessed flags for resumability. - Production Safety Controls: Batch sizes capped at 4,500 rows, ROWLOCK/UPDLOCK hints, WAITFOR DELAY throttling, and conditional CHECKPOINT for SIMPLE recovery models. - Progress Reporting & Recovery: Real-time RAISERROR progress messages, keyset cursor pagination safe at BIGINT maxima, and transaction-scoped claim logic so interrupted runs resume cleanly. - Use Case: You need to set IsVerified = 1 on 3 million customer rows where SignupDate < '2025-01-01'. The Skill outputs a setup script, a tracking-table insert script, a batched update script, and a commented cleanup script. ## Quick Start Ask the AI to update 3 million records in dbo.Customer setting IsVerified = 1 where SignupDate is before 2025-01-01 using batched T-SQL scripts.
