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.

http://www.sqlsaturday.com/

 

SPTech 2013 – Boston, Massachusets

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

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 t.name TableName, i.rows Records
from sysobjects t, sysindexes i
where t.xtype = ‘U’ and i.id = t.id and i.indid in (0,1)
–order by TableName;
order by Records DESC;