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.


Comments (4)

  1. 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

  2. Thanks Bob for the heads up, I fixed that. Forgot to zip file file.


  3. Papy Normand says:

    Hi Jens,

    The first link marked here is not working , the link in the last line is working.

    Simple, easy to understand and useful so thanks !!

    I have discovered that you are coming back on the forums.Good news…

    Papy Normand

  4. Jens K. Suessmeyer says:

    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:…/