to prevent lock records in CRM, DBA allow to define all database to work with no-lock and we have another option to request fetch with no lock.
Example:
Enjoy,
Rami Heleg
Thursday, May 21, 2015
Implement nolock in Fetch
By default SQL server defined to lock records when execute query and rows selected until finish to execute.. problem when we have many records.
to prevent lock records in CRM, DBA allow to define all database to work with no-lock and we have another option to request fetch with no lock.
Example:
Enjoy,
Rami Heleg
to prevent lock records in CRM, DBA allow to define all database to work with no-lock and we have another option to request fetch with no lock.
Example:
Enjoy,
Rami Heleg
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment