Forum Replies Created

Viewing 15 posts - 166 through 180 (of 552 total)

  • RE: Phantoms and isolation

    TomThomson (8/18/2014)


    There are cases where READ UNCOMMITTED isolation level is acceptable: the obvious case is the case where you know for certain, perhaps because a ban on certain actions...

  • RE: Phantoms and isolation

    Thank you, Hugo, for all the in depth details and for your time. This is very helpful.

    Hugo Kornelis (8/18/2014)


    Those who know the potential risks of NOLOCK and still use it,...

  • RE: Phantoms and isolation

    Hugo Kornelis (8/18/2014)


    Raghavendra Mudugal (8/18/2014)


    say we use nolock and it reads dirty and executes the select statement faster, now how to achieve the same speed without using nolock?

    That's the wrong...

  • RE: Virtual Machines

    SQLRNNR (8/18/2014)


    TomThomson (8/18/2014)


    Oh dear! "all Hardware"???

    Soundcard? Joystick? USB devices?

    Or am I answering the wrong question?

    See this MSDN library page.

    Or am I just a couple of...

  • RE: Virtual Machines

    kostaskopelli (8/18/2014)


    VMs can be spread across disks and usually not all resources such as printers and other devices are shared.

    .

    In generally speaking, if you use VirtualBox, each VM has...

  • RE: Virtual Machines

    robertjtjones (8/18/2014)


    Nice start for a Monday - out of interest what are people's thoughts on running MSSQL on a Virtual Machine?

    I've met a lot of resistance to the idea and...

  • RE: Phantoms and isolation

    Hany Helmy (8/17/2014)


    Raghavendra Mudugal (8/15/2014)


    Thank you Tom, very interesting one.

    (I used only READ UNCOMMITTED, and others I have just read them but never had any practical experience on them, so...

  • RE: Which query will give an error?

    SQLRNNR (8/15/2014)


    sestell1 (8/15/2014)


    XML... yuck. :sick: :laugh:

    +1

    hmmm... interesting...

    I know the feeling of "yuck"... but never used with "xml"... so out of curiosity anybody care to shed some light...

  • RE: Which query will give an error?

    Thank you for the post, Vimal, good one.

  • RE: Phantoms and isolation

    Thank you Tom, very interesting one.

    (I used only READ UNCOMMITTED, and others I have just read them but never had any practical experience on them, so had really no idea...

  • RE: Implicit transaction mode

    Cliff Jones (8/12/2014)


    Hugo Kornelis (8/12/2014)


    It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is...

  • RE: Implicit transaction mode

    Cliff Jones (8/12/2014)


    Raghavendra Mudugal (8/12/2014)


    TomThomson (8/12/2014)


    Stewart "Arturius" Campbell (8/12/2014)


    Good question, thanks Hugo

    ....

    hmm "Hugo"?

    Yes, today's email stated that it was Hugo's question for some reason.

    subject of the email is "Data Mining:...

  • RE: Implicit transaction mode

    TomThomson (8/12/2014)


    Stewart "Arturius" Campbell (8/12/2014)


    Good question, thanks Hugo

    ....

    hmm "Hugo"?

  • RE: Implicit transaction mode

    SqlMel (8/12/2014)


    +1. Thanks.

    By the way, this also works the same in 2008 R2.

    +1

    (I have started a new thing ... testing each code block of the qtod from sql...

  • RE: In-line variable assignment 2

    Thank you for the post, Hugo, good one.

    (so simple... declaration takes precedence of value assignment, even though it is in-line)

Viewing 15 posts - 166 through 180 (of 552 total)