SQL Server Performance

Search Results

Search Again
  1. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Hi,<br /> Thanks.....I have created an non clustered index... on Table B 30 mintues back<br />But i dont think it will be completed right now [<img...
  2. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Please can you tell me what are the steps First one i see is to create a non clustered index on Table B then...?
  3. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Ok what i think from our discussion is to create an Non-clustered index on Table B with the two fields as total_amt and the idx_number and then...
  4. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    How can this table scan avoided then Twan?
  5. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    The tables will be updated every quarter
  6. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Ok i will reformat it and post it The idx_number is basically genrated from Table A and is also present as a foreign key to Table B Table B is the...
  7. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Let me clear some points The idx_number is basically genrated from Table A and is also present as a foreign key to Table B Table B is the table...
  8. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Sorry Twan but i am not getting you ************************************************************* I would change the query to select sum(total_amt)...
  9. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Sorry actually i am creating a non clustered index not clustered.Now i will check it and see how much time it will take to show records
  10. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    ok i am trying to create a clustered index But it ask for Order what should i choose "Ascending" or desceding for both the fields ?
  11. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    select sum(total_amt) from TABLE B where TABLE B.idx_number=TABLE A.idx_number WHERE idx_number='1234' This is my main query Coming to your...
  12. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    ok I wil do that any other suggestions like partitoned views etc....I have read somewhere on the forum that partitoned views helps you to...
  13. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Ok let me explain in details the table structure Table A consists of an idx_number Table B consist of 1) idx_number and 2) total_amt I will...
  14. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Will creating an clustered index on the total_amt help increasing the performance?Because this query takes me hours to show the results. Please help...
  15. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Hey "bambola" that worked pretty fast.Its ok for count now Can that be something done pretty fast on the foll query SELECT SUM(total_Amt) AS Expr1...
  16. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Its 3600 seconds.
  17. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    When i run a query "SELECT COUNT(*) AS Expr1 FROM bill_master" it gives me timeout expired.How should i overcome this
  18. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Which index has to be created .Unique/Clustered or non clustered.?And how much in % do you think the performance will increase if i do "select...
  19. sqlServer2k

    40 million rows and are increasing

    Post by: sqlServer2k, Aug 11, 2003 in forum: T-SQL Performance Tuning for Developers
    Hi Satya thanks for the early repl there is no index on the field --> total_Amt [money] The total_Amt is the field....which i am going to search on...
  20. sqlServer2k

    40 million rows and are increasing

    Thread by: sqlServer2k, Aug 11, 2003, 55 replies, in forum: T-SQL Performance Tuning for Developers
    hi, I have a table which consists of around 40 million records in the dattabase.when i go for a select count it takes around 3-4 hours to show the...
Showing results 1 to 20 of 20
Search Again