DBCC CHECKDB will do just what you want. The PHYSICAL_ONLY option is probably the fastest way to get the checksums validated.

Somebody asked me this question. So here it is: SQL 2005 still supports the following three ways to report data and log space usage for a database: DBCC SQLPERF ( LOGSPACE ) can tell you the log size and used size. sp_spaceused for space...

DBA focus: http://www.sqlskills.com/resources/Whitepapers/SQL%20Server%20DBA%20Guide%20to%20SQLCLR.htm Developer focus: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp

This is a quite old paper (Jan 02): http://research.microsoft.com/~gray/Papers/MSR_TR_O2_01_20_queries.pdf I was reading some news on astronomy which mentioned the SDSS. So I looked up this paper for some more detail. I thought you might like the...