We write application using ColdFusion and the database is SQL server. There is a table which have a text field and this table is always be updated concurrently by 8-10 users. The db is running transactional replication.
We used the following two approaches to insert or update data:
1. <CFQuery>...
I have a Ms sql db which always bears a continuous growing transaction log. It seems that there is lots of active transaction log there because the log never drops even I manually make checkpoints. I didn't enable the 'trunc. log on chkpt.' because transactional replication is running. I think...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.