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: Wednesday, May 15, 2013 3:42 AM
Points: 80, Visits: 846

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: Tuesday, April 23, 2013 8:42 AM
Points: 55, Visits: 29

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: Wednesday, May 15, 2013 3:42 AM
Points: 80, Visits: 846

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

« Prev Topic | Next Topic »

Permissions