Does dropping a primary key also drop the Non-Clustered Index on that column? An interview question with a small repro script to see the answer.
Database Sharding – How to Identify a Shard Key?
Picking the shard key is the hardest part of Database Sharding. Here are the guiding principles I shared at a user group for choosing a good one.
How to Drop Clustered Index on Primary Key Column? – Interview Question of the Week #084
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.
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.
Does Dropping Primary Key Drop Clustered Index on the Same Column? – Interview Question of the Week #082
When you drop a primary key, does it drop the clustered index on the same column too? Yes, it does. Here is a small script that shows it.
Can We Have NULL Value in Primary Key? – Interview Question of the Week #075
Can we have a NULL value in primary key columns? No. The primary key has to uniquely identify each row, and NULL cannot do that. Here is why.