SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Adam Aspin / Data Profiling with T-SQL / Latest Posts

RE: Data Profiling with T-SQL

Adam Aspin — Wed, 22 May 2013 02:10:39 GMT

Thanks David!

RE: Data Profiling with T-SQL

David Stein Jr — Tue, 21 May 2013 15:16:22 GMT

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. :-)

RE: Data Profiling with T-SQL

Ira Warren Whiteside — Mon, 25 Feb 2013 10:12:34 GMT

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]

RE: Data Profiling with T-SQL

Adam Aspin — Mon, 25 Feb 2013 09:06:36 GMT

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

RE: Data Profiling with T-SQL

KJKKPSI — Mon, 25 Feb 2013 09:03:50 GMT

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', [u][b]#39;[/b][/u]DateTime2', 'time')

Data Profiling with T-SQL

Adam Aspin — Mon, 25 Feb 2013 00:02:37 GMT

Comments posted to this topic are about the item [B]Data Profiling with T-SQL[/B]