Forum Replies Created

Viewing 15 posts - 1 through 15 (of 36 total)

  • RE: Big SQL Tables and Growing

    CirquedeSQLeil (12/17/2009)

    novice_coder (12/17/2009)

    GilaMonster (12/17/2009)

    novice_coder (12/17/2009)

    We will probably have about 3-5 million records by the end of next year. I guess then I will have to think about partioning.

    That's not...

    December 17, 2009 at 12:45 pm

    #1093706

  • RE: Big SQL Tables and Growing

    GilaMonster (12/17/2009)

    novice_coder (12/17/2009)

    We will probably have about 3-5 million records by the end of next year. I guess then I will have to think about partioning.

    That's not a lot...

    December 17, 2009 at 12:19 pm

    #1093688

  • RE: Big SQL Tables and Growing

    Wandrag (12/16/2009)

    novice_coder (12/16/2009)

    Hello All,

    I am a beginner at Database design and need some help in managing big data table in SQL Server 2008. Right now the database has about 20...

    December 17, 2009 at 9:24 am

    #1093573

  • RE: Big SQL Tables and Growing

    Bru Medishetty (12/16/2009)

    Going by the # of rows, (5 Million a Year) is not something to worry about.

    What Apurva has suggested would be my suggestion, use database partitioning and have...

    December 16, 2009 at 8:53 pm

    #1093395

  • RE: Big SQL Tables and Growing

    Apurva (12/16/2009)

    You can consider partitioning your data on different drives. You can do partitioning by year or may be months if you want to. This way your performance will not...

    December 16, 2009 at 8:43 pm

    #1093387

  • RE: LEFT JOIN Query help

    Gianluca Sartori (8/11/2009)

    Whats the reason for putting one filter in ON cluase and the other filter in WHERE clause? why not both in ON or both in WHERE?

    If you...

    August 11, 2009 at 1:53 pm

    #1037700

  • RE: LEFT JOIN Query help

    novice_coder (8/11/2009)

    Lynn Pettis (8/11/2009)

    You could use isnull(tb.ID,0), but that still doesn't match with anything in your sample data.

    ohhh I didnt realise that changing NULL to 0 wont help either. so...

    August 11, 2009 at 1:35 pm

    #1037689

  • RE: LEFT JOIN Query help

    Lynn Pettis (8/11/2009)

    You could use isnull(tb.ID,0), but that still doesn't match with anything in your sample data.

    ohhh I didnt realise that changing NULL to 0 wont help either. so what...

    August 11, 2009 at 1:24 pm

    #1037686

  • RE: LEFT JOIN Query help

    Lynn Pettis (8/11/2009)

    Based on your sample data, the only way I see to do this is with the following code:

    select

    *

    from

    dbo.TableA ta

    ...

    August 11, 2009 at 11:20 am

    #1037617

  • RE: LEFT JOIN Query help

    Lynn Pettis (8/11/2009)

    Okay, now I'm slightly confused. One, what are your requirements? We also could use the DDL for your tables, sample data for your tables, and the...

    August 11, 2009 at 10:47 am

    #1037595

  • RE: LEFT JOIN Query help

    Lynn Pettis (8/11/2009)

    novice_coder (8/11/2009)

    Gianluca Sartori (8/11/2009)

    Add filter conditions for the main table (TableA) in the WHERE clause, then add filters for TableB in the JOIN conditions.

    SELECT *

    FROM TableA

    LEFT JOIN TableB

    ON...

    August 11, 2009 at 10:00 am

    #1037561

  • RE: LEFT JOIN Query help

    Gianluca Sartori (8/11/2009)

    Add filter conditions for the main table (TableA) in the WHERE clause, then add filters for TableB in the JOIN conditions.

    SELECT *

    FROM TableA

    LEFT JOIN TableB

    ON (TableA.ID1=TableB.ID1 AND TableA.ID2=TableB.ID2...

    August 11, 2009 at 9:04 am

    #1037495

  • RE: LEFT JOIN Query help

    novice_coder (8/11/2009)

    Hello

    I have 2 tables TableA and TableB. I want to display all the records of TableA that are not present in TableB.

    General syntax to do this is:

    SELECT *

    FROM TableA

    LEFT...

    August 11, 2009 at 8:59 am

    #1037491

  • RE: T-SQL Query help

    Thanks so much.

    Cheers

    August 6, 2009 at 9:04 am

    #1035439

  • RE: T-SQL Query help

    novice_coder (8/6/2009)

    Matt Wilhoite (8/6/2009)

    I am not sure this is what you are looking for but here it is: Let me know if you need this in a different format.

    //EDIT...

    August 6, 2009 at 8:59 am

    #1035433

Viewing 15 posts - 1 through 15 (of 36 total)