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.
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 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.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
SQL SERVER – Extended Events to watch for using ColumnStore Index
Profiler can’t show how ColumnStore indexes work, so a DBA friend asked which extended events to watch. Here are my notes on the events worth tracking.
SQL SERVER – ShowPlan XML Additions for ColumnStore Indexes
How can you tell if a query used a columnstore index and batch processing? Here are the properties SQL Server adds to the ShowPlan XML for ColumnStore indexes.