Data Profiling with T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Adam Aspin » Data Profiling with T-SQL

Data Profiling with T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

Adam Aspin

Posted Monday, February 25, 2013 12:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:10 AM
Points: 81, Visits: 848

Comments posted to this topic are about the item Data Profiling with T-SQL

Post #1423484

KJKKPSI

Posted Monday, February 25, 2013 9:03 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 7:18 AM
Points: 55, Visits: 30

Thanks for the excellent article, and the wonderfully useful script. I can already think of a number of instances where something like this could have been huge time savers.

One thing of note, there appears to be a character that got lost in translation along the way.

On Line 114: There appears to be a single quote (') that was incorrectly converted to value '#39;'

WHERE DATA_TYPE IN ('Date', 'DateTime', 'SmallDateTime', #39;DateTime2', 'time')

Post #1423648

Adam Aspin

Posted Monday, February 25, 2013 9:06 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:10 AM
Points: 81, Visits: 848

Thanks Ken, I will see if I can get this corrected.
Glad that you find this script useful.

Adam

Post #1423650

Ira Warren Whiteside

Posted Monday, February 25, 2013 10:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42, Visits: 272

Adam, excellent article and my favorite topic.

I have several articles and scripts also on Data Profiling via SSIS(DataFlow script component) and also TSQL.

[url=http://www.sqlservercentral.com/Authors/Articles/Ira_Whiteside/382777/][/url]

Ira Warren Whiteside

Post #1423682

David Stein Jr

Posted Yesterday @ 3:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 5:16 AM
Points: 4, Visits: 180

Nice script Adam, but I found another typo. About line 257, you'll find the following:

+ QUOTENAME(@COLUMN_NAME) + ')
,NULL
,NLL
,NULL

NLL should be NULL, right?

Thanks for the script though. It works great after I cleaned up the 2 typos. Smile

Post #1455235

Adam Aspin

Posted Today @ 2:10 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:10 AM
Points: 81, Visits: 848

Thanks David!

Post #1455356

« Prev Topic | Next Topic »

Permissions