Geeks With Blogs
kazim mehdi

Its always time consuming when ever we have to get the row count on the table that includes millions of rows but not any more get the result back b4 an eye complete its blink.

EXEC sys.sp_spaceused N'tblename'

Replace tablename with the name of your table and see the result.

http://www.sqlservercentral.com/articles/T-SQL/67624/

Posted on Friday, January 28, 2011 4:38 PM Sql , Sql Server | Back to top


Comments on this post: Sql Server: Table row count b4 a blink complete.

# re: Sql Server: Table row count b4 a blink complete.
Requesting Gravatar...
Wonderful tip - and it even works without having dbOwner level access!
Left by BigJim on Jan 28, 2011 7:33 PM

Your comment:
 (will show your gravatar)


Copyright © kazim sardar mehdi | Powered by: GeeksWithBlogs.net