See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.
How to Find Size of All the Indexes on the Database – Interview Question of the Week #097
Need to know how much space your indexes use? Here is a script I share with clients that lists all the indexes in a database along with their size.
Does Dropping Primary Key Drop Non-Clustered Index on the Column? – Interview Question of the Week #085
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.