Thanks a lot. I will read about "Read-ahead"

This kind of info I need to make a wise choice!

 

 

yes the files are in a storage system.

Sorry for not bring any info about the storage, the reason is i havent access to it.

if you tell me what info helps...

Seraj Alam-256815 (3/26/2013)

---

If you want a workaround, here it is.

Add a column Filler char(4000). you said there are few rows, should not be overhead.

create clusterd index on Reque_pa(CEREQ).

Enjoy!

Sreaj Alam

SQL DBA,...

GilaMonster (3/26/2013)

---

You're selecting, then updating the table with a...

Thanks a lot. I tested your code, I had never thought of it that way.

Coming back to my first problem.

If I execute this query (see I update cereq=1)

use desarrollo

begin...

Hello, this is the code of the transaction.

BEGIN TRANSACTION

SELECT * FROM Reque_pa WITH (UPDLOCK) WHERE EMPRE=1 AND CEREQ = 1

UPDATE Reque_pa SET Proximo=107918, Pendiente=0 WHERE EMPRE=1 AND CEREQ=1

SELECT @@ROWCOUNT...

Sorry 😛 tomorrow when i'm at work i'll post all the code.

thanks for all your help and patience :-D!!!

Lynn Pettis (3/25/2013)

---

abitguru (3/25/2013)

---

Thanks so much guys, sorry if I dont put real code, I dont understand it..

I will try Lynn solution, and see if it "fits".

I will post real...

Thanks so much guys, sorry if I dont put real code, I dont understand it..

I will try Lynn solution, and see if it "fits".

I will post real code of the...

GilaMonster (3/25/2013)

---

abitguru (3/25/2013)

---

Right now I use updlock hint, but this makes a page lock and locks other rows that I dont want to be locked. (others rows that can be...

This is all process,

to numerate I select by parameter to use by fields cereq and use the field proximo to get next number,

insert using number get from previuos query

add...

Lynn Pettis (3/25/2013)

---

Nope, still no actual explaination as to how these parameters are used or updated. Just keep repeating what it is you want to do even if it...

Lowell (3/25/2013)

---

abitguru (3/25/2013)

---

Thanks Lynn!!!

Several post later I explain what I'm try to do. 😛

I understand what you say about bottleneck, but I have no option (in my knowleage :-P)....

Lynn Pettis (3/25/2013)

---

abitguru (3/25/2013)

---

Lynn Pettis (3/25/2013)

---

Actually, I don't think you do. Instead of working to keep others from reading/updating a particular parameter row (again, not sure how you are...

Lynn Pettis (3/25/2013)

---

Actually, I don't think you do. Instead of working to keep others from reading/updating a particular parameter row (again, not sure how you are using this), you...