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 – Updating Data into ColumnStore Index with SQL Server 2012
In SQL Server 2012, INSERT fails with Msg 35330 on a table with a columnstore index. Here is the process for updating data into ColumnStore index.
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.
SQL SERVER – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes
SQL Server 2016 lets you create additional nonclustered indexes on tables with clustered ColumnStore indexes. Here is how it works.