Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Finding rows count in a table without Select... Expand / Collapse
Author
Message
Posted Thursday, April 15, 2010 3:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 8, 2011 7:03 AM
Points: 125, Visits: 51
Well....
just used

sp_spaseused <tableName>


Post #903875
Posted Tuesday, August 10, 2010 10:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 11:36 AM
Points: 60, Visits: 259
exec sp_helptext 'sp_spaceused'
It is query sys.dm_db_partition_stats
Post #966822
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse