Post reply

Query Hangs after certain records

  • July 28, 2010 at 1:53 am

    #387446

    Hi,

    When i wuery a table with some where condition, it hangs after retreiving certain records i.e 74 records.

    It then shows as executing.

    Can anyone help me please.

  • July 28, 2010 at 5:36 am

    #1199162

    can you please provide the details of the table like no. of columns and no.of records. Also there may be transaction open which might be holding a lock on the table. Just execute "dbcc opentran" if any open transaction exists that may be holding a lock.

    Also try adding proper indexes to table( you can also use filtered indexes to match the where condition of query). Ensure that table has primary key.

    Thanks,

    Amit kulkarni

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply