Forum Replies Created

Viewing 15 posts - 2,191 through 2,205 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/17/2014)


    So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support, I'd be appreciative.

    Were it not for the total...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/14/2014)


    Sometimes advice on a blog still scares me. Not often, but sometimes. Like today

    Consider using a RAMDisk for Index filegroups.

    Putting non-clustered indexes on a RAMDisk...

  • RE: Parameters may improve SQL Backup Performance in SQL Server 2008

    Interesting question, but I hope it doesn't encourage anyone to use these options without extreme care. Letting SQL Server pick the values according to the number and type of...

  • RE: Case statement in the where condition

    where @parameter = 'All'

    or (@parameter = 'GT30' and updated_date < getdate() - 30)

    or (@parameter = 'LT30' and updated_date between...

  • RE: Which type of Numbers?

    Fun question. Utterly horrible code for people to understand, which is always interesting. And a few lessons to be learnt here.

    Sean Lange (9/16/2014)


    Sean Pearce (9/16/2014)


    And this relates to...

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/16/2014)


    Of course, it all depends on what you're smoking.

    Indeed? :hehe:

  • RE: Today's Random Word!

    Ed Wagner (9/16/2014)


    SQLRNNR (9/16/2014)


    crookj (9/16/2014)


    Ed Wagner (9/16/2014)


    djj (9/16/2014)


    BWFC (9/16/2014)


    TomThomson (9/15/2014)


    eccentricDBA (9/15/2014)


    whereisSQL? (9/15/2014)


    djj (9/15/2014)


    SQLRNNR (9/15/2014)


    capacity

    Maximum

    Overflow

    buffer

    cushion

    Pillow

    Sleep

    Relaxation

    Siesta

    essential

    Required

    mandatory

  • RE: Truncate table query

    GilaMonster (9/15/2014)


    TomThomson (9/15/2014)


    replication replicates DML statements, and DDL statements on replicated objects are either forbidden or have special forms and/or restrictions.

    It's got better. Alter table replicates now. Drop table...

  • RE: Are the posted questions getting worse?

    Gazareth (9/15/2014)


    GilaMonster (9/14/2014)


    Sometimes advice on a blog still scares me. Not often, but sometimes. Like today

    Consider using a RAMDisk for Index filegroups.

    Putting non-clustered indexes on a...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/12/2014)


    Ed Wagner (9/12/2014)


    GilaMonster (9/12/2014)


    Lynn Pettis (9/12/2014)


    SQLRNNR (9/12/2014)


    I invoke the barge pole rule.

    2nd that. Does the motion pass??

    Motion passes with no objections.

    Without objection, it is so...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/15/2014)


    It's not the cost that is the concern. It's the durability. If the RAMDisk doesn't write back to durable storage before the server shuts down (ie, uncontrolled shutdown), the...

  • RE: Page Compression

    crussell-931424 (9/15/2014)


    I've never heard of postfix compression.

    Then find yourself a good textbook on the evolution of present tense plural verb endings in Romance languages and read it. You'll find...

  • RE: Today's Random Word!

    eccentricDBA (9/15/2014)


    whereisSQL? (9/15/2014)


    djj (9/15/2014)


    SQLRNNR (9/15/2014)


    capacity

    Maximum

    Overflow

    buffer

    cushion

  • RE: Truncate table query

    GilaMonster (9/12/2014)


    It is also true that Truncate cannot be used on a table that's marked for replication. That's a limitation of replication though.

    It's a particular case of a more general...

  • RE: Using COALESCE and also trying to multiply and divide

    Jeff Moden (9/13/2014)


    I do have problems making developers understand such things so I invented the much simpler "DBPC" form of normalization. I simply explain that if I have to...

Viewing 15 posts - 2,191 through 2,205 (of 7,484 total)