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.
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.
How to Find Outdated Statistics? – Interview Question of the Week #081
How do you find outdated statistics? The honest answer is that ‘outdated’ is subjective. I explain why, and how I look at statistics instead.
How to Change Fill Factor in SQL Server – Interview Question of the Week #080
It is surprising to see that lots of people do not know that SQL Server Fill Factor 0 (which is the default value when SQL Server is installed) is equal to value as 100.
How to Send Execution Plan in Email? – Interview Question of the Week #079
After answering over 2000 performance emails, I saw that many users do not know how to send execution plan in email. Here is the easy way to do it.
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Lost or corrupted your log file? Learn how to attach an MDF data file without the LDF log file, using T-SQL or SQL Server Management Studio.