I created a nice SQL query today to show the number of records in each table in a database and the space it takes in the database in megabytes.

Very handy to see why some MS CRM databases are so big.

Posted: May 19th, 2010 under MS CRM 4.0, MS SQL Server.
Comments: none

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