What are other alternatives to this approach? I read that using multiple address assigned to different users is one way to handle it but would like to hear your opinion about other alternatives.
MS SQL Enterprise will handle alot of load.
For god's sake, DO NOT get trapped by MS. Once you are in, there is no way out.