Welcome to the blog of mechanised.com

This blog is mainly a technical repository of information on Virtualisation tools and management for our hosting service.

Also for HP's Bladesystem that we use at both our datacentres.

Other articles are also included on .Net development and MS SQL Server as well as other interesting things we come across.

Friday 9 January 2015

vCentre tidying of SQL

A few handy queries to tidy up old records to keep the database size down.

delete from vpx_text_array
where not exists(select 1 from vpx_entity where id=vpx_text_array.mo_id);

This removes old information about operations involving entities that don't exist anymore.