[dba-SQLServer] Re: "Data dictionary"

John,

Nothing that is free or cheap.  The company I work for
just dropped about 250,000 for a package to do something
like this.

Create a table to hold the data.
2 columns  ColumnName and COlumnValue and CountOfValue
then create a stored procedure with
a parameter of @ColumnName for input
create a SQL statement that will append the data into the table

BTW, you could also use this table for the zip code count also.
You will never be able to get good speed out of the other options
because of the size of your DB.  By running the SP and loading
the data into a reporting table, you will be able to get extremely
good performance for the reporting.

Also, the reason for the count of each value is because, from
my experience, they end up wanting to see how many of ones they
consider a problem exist in the data.

Robert

At 09:15 AM 9/23/2004 -0500, you wrote:
>Date: Thu, 23 Sep 2004 10:08:53 -0400
>From: "John W. Colby" <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] "Data dictionary"
>To: dba-sqlserver at databaseadvisors.com
>Message-ID: <000b01c4a176$def02730$e8dafea9 at ColbyM6805>
>Content-Type: text/plain; charset=us-ascii
>
>My client wants what he refers to as a data dictionary.  What he is
>referring to is a list of all the DISTINCT values in the data for a specific
>set of fields.  Is there any (cheap / free) tool that can do this?  I need a
>table or spreadsheet, with the field name, then the distinct values in that
>field.  I can do this field by field by building queries but if there is
>something quick and easy it sure would help.
>
>John W. Colby