Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Performance when adding PK

    Miles Neale (8/2/2012)


    Chris - could you post also the schema of any indexes on those tables?

    Sorry, How would I show this?

  • RE: Performance when adding PK

    Miles Neale (8/2/2012)


    Chris - could you post also the schema of any indexes on those tables?

    Again, forgive my skill level here. What is the best way to show this?

  • RE: Performance when adding PK

    Here are the table schemas

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING ON

    GO

    CREATE TABLE [dbo].[Customer](

    [CustID] [int] NOT NULL,

    [DealerID] [int] NOT NULL,

    [Distance] [int] NULL,

    [SSN] [nvarchar](11) NULL,

    [Last] [nvarchar](50) NULL,

    [First] [nvarchar](30) NULL,

    [Address] [nvarchar](60) NULL,

    [City] [nvarchar](35)...

  • RE: Performance when adding PK

    What is the best way to give you this information? As far as the schema and clustering? I have never created and clusters before.

    Sorry for my limited knowledge here.

  • RE: Performance when adding PK

    Here is how my tables look now.

    Customer

    CustID DealerID First Last

    1 100 Bill Jones

    2 100 Mary Smith

    3 100 Jim Bell

    1 133 Steve Clamp

    2 133 Frank Tom

    1 200 Jane Foster

    Mail

    DealerID CustID MailID MailDate

    100 1 F22.123124 7/1/2012

    100 2 F22.123124 7/1/2012

    133 1 C16.112323 7/3/2012

    200 1 S15.434552 6/30/2012

    I am joining these 2 tables based on DealerID and CustID. The powers that be here at my office want the customer table...

Viewing 5 posts - 1 through 5 (of 5 total)