First, your estimate of 5 million users seems a bit optimistic, but let's go with that.

Managing the table of references to dtermine where data is store based on the user...

This method can be used to show you the beginning of ends of gaps, but if you are missing three values in a row, getting the one in the middle...

The best way to do this is to generate a list of numbers that "should" be there and then use a left joint to find the missing ones.

This can be...

It is most likely some application-level overhead in building a recordset. The best way to determine where the problem resides is to use profiler to trace the activity on...

Your question does not seem to make much sense. How can it be a system database if you created it?

Yes, what I am saying is you have to either create or change (if one is already configured) the drillthrough action for the cube. Whatever drillthrough has it's default...

It is a drillthrough action in the actions of your cube.

That looks reasonable. You don't really need to use temporary tables (or tables - temp tables may turn into a pain for you). You could pull both data...

As far as the amount of memory SQL 2005 Standard can use - it is limited to the OS limit. I would have to guess you are using the...

I would tend to say control the transactions at the lowest level possible. If you have several statements in a single procedure that need to be atomic, control the...

You could create the date list with a tally table to improve the performance, but an efficient way of doing what you want is to compare your list of dates...

Assuming you have TCP/IP connections enabled, the SQL server does not know the difference. I suppose it is possible you are getting names pipes connections by server name. ...

I assume the fact that SSIS would require a SQL license at each site has made this option cost-prohibitive in your case and that is why the option is somewhat...

Your Exchange server is probably not configured to allow an SMTP relay to an outside mailbox. You either need to have your Exchange admin set this up, or add...

You cannot put an integer into a GUID field.