All,
When I try to "Design Storage" for a new cube, I get
a "Fact table size can not be 0" message. (I am in the
Cube Editor...) If I focus on the fact table and

Hi I understand clustered and non-clustered indexes
increase the amount of disk space used i have a table that
is 200mb and wondered if I added a non-clsted index how
much extra space that would use and is it added to the

Is it possible to use FK within SQL Server 7, using
Enterprise Manager?

I found that there is a setting to set the maximum log file, however,
I haven't enable it.  Therefore, current log file is 1G.  How can I
reduce it to 500MB so that I can set the max. log file to 500MB.
Happy new year to all

We have created a System which does over 1000 transaction every fives
minutes with the database. Mostly they are insert and udpdate commands. We
have noticed that the transaction log keeps increasing in size (in GBs). We
have used the Shrink command at various stages but at some ...

I'm trying to build a cube. I am using a view for my
account dimension. Here is the definition:
ALTER  VIEW DemandAccounts AS
SELECT *

Happy new year!!
I have deleted the log file from windows explorer and attach the
database file again, I found that all tables and diagram are still
here!!  Therefore, I just wonder what's the log file store and how can

I have a database which is 54GB in size and currently
utilizes a single file group. What is the best way to
split this database so that I can back it up maybe piece
by piece?