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

    CustIDDealerIDFirstLast

    1100BillJones

    2100Mary Smith

    3100JimBell

    1133SteveClamp

    2133FrankTom

    1200JaneFoster

    Mail

    DealerIDCustIDMailIDMailDate

    1001F22.1231247/1/2012

    1002F22.1231247/1/2012

    1331C16.1123237/3/2012

    2001S15.4345526/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)