This is mostly thinking based on MySQL, we'll have to change the MS SQL version accordingly.
Drop the following fields:
- #__content.title_alias It's been marked as deprecated since 1.6.0 (?).
Change the following tables to InnoDB:
- #__banners
- #__banner_clients
- #__categories
- #__contact_details