Forum Replies Created

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

  • RE: Finding count in a resultset

    I was obviously not clear about my question, I'm sorry about that. Here's a more complete data about what I'd like to achieve:

    There're two tables. It's about tests created by...

    June 20, 2008 at 1:40 am

    #831543

  • RE: Finding count in a resultset

    Michael Earl (6/19/2008)

    SELECT Col1, Col2, COUNT(*)

    FROM X

    GROUP BY Col1, Col2

    Thanks but this just adds "1" column to the results, like:

    1 Name1 1

    1 Name1 1

    1 Name1 1

    2 Name1 1

    2 Name2 1

    June 19, 2008 at 7:52 am

    #831109

  • RE: Question about considering scaling while designing

    Michael Earl (5/15/2008)

    You could use mirroring for DR, but my preference would be to use an Active/Passive cluster.

    The option to use - including the option of using partitioning is going...

    May 15, 2008 at 7:37 am

    #815866

  • RE: Question about considering scaling while designing

    Michael Earl (5/14/2008)

    It is hard to say what you should be considering without knowing what you system will be doing.

    I'm thinking of doing mirroring and horizontal table partitioning. As for...

    May 15, 2008 at 1:51 am

    #815674

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