{"id":291,"date":"2012-05-10T13:48:30","date_gmt":"2012-05-10T07:48:30","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=291"},"modified":"2014-10-20T19:44:11","modified_gmt":"2014-10-20T13:44:11","slug":"how-to-perfom-fast-record-count-in-sql-server-t-sql","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/how-to-perfom-fast-record-count-in-sql-server-t-sql\/","title":{"rendered":"How to perfom fast record count in Sql Server T-Sql"},"content":{"rendered":"

\n\tScenario :  You have a table that has a lot of rows and you want to know the total number of rows.\n<\/p>\n

\n\tSolution 1 :  The classic solution is SELECT COUNT(*) FROM TableName<\/span> but this can take a while.\n<\/p>\n

\n\tSolution 2 : The faster way to get the record count would be one of the choises below :\n<\/p>\n

    \n
  1. \n\t\tSELECT SUM(1) FROM TableName<\/span>\n\t<\/li>\n
  2. \n\t\tSELECT COUNT(1) FROM TableName<\/span>\n\t<\/li>\n
  3. \n\t\tSELECT ROWS FROM SYSINDEXES WHERE OBJECT_NAME(ID)  = 'TableName' and indid<2<\/span>\n\t<\/li>\n
  4. \n\t\tEXEC SP_SPACEUSED 'TableName'<\/span>\n\t<\/li>\n
  5. \n\t\tDBCC  CHECKTABLE(''TableName)<\/span>\n\t<\/li>\n<\/ol>\n

    \n\tLucian Leonte<\/span>\n<\/p>\n

    \n\tMCT, MCITP, MCTS<\/span>\n<\/p>\n

    \n\tPowered by CodeReview – Let's make it Better!<\/a><\/strong><\/em><\/p>\n

    Share this:<\/h3>