Mahipal Padigela's Blog

Spring ‘09 SQL Server vConference

is scheduled for April 22, 23, 24. Four tracks – SQL Server/.NET/SharePoint/Business Intelligence

check it out at http://www.vconferenceonline.com/shows/spring09/sql/

you can use VIP code VCTAF503033-0 to get £10 discount! (inaddition to any earlybird discounts)

Tags: vConference

Table Row counts Sql Server 2005

You can get the same in SSMS, by selecting ‘Reports’ option in the Database context sensitive menu

SELECT
	distinct Table_Name = object_name(object_id),
	T.TABLE_SCHEMA,
	Total_Rows =  st.row_count
FROM sys.dm_db_partition_stats st INNER JOIN information_schema.tables T
on object_name(object_id) = T.TABLE_NAME
where object_name(object_id) not like 'sys%' and object_name(object_id) not like 'queue%'
ORDER BY object_name(object_id)