Microsoft Business Intelligence

SSAS, MDX, SSIS, SSRS & T-SQL

Sunday, February 13, 2011

How to count total rows in a table without count(*)?

SELECT rows FROM sys.partitions WHERE object_id = object_id('test');
Posted by Santosh Joshi at 1:38 PM
Labels: T-SQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2011 (5)
    • ►  May (1)
    • ►  March (3)
    • ▼  February (1)
      • How to count total rows in a table without count(*)?
  • ►  2010 (10)
    • ►  December (3)
    • ►  November (1)
    • ►  October (1)
    • ►  September (4)
    • ►  April (1)
  • ►  2009 (1)
    • ►  December (1)

My Blog List

  • Chris Webb's BI Blog
    Measuring Time To Display For Image Visuals In Power BI With Performance Analyzer
    2 days ago
  • Darren Gosbell [MVP] - Random Procrastination
    DAX Studio v3.3.0 Released
    7 months ago
  • Vidas Matelis Analysis Services Blog
    PowerPivot Tips and Tricks for IT Pros
    12 years ago
  • Tomislav Piasevoli - BI Blog
    My 3rd Microsoft MVP award
    14 years ago
  • Prologika (Teo Lachev's Weblog)

Labels

  • Miscellaneous (3)
  • SSAS (6)
  • SSIS (2)
  • SSRS (2)
  • T-SQL (4)

About Me

My photo
Santosh Joshi
I am currently focused on MSBI and trying to learn it.
View my complete profile
Simple theme. Theme images by fpm. Powered by Blogger.