Tuesday, June 27, 2006
« Intro to technologies related to web ser... | Main | June CTP of .NET 3.0 »
A Faster Way to Get a Total Number of Rows in a Table
If you're interested in SQL Server performance, check out A Faster Way to Get a Total Number of Rows in a Table (via Jason Haley). 

The commenters have a good point: if this is really a better way than COUNT(*), then why not optimize COUNT(*) to do the more efficient query behind the scenes?

SQL Server | SQL
Tuesday, June 27, 2006 3:51:02 PM (Central Daylight Time, UTC-05:00)  #    Disclaimer  |  Comments [0]  |  Related posts:
Intro to SQL Server Data Services (SSDS) - SQL Server in the Cloud
Visual Studio Team System for Database Professionals - Trial
SQL Express – More than you realize
Studying other people’s code
Change template for "New Stored Procedure..."
Name
E-mail
(will show your gravatar icon)
Home page

Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u)  

Enter the code shown (prevents robots):

Page rendered at Thursday, August 28, 2008 8:39:06 PM (Central Daylight Time, UTC-05:00)