sp_DataProfile is a tool that helps you investigate data in SQL Server quickly and efficiently. sp_DataProfile will help you view table structure, view the number of unique values and nulls in a table, and view the distribution of values in a column.

Download sp_DataProfile

You can get sp_DataProfile on the download page!

Modes

sp_DataProfile has five modes that help you understand your data

  • Table Overview (0 – Default)
    This will give you an overview of the structure of a table.
  • Column Detail (1)
    The column detail will give you the same information as the table overview but include the Number Unique Values, Unique Ratio, Number of Nulls, Null Ratio, Min Length, and Max Length for each column in a specified table.
  • Column Statistics (2)
    This provides the Minimum, Maximum, Mean, Median, Standard Deviation for each column in a specified table.
  • Candidate Key Check (3)
    The Candidate Key Check will determines if a column or group of columns has duplicate data within it. If duplicate data is found with the column(s) the number of duplicates, the value(s) of the column(s), and a SQL statement that will show you the rows that were duplicates.
  • Column Value Distribution (4)
    This provides the distinct values in a table an the number of times that that value occurs in the table.

Examples

Table Overview

sp_DataProfile_TableOverview_Posts

Table Overview with Indexes and Foreign Keys

sp_DataProfile_TableOverview_Posts_IndexFK

Column Detail

sp_DataProfile_ColumnDetail_Posts

 Column Statistics for a 10% Sample

sp_DataProfile_ColumnDetail_Posts

Candidate Key Check

sp_DataProfile_CandidateKeyCheck_Users

Column Value Distribution

sp_DataProfile_ColumnValueDistribution_Posts

5 Comments

  1. Alberto Santaballa
    August 18, 2015 @ 10:24 AM

    Looks cool, Richie. Just downloaded and will give it a whirl. –Al-

    Reply

  2. Count of rows in a table | AEJ Software
    November 9, 2015 @ 5:05 AM

    […] sp_DataProfile is a great free (see EULA for terms) tool, to give various statistics for a table and it’s columns, one of which is row count. […]

    Reply

  3. My Applications and Bookmarks – Happiness In Focus
    March 9, 2016 @ 3:51 PM

    Reply

  4. Skewed Data: Finding The Columns | Exchange Spill
    April 6, 2016 @ 1:06 PM

    […] sp_DataProfile by Richie Rump […]

    Reply

  5. sa
    April 26, 2016 @ 1:13 PM

    Handy and fast, thanks so much for sharing.

    Reply

Leave a Reply