Click here to Skip to main content
15,441,757 members
Home / Discussions / Database
   

Database

 
AnswerRe: comparing tables in SQL 2008 Pin
David Mujica30-Nov-09 8:11
MemberDavid Mujica30-Nov-09 8:11 
QuestionIs it possible to update a table concurrently? (using SQL Server 2008) Pin
Rafferty Uy29-Nov-09 23:01
MemberRafferty Uy29-Nov-09 23:01 
AnswerRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
Ashfield29-Nov-09 23:09
MemberAshfield29-Nov-09 23:09 
GeneralRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
Rafferty Uy29-Nov-09 23:16
MemberRafferty Uy29-Nov-09 23:16 
GeneralRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
Ashfield30-Nov-09 0:10
MemberAshfield30-Nov-09 0:10 
GeneralRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
Rafferty Uy6-Dec-09 15:36
MemberRafferty Uy6-Dec-09 15:36 
GeneralRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
Ashfield6-Dec-09 21:01
MemberAshfield6-Dec-09 21:01 
GeneralRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
Rafferty Uy6-Dec-09 21:11
MemberRafferty Uy6-Dec-09 21:11 
I see.

Basically my test data contains a single parent with children, grand children, great grand children (up to the 6th level) totaling 1200 nodes.
2 tables are affected: The main table where the data is contained and another table which just contains the parent/child ids relationships. Only the main table is updated.

The previous code generates the tree, traverses and updates each node using a stored procedure.
I now just moved the tree generation and traversal to C# code and keep a simple stored procedure to update each data.
Then I enclosed the entire thing in a single transaction (using the SqlTransaction class).

Any comments about this?
My concern is that, since it is a single transaction... I may still experience the same problem that we currently have, which is that when the data is updating, other users who are updating data in the same SQL table are stuck until this finishes updating.


Thanks again.

Rafferty

AnswerRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
T210230-Nov-09 1:01
MemberT210230-Nov-09 1:01 
AnswerBuild a "Bulk Update" indicator Pin
David Mujica30-Nov-09 3:34
MemberDavid Mujica30-Nov-09 3:34 
AnswerRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
The Man from U.N.C.L.E.30-Nov-09 7:40
MemberThe Man from U.N.C.L.E.30-Nov-09 7:40 
AnswerRe: Is it possible to update a table concurrently? (using SQL Server 2008) Pin
Rafferty Uy30-Nov-09 15:12
MemberRafferty Uy30-Nov-09 15:12 
AnswerNow the web server (instead of the SQL server) is slow Pin
Rafferty Uy10-Dec-09 15:47
MemberRafferty Uy10-Dec-09 15:47 
QuestionDisplay Message while using Stored procedure Pin
kankeyan29-Nov-09 21:13
Memberkankeyan29-Nov-09 21:13 
AnswerRe: Display Message while using Stored procedure Pin
dan!sh 29-Nov-09 21:34
professional dan!sh 29-Nov-09 21:34 
GeneralRe: Display Message while using Stored procedure Pin
Mycroft Holmes29-Nov-09 23:03
professionalMycroft Holmes29-Nov-09 23:03 
GeneralRe: Display Message while using Stored procedure Pin
kankeyan29-Nov-09 23:40
Memberkankeyan29-Nov-09 23:40 
GeneralRe: Display Message while using Stored procedure Pin
dan!sh 29-Nov-09 23:58
professional dan!sh 29-Nov-09 23:58 
GeneralRe: Display Message while using Stored procedure Pin
Ashfield30-Nov-09 0:13
MemberAshfield30-Nov-09 0:13 
AnswerRe: Display Message while using Stored procedure Pin
Shameel29-Nov-09 23:32
professionalShameel29-Nov-09 23:32 
QuestionAccessing SQL Database From difference Client PCs. Pin
jeshra27929-Nov-09 20:24
Memberjeshra27929-Nov-09 20:24 
AnswerRe: Accessing SQL Database From difference Client PCs. Pin
T210229-Nov-09 21:36
MemberT210229-Nov-09 21:36 
AnswerRe: Accessing SQL Database From difference Client PCs. Pin
dan!sh 29-Nov-09 21:40
professional dan!sh 29-Nov-09 21:40 
QuestionRelational databases, XML, or OLAP? Pin
James Shao28-Nov-09 18:09
MemberJames Shao28-Nov-09 18:09 
AnswerRe: Relational databases, XML, or OLAP? Pin
T210228-Nov-09 23:08
MemberT210228-Nov-09 23:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.