Can we used codes Visual.dot to manage cube?

Is there anyway to reload data for a specific day by clearing the existing
data.
I need to reload data for a specific day by clearing the existing day data
in the cube. Full process or refresh is time consuming until I increase the

Hi Group,
I just started at a company and am trying to come up with a solution
to streamline the datawarehouse.
The problem is, we have two databases.  Database1 (548 tables) is

Need some input please.
I have a development domain, with one server running SQL Server 2000 sp
3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
REporting Services.

Could anyone tell me if there are any disadvantages in using partitions
in cubes ?  
Thanks

Any hints why the aggregation designer will be slow.
Many Thanks.

I have set up an Active Directory, Certificate Services on Windows 2003
Server. I am running SQL 2000 Server. AD and Certificate Services were
installed correctly.
My goal is to be able to use SSL when connecting to SQL Server via Query

How does one create outer joins in the cube editor.  The documentation states
that by default only inner joins are created and to use Visual Database Tools
( a Visual Studio module).  Any workarounds for this?
thanks in advance

I have a table with identity column. I set the increment
to 1. But after I have deleted a couple of rows then
inserted a new row, the increment is not based on the
existing row number. For example, I had 100 rows already.

I've an index to create around a table with 3millions of rows.
my tempdb database is on a different set of disks, so I use the
SORT_IN_TEMPDB when I recreate my index, but I don't see any activity around
the tempdb database and the time to create the index is the same!

I'm trying to use MS BI Accelerator for creating DW which must contain data
from different sources. Every source is our company departmnet standard
database. I'm looking for best practice  for collecting fact and dim data
from this databases in BI Acc staging database, i.e. creating ...

Currently evaluating ETL tools to replace hand coded sql at 10 datamart
installations.  Each installation requires custom code and complex
transforms involving deleting records, updating fields,changing
associations betweeen parent and child records, etc.  Anyone have

again we have some SQL statement performance problems...
I've 2 table with 140 000 records each.
I join the 2 tables and the result is also 140 000, but the query analyzer
estimate 1000 rows only.

I have a table with some data in it, I would like to
generate one Insert script command for each record.
Is there a SQL Server tools for doing it?
I mean, this is my table:

Can someone help me with the following
I have to automate the process of loading the files from source to target.  
I have to use partitioned tables which should be created automatically to
load the data. These tables should have different name each week(for e.g