Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 7,484 total)

  • RE: Today's Random Word!

    SQLRNNR (2/13/2012)


    crookj (2/10/2012)


    Daniel Bowlin (2/10/2012)


    ache

    Achy Breaky

    Heart

    Mimsy

  • RE: Read Uncommitted, locks, and transactions

    Great question, very well presented.

    In the bad old days of SQL 2000 I used to solve this sort of problem using sp_rename.

    Something like

    if exists (select * from sys.objects where...

  • RE: Deadlock

    Simon Liddle (2/13/2012)


    L' Eomot Inversé (2/9/2012)


    I wonder what SQL Server does about victim selection when all processes involved have the same deadlock priority (which will be most of the time,...

  • RE: HASHBYTES

    cengland0 (2/10/2012)


    Generally companies require you to change your passwords every 30, 60, or 90 days so a brute force doesn't work in these cases either.

    Two points here: The companies which...

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (2/9/2012)


    Wine, beer ugh. Give me good old Kentucky Burbon on the rocks ,, no water no soda .. now that is a drink fit for the Gods

    Now "old...

  • RE: Are the posted questions getting worse?

    MysteryJimbo (2/9/2012)


    HowardW (2/9/2012)


    MysteryJimbo (2/9/2012)


    Interesting fact: Historically, it used to be in the UK that people drank more beer than water as it was sterile and the water was contaminated. ...

  • RE: HASHBYTES

    Nadrek (2/9/2012)[hr1) Salt with a long salt that, for each row, is independently created by a cryptographic random number generator (I recommend at least 64 bits) and stored cleartext.

    I would...

  • RE: HASHBYTES

    Daniel Bowlin (2/9/2012)


    Interesting question, and an interesting bit of reading. However

    That quote comes from a section in whch the topic is encryption and encrypted data; SQL Server encryption always...

  • RE: HASHBYTES

    Thomas Abraham (2/9/2012)


    Thanks for the question. Hoever, I got it wrong because I used this source:

    http://msdn.microsoft.com/en-us/library/cc837966(SQL.100).aspx

    which says:

    "It is not possible to specify the salt value in SQL Server."

    Can someone please...

  • RE: HASHBYTES

    I hope no-one who reads that thread gets confused and is infected by this crazy notion that Hashbytes does internal salting! ...

  • RE: SQL Agent Roles

    Nice straightforward question and answer.

    Chris Harshman (2/7/2012)


    [RANT] Nothing wrong with the question or answer, but I do have a comment on Microsoft's implementation of SQL Agent security. In typical...

  • RE: Deadlock

    Thanks for the nice question.

    I wonder what SQL Server does about victim selection when all processes involved have the same deadlock priority (which will be most of the time, I...

  • RE: HASHBYTES

    Nice question.

    Stewart "Arturius" Campbell (2/9/2012)


    One would expect MS to allow an optional parameter for salt to the HASHBYTES function...

    Or maybe not - unless perhaps they also provided a parameter to...

  • RE: TRUNCATE TABLE and ROLLBACK TRAN

    GilaMonster (2/6/2012)


    Is it bad form, if you create a QotD, to list your own article as a reference?

    depends who does it. It won't be bad form if you do...

  • RE: Are the posted questions getting worse?

    Sean Lange (2/8/2012)


    LutzM (2/7/2012)


    The reason for a temperature beyond a "frozen mug" is simple: taste. I don't want to go deeper into details (not starting a "taste war" here) but...

Viewing 15 posts - 4,831 through 4,845 (of 7,484 total)