Customization and programming tricks by Ronny Van der Snickt

My biggest SQL transaction ever.

I just performed my biggest SQL transaction ever.

I had to delete 100 million DuplicateRecordBase records in de CRM database (More info)

 select count(*) from DuplicateRecordBase

 

I used the following SQL because using the delete statement filled up the hard disk and would have taken ages.

truncate table DuplicateRecordBase

Duplicate Detection Task Completion Template

After installing MS CRM 4.0 and testing out the duplicate detection, we noticed that the link in the email, that is send after the duplicate detection has been completed, was wrong. The link looked fine but was not pointing to the server. We changed the email template ‘Duplicate Detection Task Completion Template’ and tested it again.

Read more »