Forum Replies Created

Viewing 5 posts - 61 through 65 (of 65 total)

  • RE: Last run date

    happycat59 (5/6/2012)

    I doubt that basing your extraction criteria on the date/time of the last time you extracted data is going to give you the correct result. You really need...

    May 8, 2012 at 10:54 am

    #1484666

  • RE: Truncate Log Files

    Lynn Pettis (5/2/2012)

    The only way to manage the transaction log when using the BULK_LOGGED and FULL recovery models is to run regular transaction log backups.

    Thanks Lynn. School me...

    May 2, 2012 at 12:36 pm

    #1482623

  • RE: Null values with unique key constraint

    GilaMonster (2/6/2012)

    The usual trick is a unique filtered index.

    CREATE UNIQUE INDEX <index name> ON <table name>(<column name>)

    WHERE <Column name> IS NOT NULL

    Uniqueness only enforced over the non-null portion of the...

    February 6, 2012 at 10:30 am

    #1443307

  • RE: Max Value from 3 columns

    Thank You so much. This is neat. I was going bonkers with #temp tables. Though it served the purpose, its not as efficient as this one is.

    February 2, 2012 at 2:35 am

    #1441624

  • RE: joins

    Thank You much. that makes sense.

    January 31, 2012 at 1:34 am

    #1440392

Viewing 5 posts - 61 through 65 (of 65 total)