Filed under Database Engine

Subscription Re-Initialization and Non Clustered Indexes

You would be now thinking what is the relation with re-initialization and Non Clustered Indexes. Well, We all know that Indexes are super critical for faster retrieval of data and what would happen upon re-initialization of a subscription if all your Non Clustered indexes at your subscriber database goes off? How many times did you have … Continue reading

Index fill factor and page splits

We all know that Indexes have an option of specifying fill-factor. By fill-factor we mean that we can specify how much of that page to be filled up with data. By specifying a fill-factor of 80 %, we intend to free 20 % of the space for future additions to the tables. Why do we … Continue reading