Tag Info

New answers tagged


You have received good advice for keeping the index as narrow as possible, both for space use and for controlling the amount of I/O. But you have maneuvering room in your decisions. If you create an index on SchoolID and ID is the clustered index, then your index on SchoolID will include the clustered index as well. Depending on the distribution of your ...


Having worked on a large-scale, multi-tenant system (federated approach with customers spread across 18+ servers, each server having identical schema, just different customers, and thousands of transactions per second per each server), I can say: There are some folks (a few, at least) who will agree on your choice of GUID as the IDs for both "TenantID" and ...

Top 50 recent answers are included