Forum Replies Created

Viewing 15 posts - 14,446 through 14,460 (of 39,970 total)

  • RE: Old Dog, New Tricks

    davidandrews13 (2/2/2012)


    isn't that just down to formatting though? the fact that the article has coloured the ColumnNames in green, which wouldn't be the case normally, just highlights it even more.

    Two...

  • RE: Old Dog, New Tricks

    Gary Varga (2/2/2012)


    Rod at work (2/2/2012)


    Semicolons will at some point be required in T-SQL? Really? I've seen it used in some cases, but am completely uncertain as to...

  • RE: Old Dog, New Tricks

    Gary Varga (2/2/2012)


    It was when I looked at the side-by-side stored procedures example that it became clear. Literally!!!

    I shall be using the = syntax moving forward. My reasoning? The intention...

  • RE: Old Dog, New Tricks

    paul s-306273 (2/2/2012)


    I've used the SELECT 1 x; format for years. (Oracle background).

    I've never found it confusing - I don't now discard that format just because somebody else finds it...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/2/2012)


    I couldn't help myself. I responded to the awkward responder. Maybe if we talk to him, he might start paying more attention to what he's doing.

    We'll see. I...

  • RE: SET option hierarchy

    Points were awarded back.

    I cut / paste the wrong way. I can't change the answer once people have answered, so I was looking to move answers around.

  • RE: INSERT OUTPUT

    BenWard (2/2/2012)


    DATE is not a valid data type... ?

    It's becoming too hard to track all the T-SQL between all versions, so I left this off. SQL 2005 is out of...

  • RE: SET option hierarchy

    My apologies. I think I selected the wrong answer when reworking things. The original answers weren't quite clear, so I altered them.

    I have fixed things, and awarded back points.

  • RE: Solid State drisk

    life is more of an issue with writes than reads. If you are using these mostly for reads, I wouldn't be as worried as if you use them with lots...

  • RE: Solid State drisk

    I tend to agree with TheSQLGuru, make sure you get enterprise grade SSDs.

  • RE: Encrypt the whole database

    TDE encrypts the data at rest, on disk, and the backups. There is CPU overhead for this.

    Encrypting the data, so that a DBA or unauthorized user who accesses the database,...

  • RE: Merge replication non convergence

    I'm not a replication expert, but all subscribers? Or certain ones?

    If I make changes to rows at the publisher with "red", "green" and "blue" values. Does the (or all) subscribers...

  • RE: Merge replication non convergence

    I'm slightly confused. You are using a lot of pronouns, and using "replica" a lot and it's not clear what you mean. I assume you mean an individual node...

  • RE: Are the posted questions getting worse?

    GSquared (2/1/2012)


    HowardW (2/1/2012)


    Is this guy annoying the hell out of anyone else?

    Not sure whether to call it spam or not, but most of his posts wouldn't pass the Turing Test.

    Looks...

  • RE: Disk Drives in the Sky

    Thanks, Mevio is having issues. I have pinged them.

Viewing 15 posts - 14,446 through 14,460 (of 39,970 total)