Script to obtain column usage statistics(i.e. null versus not null) for every column in a given table

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Your request is rather vague, but I think you might want to look at this posting.

If my assumption is incorrect come on back with a more definitive question.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 2

You postd this in the SQL server 2005 forum, but if you have any SSIS 2008 available you could use the data profiling task to get this information.

Here's a short demo o how to use this task:

[font="Verdana"]Markus Bohse[/font]