SQL Administrator Question:

Download Job Interview Questions and Answers PDF

Explain me where do you find the default Index fill factor and how to change it?

SQL Administrator Interview Question
SQL Administrator Interview Question

Answer:

The easiest way to find and change the default fill factor value is from Management Studio, right-click the SQL Server and choose properties. In the Server Properties, choose Database Settings, you should see the default fill factor value in the top section. You can change to the desired value there and click OK to save the changes.
The other option of viewing and changing this value is using

Download SQL Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
Tell us what are the different types of Upgrades that can be performed in SQL Server?Tell me what authentication modes does SQL Server support?