Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Alternative of Count(*) aggr. function

Author  Topic  HendryC Starting Member 3 Posts Posted - 2001-02-19 : 21:39:20 Hello Friends, I've ever read an article explained that there's more efficient way (in sake of speed and performance) to get a number of rows in a table, rather than using Count(*) aggr. function, this way getting all info. from SQL Server system tables (sysobjects,sys..,etc). I know I read the article starting off from this site but when I come back here again, I couldn't find that article. So please help me tell that "tricky" way or pointing out the article's URL. Thanks in advance, Hendry