SQL Server 2005 - find fields that aren't used (have all nulls)
===

I've inherited a legacy database, and many, many fields are no longer being used. I can tell by querying on the last couple of years and seeing which fields are null, to at least get a baseline for where I might look.

Is there an elegant way to figure out which fields in the database are null for all records in a given set?

