SQL Server Performance

CDATE Function

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by Akthar, Aug 26, 2005.

  1. Akthar New Member

    Hi,
    i've experience slow performance when i use the VBA CDate function in a calculated member in SQL Server 2000 Analysis Services

    can anyone help?


    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  2. ghemant Moderator

    quote:Originally posted by Akthar

    Hi,
    i've experience slow performance when i use the VBA CDate function in a calculated member in SQL Server 2000 Analysis Services

    can anyone help?


    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS

    is this column have index on which you have creteria ? e.g. date1 is a column on which i have fire a query using cdate function ? if not it will help you out after index creation ..
    BTW what is your query looks ? would you post query ?

    Regards


    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami
  3. ranjitjain New Member

    I think he is firing the query on Analysis Services which can be optimised only if we can find alternative to the cdate function which he is using to retrive memer data.

Share This Page