Determining distribution of NULL values

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Fri, 18 Nov 2011 03:21:00 GMT Indexed on 2011/11/18 10:09 UTC
Read the original article Hit count: 413

Filed under:
|
|
Today on the twitter hash tag #sqlhelp, @leenux_tux asked: How can I figure out the percentage of fields that don't have data ? After further clarification, it turns out he is after what proportion of columns are NULL. Some folks suggested using a data profiling task in SSIS . There may be some validity to that, but I'm still a fan of sticking to T-SQL when I can, so here is how I would approach it: Create a #temp table or @table variable to store the results. Create a cursor that loops through all...(read more)

© SQL Blog or respective owner

Related posts about data distribution

Related posts about metadata