SQL Server Hints – thoughts by David Lean

Posted: 15th October 2013 by ionu in General
Tags: , , ,
2

As a customer has just specifically requested me to “Check – No locks on tables’ join while processing data”, outlet iphone xs case online and as a few previous projects I’ve worked on had a lot of “WITH (NOLOCK)” ‘s scattered all over the place,

  1. Cristian Galatan says:
    July 15, 2013 at 3:39 pm

    In fond ai de ales intre posibilitatea foarte mica de a citii niste date gresite/vechi sau de a bloca N sisteme din cauza ca joinul tau poate este costisitor ca si timp si faci lock.

    Depinde de caz, nu e intotdeauna o alegere usoara :)

    Reply
  2. ionu says:
    July 15, 2013 at 4:14 pm

    Depinde daca e vorba de date importante sau nu. Cum scrie si in post: daca vrei sa numeri “aproximativ” ceva, it’s okay. Daca vrei sa faci calcule financiare, nu-i tocmai recomandat, as crede :)

    Reply