Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kendal Van Dyke How To Get Table Row Counts Quickly And Painlessly RE: How To Get Table Row Counts Quickly And Painlessly

  • September 2, 2009 at 2:40 pm

    #1048443

    I thought

    SELECT count(1)

    FROM mytable

    WITH (nolock)

    was the preferred method, and certainly easier to remember