Dear All.
I want to do data profiling on different database objects and i need to get the following in a report either graphically or table wise in excel for a datawarehouse project.Our database is sql server 2008 can anyone give me a solution or query or a stored procedure to get all these information.
DATABASE
CATALOG
SCHEMA
TABLE
COLUMN
RUNDATE
RECORD_COUNT
DATA_TYPE
NULL_COUNT
PERCENT_NULL
UNIQUE_COUNT
PERCENT_UNIQUE
MIN_LENGTH
MAX_LENGTH
AVERAGE_LENGTH
MIN_VALUE
MAX_VALUE
AVERAGE_VALUE
TOP_VALUE
Help highly appreciated.