Microsoft sql server "frequency report"
Posted on 2014-07-22
I've been doing a lot of "initial analysis" on data files we receive from external entities. Part of what I do with that data is to look at it and see what we have and describe it.
I like to work in SSMS but find myself often using other tools to run "frequencies" (e.g., SPSS or AgileDataSoftware FileQuery"). Is there a function in SSMS that would allow me to run frequencies on data without having to define each field etc? Something I could quickly run against a table that would tell me for each field in the table the count of distinct values, count of "empty" values, min and max length, types of characters (letters, digits, whitespace, special characters), and then 10 or 20 sample values?
The output would be best in a report format.
I feel like I'm looking for a plugin or something but I'm not really sure.