Kevin Holman has updated his article on which SQL maintenance to perform on your SQL databases to now cater for the SCOM 2012 data structures.

The article which is available here and makes special mention of the types of maintenance which is run by SCOM itself which does not need to be handled by a SQL DBA.