I have a partioned view called members.
Partined based on status of the members.
Tables :  members_11 ( check status=1)
     members_22 (check status>1)

I have detached some DBs month ago from an SQL Server 2000 64 Bit Edition
and now try to attach them on a 32 Bit environment and get the error message
"The file you?ve specified is not a valid SQL Server database file".
Are the DB Files of 64 Bit and 32 Bit not Compatible ?

I need some advise.  We are in he process of designing our first data
mart. This Datamart will consists of sales orders activity.  Sales
orders have lines created, deleted and inserted on a daily basis as
long as the sales order is open.

I am very perplexed with this problem I'm having. I work for a website-based
company and my job is to create a data warehouse based on usage of the site.
We have a Central Logging Database that logs every single hit to the site,
then i have a stored procedure that picks up these ...

I need some help on how to improve performance when loading tables.
We have a datawarehouse and sometimes it is needed that the entire
datawarehouse is refreshed.  (like when test is refreshed from production)
The datawarehouse tables are refreshed by a set of sql statements.  Take ...