127 reputation
6
bio website l46kok.blogspot.com
location Seoul, South Korea
age 26
visits member for 1 year, 9 months
seen yesterday

Just an average joe coder for now.

Aspiring to be one of the greatest developers ever.

It never hurts to dream.

Interests in:


Apr
17
revised Can comments in stored procedures cause problems
added 60 characters in body
Apr
17
comment Can comments in stored procedures cause problems
Oh woops. That was a mistake on my part. The code is supposed to be the same but I miscopied them.
Apr
16
revised Can comments in stored procedures cause problems
added 53 characters in body
Apr
16
asked Can comments in stored procedures cause problems
Feb
14
accepted DB Locks - How would one handle long transactions and maintain high concurrency?
Feb
13
comment DB Locks - How would one handle long transactions and maintain high concurrency?
One more question, I don't really follow when you say "It may be possible to open a transaction and commit after each row". Our program requirement is that should any error occur during the batch placement of orders, all of the work including previous successful ones should be rollbacked to initial state. Is there some function in SQL Server I'm not aware of that achieves this functionality while having transactions open only on individual rows?
Feb
13
comment DB Locks - How would one handle long transactions and maintain high concurrency?
Thanks for the answer. One question though: the validation process mostly involves reads from other tables, and since data integrity is very important in this operation (I.E: We need to prevent negative stocks). Unless if I'm assuming wrong, shouldn't the validation process be in the transaction to prevent dirty data from being read?
Feb
13
asked DB Locks - How would one handle long transactions and maintain high concurrency?
Aug
27
awarded  Quorum
Aug
25
awarded  Editor
Aug
25
revised Use surrogate or natural PK if a row is uniquely identified by two or more columns?
added 1 characters in body
Aug
24
accepted Use surrogate or natural PK if a row is uniquely identified by two or more columns?
Aug
20
asked Use surrogate or natural PK if a row is uniquely identified by two or more columns?
Mar
5
awarded  Autobiographer
Jan
25
awarded  Scholar
Jan
25
awarded  Supporter
Jan
25
accepted What is a proper way to handle a “sequence number” like field?
Jan
23
awarded  Student
Jan
22
asked What is a proper way to handle a “sequence number” like field?