Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: Query Performance SQL 7.0 SP2 / SP4

    Hi Gurus
    I m using SQL Server7.0 with SP2 on Compaq Prolient ML310 PIV 2.2Ghz
    Now the problem is when i m executing the "select * statment " on a table with 21000 rows it is taking ard 1min to result for the same.and if i m using the same query without any service pack the result is coming in 4-5 Secs. but with the base system ( without service pack) my system get freeze frequently.

    REPLY URGENT

    TIA

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Have you tried downloading the latest service pack? (SP4 for 7.0 I believe)

    What changed between having the sp and not having it?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Oct 2003
    Posts
    4
    Originally posted by rhigdon
    Have you tried downloading the latest service pack? (SP4 for 7.0 I believe)

    What changed between having the sp and not having it?
    I have checked with the SP4 even , but the back to square one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •