I am currently the only Architect/DBA, supporting 6 full time developers. We will also contract 1-3 developers here and there for focused work, so the ratio ranges from 1:6...

Thanks for the great article.

We do index rebuilds every two weeks, and Fill Factor plays an important role.

I have found that the "magic number" for FF would be the amount...

I have always been a fan of the YYYYMMDD append format. If you are dealing with more than one file a day, or care about when the files was...