How does the script for deleting old files differ from the Deleting old files in the Maintenance plan?

thanks

The databases and logs are stored on a SAN, seperate drives for each, these are controlled by our Unix team so do not know anymore about them.

Thank you for your reply, it seems non of those setting have been set on the server! do you know what the best max memory setting should be with...

Ok, thank you both for your help

Thank you, What sort of size would it be benificial, these databases are expected to grow quickly and more groups of databases are likley to be added.

Thanks

Thankyou

How would having 2 instances affect performance?  The current cluster is used by 1000's of people and is critical to company.

Would a 2nd virtual machine with its own default instance...

Thanks for your reply, i will give the adventureworks DB and tutorials a go and see how i get on.

Thank you very much, that solution is perfect for what i need, as T1 needs to be replaced by differnet tables, so all i need to do is replace the table...

yes, all 500 companies with one contact (any contact doesn't matter which one).

thanks

the data is as above, it doesn't matter what contact is returned.

thanks

thanks for your reply, I currrently get the reults and cut and paste into excel, and the sales guy formats it to how he wants to present it.  I thought...

Thank you for all the replies, I have now done what I needed to do

there wouldnt be anymore fax numbers added to this data, this is a dataset which is final and to be given to a customer as is, they just want it...

the unique refence is a refence generated when the record is added to the file, it is not in any particular sequence

forgot to mention they want the data sorted by...

I guess if i can find a way of creating a table based on the SELECT statement passed to the SP, i can get it to work unless anyone has...