I've heard an opinion that adding foreign keys or check constraints at
runtime can be a huge performance bottleneck. (I mean for example
foreign keys in fact table and runtime process of data loading to data
warehouse database)

I have a general question to datawarehousing and it'll be great if someone  
can drop some tips here. I'm about to start designing a corporate real  
time datawarehouse with SQL Server 2005 and is deciding on the approach  
for this.

I would like to know how building a DataWarehouse can increase revenue to an
organization
Thanks

in sql server is it possible to get the amount of memory used by a stored
procedure? e.g. memory usage statistics per stored procedure?

My available memory is down to very little, yet my PF Usage is 8 gigabytes
(about how much memory is on the box), sql server keeps having memory issues
yet the sqlservr.exe is using hardly any memory.. how to fix this? is there
some way to limit how much memory can be used by ...

I'm a freshman in a datawarehouse company.
All my coworkers are on-site in user side,such as banks,
and our development machine is also given by user.
There is no server or desktop in our company.

I have the following problem: I have a very large data base used by our
clients for beta-testing. With prohibitions of just taking the data (using a
backup or so)
I can connect to this machine by accesing two terminal service - poor

I need to populate a database for a load-test.
I tried VS2005 for db proffesionals and it's datageneration plans, but it's
simply not working with the current configuration.
Do you know/use any other tool,preferable free, that can do this?

BACKGROUND
We have a slightly slow performing Application which runs of a SQl Server
2000 database (lets call it M). The SQl server database structure is in an
Object store form, as the Small Talk based application is responsible for

Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?