We have no problem with locking. We have used Quest Central SQL analysis tool to look at code effeciency, but not extensively as all programmers are busy. We need to...

Yes our ERP suite was developed for SQL Server, but I think the design is not optimal. Secondly, our programmers did not use indecies as much as would like them...