Forum Replies Created

Viewing 10 posts - 616 through 626 (of 626 total)

  • RE: Wrong Index Used

    I have to control over that query...I'm not any happier about it either.

    ...and yes it is dynamically created.

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 12, 2012 at 12:15 pm

    #1536863

  • RE: Wrong Index Used

    Attached requested files...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 12, 2012 at 8:42 am

    #1536748

  • RE: Keeping at table lean and highly available

    That's a very good point...I appreciate all the input. I'll carefully consider both options and test them out.

    Thanks

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 2:01 pm

    #1504216

  • RE: Keeping at table lean and highly available

    Michael Valentine Jones (6/21/2012)

    In conjunction with this, they could have the web application query the table using the snapshot isolation level (or set the database to read committed snapshot) so...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 1:45 pm

    #1504205

  • RE: Keeping at table lean and highly available

    Well I think I might have it conceptually. Just starting to code it right now...I'll post the final result if everything checks out.

    Just create a partition function on two...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 1:34 pm

    #1504199

  • RE: Keeping at table lean and highly available

    Sorry one more question if I may.

    What would be the best stategy for creating a new partition on the main table in such a way that I would not have...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 12:43 pm

    #1504155

  • RE: Keeping at table lean and highly available

    Even better...that's fantastic Gila.

    Thank You

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 11:42 am

    #1504121

  • RE: Keeping at table lean and highly available

    Hmmmm...just quickly reading over msdn articles on switching it seems you can only switch a partition with an empty one. So then I would see it as a three...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 11:22 am

    #1504110

  • RE: Keeping at table lean and highly available

    GilaMonster (6/21/2012)

    This actually sounds like a case for partitioning. Partition the main table, make sure the staging table is identical (indexes, constraints, columns, etc) then to move the data from...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 11:12 am

    #1504099

  • RE: Keeping at table lean and highly available

    Yes, I am using Enterprise edition. Partitioning is not something I have yet experimented with but that sounds like a great solution. Thanks for the idea.

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2012 at 11:04 am

    #1504091

Viewing 10 posts - 616 through 626 (of 626 total)