checked also practically. Works

Check advantage database local server (free). U can link to dBase tables by creating Advantage database definition and update /query dBase/Clipper tables with sql. They provide oledb driver. Theoretically should work

exec

master..xp_msver processorCount

Adding more RAM won't help at all, nor changing OS will. Hache hit ratio at 99% indicates that all needed data are usually in cache - that means you have enough...

The reason for this may be that your fact table conatains record with value which cannot be linked to to time dimension. You have two resolutions, first review value in...

Possible solution is use of ROLAP partitions for example. Than U have "online" cube. U have to gather all the tables ino one database (ROLAP requires possibility of indexed views...

What version of SQL server U try to connect to ? If it's 2000 desktop edition network connections are disabled by default. You can enable them using Server Network Utility

the only difference with tempdb is that the log is on the same device with data.

Use Crystal Reports for example - it can interpret database text fields as RTF /HTML