Forum Replies Created

Viewing 15 posts - 16 through 30 (of 32 total)

  • RE: Using VBScript to Automate Tasks

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

    thanks

  • RE: SQL 64bit memory

    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.

  • RE: SQL 64bit memory

    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...

  • RE: Filegroups

    Ok, thank you both for your help

  • RE: Filegroups

    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

  • RE: Mutiple Instance on SQL Cluster

    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...

  • RE: Point me in right direction

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

  • RE: Joins

    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...

  • RE: Joins

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

     

    thanks

  • RE: Joins

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

     

    thanks

  • RE: What does Reporting Services do?

    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...

  • RE: Split data in SQL Table

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

     

  • RE: Split data in SQL Table

    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...

  • RE: Split data in SQL Table

    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...

  • RE: Excel Export Question

    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...

Viewing 15 posts - 16 through 30 (of 32 total)