Database Population Statistics

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Database Population Statistics

Author

Topic

mrees
Starting Member

2 Posts

Posted - 2005-04-01 : 07:56:14

I need to works out percentage completion for certain areas of the database I manage. Is there a tools within SQL Server Enterprise Manager that allows me to do this or will I have to build a view or write a query.

Firstly, I need to work out the percentage completion of every column. i.e. look down a column count the number of cells with data then work out a percentage against the number of rows.

Secondly, I need to look along a row (a row represents a project record) and count the number of cells containing data, then work out a percentage against the number of columns.

This is pretty simple in Excel (and I have actually been tracking population stats using a spreadsheet believe it or not) however I want to be able to do this within my SQL database.

Be grateful for any help you can offer.

Thanks

jason
Posting Yak Master

164 Posts

Posted - 2005-04-01 : 12:50:29

No tool that I know of, but let me know if you find one.