Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database Fields Analysis from ACTDiag

Copper Super Contributor
Posts: 112
Country: Australia

Database Fields Analysis from ACTDiag

trying to get info on the following data from the ACTDiag reports

 

-is there a MAX number of columns that any table can have?

does it have anything to do with "Available Pagesize"?? (can you explain a little more about pagesize setup, has it got to do with things like each nvarchar using xx bytes of total size)

 

 Field Count: 86 (54 Physical, 31 Virtual, 1 Calculated)
(in approx. bytes) Supported Pagesize: 7584, Current Pagesize: 4523, Available Pagesize: 3061

 

 Field Count: 86 (54 Physical, 31 Virtual, 1 Calculated)(in approx. bytes) Supported Pagesize: 7584, Current Pagesize: 4523, Available Pagesize: 3061

 

-why does the report not list ALL fields, but only a few??

-------------------------------------------------------

COMPANY Entity Field Statistics (by table):

-------------------------------------------------------



    ACT! Table: Company

Physical Table: TBL_COMPANY

  Record Count: 33

   Field Count: 59 (29 Physical, 30 Virtual, 0 Calculated)

(in approx. bytes) Supported Pagesize: 7584, Current Pagesize: 3099, Available Pagesize: 4485

 

ACT! Field                              Physical Column                         ACT! Fieldtype      Physical Type       Non-Empty  Density    Max Len    Min Len    Avg Len    Recommendation           

--------------------------------------  --------------------------------------  ------------------  ------------------  ---------  ---------  ---------  ---------  ---------  -------------------------  

Company                                 NAME                                    Character           NVARCHAR(128)       33         100%       29         8          17         Consider shortening column length to 35 (-93)

Company Description                     DESCRIPTION                             Character           NVARCHAR(128)       0          0%         0          0          0          

Customer ID                             CUST_CustomerID_075514500               Uppercase           NVARCHAR(8)         2          6%         8          8          8          Low column usage, Review need

Division                                DIVISION                                Character           NVARCHAR(64)        0          0%         0          0          0          Low column usage, Review need

ID/Status                               CATEGORY                                Character           NVARCHAR(128)       25         76%        15         8          8          Consider shortening column length to 18 (-110)

Industry                                INDUSTRY                                Character           NVARCHAR(64)        0          0%         0          0          0          

Number of Employees                     NUMEMPLOYEES                            Number              INT                 0          0%         0          0          0          Low column usage, Review need

Referred By                             REFERREDBY                              Character           NVARCHAR(64)        8          24%        17         6          10         Consider shortening column length to 21 (-43)

Region                                  REGION                                  Character           NVARCHAR(64)        0          0%         0          0          0          Low column usage, Review need

Revenue                                 REVENUE                                 Currency            DECIMAL(18,2)       0          0%         0          0          0          Low column usage, Review need

SIC Code                                SICCODE                                 Character           NVARCHAR(8)         0          0%         0          0          0          Low column usage, Review need

Territory                               TERRITORY                               Character           NVARCHAR(64)        0          0%         0          0          0          Low column usage, Review need

Ticker Symbol                           TICKERSYMBOL                            Character           NVARCHAR(12)        0          0%         0          0          0          Low column usage, Review need

Web Site                                WEBADDRESS                              URL Address         NVARCHAR(128)       28         85%        28         15         20         Consider shortening column length to 34 (-94)

 

 here you can see 59 fields are the total in the table, but the report only lists 14 of them.. where are the rest of them? same goes for all other listed tables.. it only lists X number of the total number of fields.