Author Archives: admin

SQL Saturday – Pittsburgh

A couple weeks ago I attended SQL Saturday – Pittsburgh.  A was able to learn a great deal about SSAS, Perfmon, Beginner DBA Best Practices, Interview Techniques, and some great techniques for gathering better requirements.


SPTech 2013 – Boston, Massachusets

This week I am attending the SPTech 2013 Conference in Boston.  Read my review on

T-SQL: List the total number of rows for each table

T-SQL statement to list the total number of rows (or records) in each table of a database.

select TableName, i.rows Records
from sysobjects t, sysindexes i
where t.xtype = ‘U’ and = and i.indid in (0,1)
–order by TableName;
order by Records DESC;