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
Posted: April 28th, 2010 under MS CRM 4.0, MS SQL Server.
Comments: none
Write a comment