Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Profiling with T-SQL Expand / Collapse
Author
Message
Posted Monday, February 25, 2013 12:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Monday, February 25, 2013 9:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Monday, February 25, 2013 9:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Monday, February 25, 2013 10:12 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Yesterday @ 3:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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.
Post #1455235
Posted Today @ 2:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:10 AM
Points: 81, Visits: 848
Thanks David!
Post #1455356
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse