Home Forums SQL Server 2008 SQL Server 2008 - General Simple select query with no where or join takes a long time RE: Simple select query with no where or join takes a long time

  • July 7, 2013 at 2:47 am

    #1630262

    Hi!

    - Check locks: run query with nolock hint, and check running time

    - Check hardware performance (CPU, Disk, Memory) under query running