Home Forums SQL Server 2008 T-SQL (SS2K8) count(*) taking forever... emergency RE: count(*) taking forever... emergency

  • October 5, 2012 at 10:50 pm

    #1546381

    Try running the statement below. If it runs much faster, your original query is probably being blocked.

    select COUNT(*) from TransactionLog with (nolock)