Rowcount for All Tables
-
Posted on June 17, 2009 by Derek Dieter
SELECT SUM(rowcnt)
FROM sysindexes
WHERE indid < 2
Featured Articles
- How to cache stored procedure results using a hash key There are a lot of different design patterns that lend themselves to creating
- SQL Server Database Optimization Guide In the troubleshooting guide we went over the different physical bottlenecks that can
- Yet Another Temp Tables Vs Table Variables Article The debate whether to use temp tables or table variables is an old
- Using Union Instead of OR Sometimes slow queries can be rectified by changing the query around a bit.
Site Author
