Came across some great sql to dig into the state of documents and their libraries.
Things like – ‘top 100 largest documents in all document libraries’ plus lots more.
Check it out
http://www.codeproject.com/dotnet/QueriesToAnalyze…
Cheers,
Mick.