Click here to Skip to main content
15,907,679 members

Comments by Jörgen Andersson (Top 200 by date)

Jörgen Andersson 3-Feb-23 8:09am View    
What's the error?
Jörgen Andersson 17-Jan-23 8:16am View    
Are those values comma separated numbers or numbers with decimal comma?
Jörgen Andersson 22-Dec-22 9:26am View    
I checked, the lock escalation goes from row locks to page locks.
So if two processes have locked rows in the same index and page and both tries to escalate you will in worst case get a deadlock, and otherwise the process that tries to lock last will have to wait, and therefore timeout.
Jörgen Andersson 22-Dec-22 9:23am View    
In my experience the Batch size is more about kB than rows. Except for the lock escalation limit of 5000 rows.
Jörgen Andersson 26-Nov-21 5:13am View    
No worries, it was just unclear to me whether the six stages affected each other or not and therefore needed to be added sequentially.
Or if they only needed to look in the backup for earlier inserts