John W. Colby
jwcolby at colbyconsulting.com
Thu Sep 23 16:08:19 CDT 2004
Hey, tell them to drop a quarter million my way will ya? I'll take a month off and dev the same thing for them. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: Thursday, September 23, 2004 11:57 AM To: dba-sqlserver at databaseadvisors.com Cc: jwcolby at colbyconsulting.com Subject: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com