Click here to Skip to main content
15,893,622 members

Comments by Sumit_Kumar_Sinha (Top 62 by date)

Sumit_Kumar_Sinha 16-Mar-15 3:29am View    
Suppose, i have a query and it's taking aroung 70 second to complete a transaction but inmean while other users reqeusted 10-15 request to complete transaction on same table. After 70 sec, all other transction executed succesfully but i got 3-4 deadlock error.
Sumit_Kumar_Sinha 16-Mar-15 3:14am View    
For Example, I have a table Test. It contains all the information realted to each and every transaction. This table is used by all the employee. Suppose, when i am trying to fetch records from this table and same time some other transaction (Insert, update or delte) is in pogress. Then nolock will not provide exact records from this table. Thats why i am looking for some other way to select records. I have already used nowait, setlocktimeout, nolock, readcommited but it's not giving me correct details.
Sumit_Kumar_Sinha 16-Mar-15 2:42am View    
It's not interview question. I am trying to fix this issue in my application
Sumit_Kumar_Sinha 15-Mar-13 9:00am View    
you can use remov dash(-) and then simply compare the value of textbox1 and textbox2
Sumit_Kumar_Sinha 15-Mar-13 8:54am View    
you are maintaing viewstate for asp.net control, and what is meaning of different events.