In the month of January, I offered exclusive training to my newsletter subscribers. The training was extremely unique and was available for a limited time. Quite a lot of newsletter subscribers took advantage of this limited time offer of “SQL Server Performance Tuning Practical Workshop”.
How to Find Size of All the Indexes on the Database – Interview Question of the Week #097
Question: How to Find Size of All the Indexes on the Database?
Does Dropping Primary Key Drop Non-Clustered Index on the Column? – Interview Question of the Week #085
Question: When we drop primary key on the column, does it automatically drop a non-clustered index on the same column (if created)?
Before we see answer of this question, I suggest you read following three blog posts, they discuss various similar aspects related to the primary key and clustered index.
Does Dropping Clustered Index Drop Primary Key on the Same Column? – Interview Question of the Week #083
Question: When we drop clustered index on the column, does it automatically drop primary key on the same column (if created)?
Does Dropping Primary Key Drop Clustered Index on the Same Column? – Interview Question of the Week #082
Question: When we drop primary key on the column, does it automatically drop a clustered index on the same column (if created)?
Answer: This is one of the most popular questions, whenever I ask this to any candidate, they usually give an answer in yes or no. However, if I ask them follow up question to confirm, I have noticed most of the time they change the reply or accept that they really do not know the answer. It is totally fine. As when I was beginning with SQL, I even did not know the answer of it. I learn doing various experiments and doing various interviews.
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.