Having the query engine choose a scan instead of a seek isn't going to be affected by how fragmented your index is. An index, by definition, is the ordering of...

The best advice anyone can give about whether the time spent on the index reorg is normal is to take measurements and see what you normally get. The answer about...

In the past, I've done things like this using role based permissions. You can design the system differently, but a lot of the basic building blocks would be to have...