Archive for January, 2009

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:

Wednesday, January 28th, 2009 Uncategorized No Comments

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) 
Wednesday, January 7th, 2009 SQL Server No Comments