I had a Dimension table that had over 520 columns.
The updates to the table almost ground the system to a halt due to the high number of page...

There is the undocumented (by Microsoft) command sp_MSforeachdb
You can also create a server group. If you run a query from a server group it will run...

There is a free SQL formatting tool from Apex, probably not as good as Redgate's,  but you can configure the formatting quite extensivley.
https://www.apexsql.com/sql_tools_refactor.aspx

Declare
@campus_cd nvarchar(300),
@cmpy_code nvarchar(500),
@year1 int,
@year2 int,
@period int,
@period2 int,
@batch_Id uniqueidentifier

BEGIN TRY

  BEGIN TRANSACTION;
  /*year1*/
  insert into...