Share via


Get the NULL percentage of values in a specific table dynamically

 

Nothing really fancy, but a small script I was now asked twice for. So I thought I publish it for the public and for the reference for others. It simply calculates the percentage of NULL values for a specific table in all columns. The last request was originated from the post here.

Be aware that this will scan the table entirely and might need some time for coming back.

You will get each column with an integer value as the percentage. This script will work on any version of SQL Server (except CE).

You find the script here.

-Jens

Comments

  • Anonymous
    August 28, 2010
    Hi Jens, I followed your blog since the beginning...great stuff. The script's download link appears to be broken for this one. Cheers, Bob

  • Anonymous
    August 28, 2010
    Thanks Bob for the heads up, I fixed that. Forgot to zip file file. -Jens

  • Anonymous
    September 05, 2011
    The comment has been removed

  • Anonymous
    September 05, 2011
    The last one is working for me too, it is creating a redirect to my website. Maybe you can check the redirect link which is: www.sqlserver2005.de/.../NULL_Percentage.zip -jens