Deadlock issue in SQL Server -

-

i have 2 teams working in project, 1 extracting data table customer & products , other team trying view data tables. both of them performing operation simultaneously. causing deadlock. how solve issue?

use read committed snapshot isolation if using sql server 2005 , above. way readers not block writers.


Comments

Post a Comment

Popular posts from this blog

c++ - error: use of deleted function -

-
i've been working on c++ code friend has written , following error have never seen before when compiling gcc4.6: error: use of deleted function ‘gamefsm_<std::array<c, 2ul> >::hdealt::hdealt()’ implicitly deleted because default definition ill-formed: uninitialized non-static const member ‘const h_t floppokergamefsm_<std::array<c, 2ul> >::hdealt::h’ edit: comes part of code using boost msm: boost webpage edit2: there no = delete() used anywhere in sourcecode. generally speaking, error mean? should looking when type of error occurs? i don't think other answers mentioning =deleted; syntax correct. error message says default constructor has been deleted implicitly . says why: class contains non-static, const variable, not initialized default ctor. class x { const int x; }; since x::x const , must initialized -- default ctor wouldn't initialize (because it's pod type). therefore, default ctor, need define 1 (and must ...
Read more

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more

iphone - Request for member 'uitextfield' in something not a structure or union? -

-
working through several other problems have found myself @ point. have learnt alot stuff trying 1 stumped on. i writing textfield format login have on app, , because apple don't have resembling textfield mask have decided write own custom cell looks has mask on doing concatenating textfields in background. however have struck problem. trying call textfield:shouldchangecharactersinrange:replacementstring: of uitextfield in subclassed uitableviewcell outlined in code below. im receiving request member 'uitextfield' in not structure or union error... appreciated. ////.h @interface registerdeviceviewcontroller : uiviewcontroller <uitableviewdelegate, uitextfielddelegate> { registerdeviceviewcontroller *registerdeviceviewcontroller; //uitextfields registration cell uitextfield *regfieldone; uitextfield *regfieldtwo; uitextfield *regfieldthree; uitextfield *regfieldfour; uitableviewcell *myregistrationfield; uitableviewcell *my...
Read more