Customization and programming tricks by Ronny Van der Snickt

Archive for April, 2010

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

Show subordinate records after merging accounts

First create an IFrame on your form, this will contain the associated view. In my case I’m using the account entity.
Read more »