I have a table in an SQL database. It has 100000 records in it so is not huge.
If I run an update on it e.g update table set column1 = 0 it can take ages and the users notice a huge difference i.e. the system slows down. If however I restart SQL server and run it, it only takes a second or 2. This leads me to think that something is locking the records or something like that and that the restart clears theses locks. Does this make sense and is there something I can run to clear locks.
It might be worth noting that the users are using MSAccess front end. I use ADO