Eric1/2aB (8/26/2013)

---

6 - What would you suggest for fill factor on a table like this? 100%?{/quote]

For indexes on GUIDs, an idea is to have a low fill factor, say 50%. New guids will fill in the holes, and reduce the amount of page split. As the pages start to get full, page splits will occur, so you should rebuild in due time.

It will mean a waste of empty space in the buffer cache, though.