All Questions

Filter by
Sorted by
Tagged with
3
votes
1answer
4k views

How can I set the index fill factor back to server default?

I have some indexes that I was playing with on my dev server. I set the fill factor of these indexes using the following command: alter index all on dbo.Table rebuild with (fillfactor=80) That sets ...
9
votes
2answers
1k views

How much “Padding” do I put on my indexes?

How do you know how much "Padding" an index should have?