Get Table Count without using COUNT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Additional Articles... » Get Table Count without using COUNT

Get Table Count without using COUNT

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Wednesday, September 26, 2007 5:00 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Get Table Count without using COUNT

Post #402933

Jeff Moden

Posted Wednesday, September 26, 2007 6:47 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 33,108, Visits: 27,032

Dear Site Owners,
Go to a look at the code for this one... appears that something was lost in this last weeks "translation" ;)

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #402983

Christopher Stobbs

Posted Wednesday, September 26, 2007 6:56 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, February 24, 2010 4:10 AM
Points: 1,553, Visits: 2,232

Why would you want to do that?

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

w00t

Posting Best Practices
Numbers / Tally Tables

SQL-4-Life

Post #402990

« Prev Topic | Next Topic »

Permissions