Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/12/2011)

    Steve Jones - SSC Editor (1/12/2011)

    Alvin Ramard (1/12/2011)

    Koen (da-zero) (1/12/2011)

    Alvin Ramard (1/12/2011)

    Canada's the backawards neighbour? I think someone got it backwards. 😎

    Hey, don't shoot the messenger...

    January 12, 2011 at 10:28 am

    #1272486

  • RE: Are the posted questions getting worse?

    GilaMonster (1/10/2011)

    Am looking for proof-reader for article on reasons for transaction log space not being reused. Any takers?

    I'll proofread.

    January 10, 2011 at 8:34 am

    #1271443

  • RE: Are the posted questions getting worse?

    Tom.Thomson (1/10/2011)

    Craig Farrell (1/9/2011)

    GilaMonster (1/9/2011)

    Craig Farrell (1/9/2011)

    If the USA isn't the center of the world, why does it seem like a lot of people keep gravitating to it?

    Very bad joke...

    January 10, 2011 at 8:21 am

    #1271428

  • RE: Are the posted questions getting worse?

    GSquared (1/7/2011)

    Brandie Tarvin (1/7/2011)

    GSquared (1/7/2011)

    The Mayan calendar notation uses powers of 20, and is infinitely extensible by adding more digits to the leading edge. It starts with a particular...

    January 7, 2011 at 8:02 am

    #1270682

  • RE: Are the posted questions getting worse?

    Thanks to all this talk of 0 as numerator and denominator I've had a song running through my head for hours.

    Nothin' from Nothin' leaves Nothin'.

    I'd love to see a version...

    January 6, 2011 at 1:52 pm

    #1270315

  • RE: Are the posted questions getting worse?

    GSquared (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough...

    January 5, 2011 at 10:29 am

    #1269628

  • RE: Are the posted questions getting worse?

    Trey Staker (1/5/2011)

    They're doing some remodeling in our office and decided to get rid of a storage closet to make room for more offices. I was asked to make...

    January 5, 2011 at 9:06 am

    #1269575

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/4/2011)

    Oh. Hey, let's use that as a springboard.

    What types of articles do you like best? The kind that are most "talk" and little code, the kind that...

    January 4, 2011 at 9:00 am

    #1269043

  • RE: Number of Instances and databases recommended my Microsoft

    sqldba_icon (12/30/2010)

    Thanks everyone. These 100 dbs are identical schema wise. We do not have a DR so we will be implementing 2 node active-active cluster for local HA.

    May I ask...

    December 30, 2010 at 2:40 pm

    #1267963

  • RE: Repetitive Indexes

    Thanks Gail, thanks everyone who replied. After reading this thread and many of the links I added some new indexes to 2 tables and a query that had been taking...

    December 30, 2010 at 1:02 pm

    #1267915

  • RE: Repetitive Indexes

    Eric Russell 13013 (12/30/2010)

    Stefan Krzywicki (12/30/2010)

    Yeah, I do need to get around to buying that DMV book I've been meaning to get. I was just waiting for it to be...

    December 30, 2010 at 1:00 pm

    #1267914

  • RE: Repetitive Indexes

    Eric Russell 13013 (12/30/2010)

    Index 1: CafeNumber, BusinessDate

    Index 2: BusinessDate, CafeNumber, DField

    Index 3: id, BusinessDate, CafeNumber, PosNumber

    There is a reason for multiple indexes. For example, if a reporting type query only...

    December 30, 2010 at 12:46 pm

    #1267907

  • RE: Repetitive Indexes

    GilaMonster (12/30/2010)

    Stefan Krzywicki (12/30/2010)

    Does this only apply to WHERE or does it also apply to ON?

    Applies to both (kinda).

    If I have two tables joined thusly

    ON A.CafeNumber = B.CafeNumber

    AND A.PosNumber =...

    December 30, 2010 at 12:44 pm

    #1267905

  • RE: Repetitive Indexes

    GilaMonster (12/30/2010)

    Stefan Krzywicki (12/30/2010)

    I was afraid of that about the column order. I didn't realize it was quite as drastic as that, where the second column isn't used if alone....

    December 30, 2010 at 11:59 am

    #1267870

  • RE: Repetitive Indexes

    GilaMonster (12/30/2010)

    Stefan Krzywicki (12/30/2010)

    PosNumber is a subset of CafeNumber and is tightly linked to it.

    I'm thinking I can just make one Index with the fields

    BusinessDate, CafeNumber, PosNumber, DField

    and be done...

    December 30, 2010 at 11:56 am

    #1267865

Viewing 15 posts - 2,221 through 2,235 (of 2,838 total)