Looking for a way to list a row count for every table in a database? Look no further...

by Shawn 6. January 2012 08:34

SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count
FROM sys.dm_db_partition_stats st
WHERE index_id < 2
ORDER BY st.row_count DESC
GO

f5020b38-131c-4deb-9df1-8a9c0d20c5fb|0|.0

How to replace notepad.exe on Windows Server 2008Have you been looking for a way to replace all instances of notepad.exe on Windows Server 2008? If s...How to Alter a SQL Server Database as Single User Mode and as Multi User ModeOriginal Link: http://www.kodyaz.com/articles/alter-single-user-multi-user-mode.aspx You can use th...E-mailing a Document from a SharePoint Document LibraryThe following post is taken from: http://www.beckybertram.com/oldblog/index.php?m=20071004 ...

Name* Required Please choose another name

E-mail*

Country Country flag

b i u quote

Notify me when new comments are added

IT Ramblings