Customization and programming tricks by Ronny Van der Snickt

MS SQL Server

Show the number of records and space for each database table.

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.

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