declare @T table (
	col1 int null,
	col2 char null,
	colMT date null
	);

insert into @t
values 
	(1, 'A', null),
	(null, 'B', null),
	(null, 'C', null),
	(4, null, null),
	(5, 'E', null)

select count(col1), count(col2), count(colMT)
from @T

quote:

---

Originally posted by Bustaz Kool

1) You could generate some dynamic SQL that would test each column.
2) You could select the count of each column by name; since the null entries don't get included, any column that has a count of zero is unused

declare @T table (
	col1 int null,
	col2 char null,
	colMT date null
	);

insert into @t
values 
	(1, 'A', null),
	(null, 'B', null),
	(null, 'C', null),
	(4, null, null),
	(5, 'E', null)

select count(col1), count(col2), count(colMT)
from @T

---

Those who will not reason, are bigots, those who cannot, are fools, and those who dare not, are slaves. -Lord Byron, poet (1788-1824)

---

quote:

---

Originally posted by jackv

zudnic, you need to return to database design and investigate why some many NULLs are appearing
Another aspect of growth is to check for indexes which aren't used - use this script http://www.sqlserver-dba.com/2007/06/index-usage.html and this DMV http://www.sqlserver-dba.com/2007/11/sysdm_db_index_.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

---