DROP INDEX fails with Msg 3723 on a primary key. Here is how to drop clustered index on a primary key column the right way, through the constraint.
SQL SERVER – Installation Fails With Error – A Constraint Violation Occurred
SQL Server cluster Installation Fails with ‘A constraint violation occurred’ as the network name won’t come online. I’ve fixed it for 10 clients.
SQL SERVER – Creating a Copy of Database in Azure SQL DB
A client wanted to tune a slow query on a copy, not on production. Here is how to create a copy of a database in Azure SQL DB and work on it safely.
Upsert Patterns in SQL Server Without Race Conditions
Compare upsert patterns under concurrent calls, protect missing-key ranges, test MERGE with HOLDLOCK, and keep unique keys as a guard.
Deleting Millions of Rows in Batches Without Filling the Log
Plan deleting millions of rows with bounded commits, an indexed cutoff, log reuse checks, and a clear choice of retention method.
Does Dropping Clustered Index Drop Primary Key on the Same Column? – Interview Question of the Week #083
Does dropping clustered index also drop the primary key on the same column? Here is the short answer, a follow-up to last week’s question on the reverse case.
SQL SERVER – Error: 14258 – Cannot perform this operation while SQLServerAgent is starting. Try again later
A client could not run any job and got Error 14258: Cannot perform this operation while SQLServerAgent is starting. Here is what caused it and how we fixed it.