I have to go with the 'calculation is wrong' group.  While the integer vs decimal part is also a problem, the first and foremost problem is the calculation is dead...

Since the question begins with : 
I have a table with a PK that is also the clustered index. I added this PK with the following code:
It...

Per MSFT documentation:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-tracestatus-transact-sql

In SQL Server, there are two types of trace flags: session and global. Session trace flags are active for a connection and are...

I CALL FOUL - the only correct answer to this should begin with 'It depends'. The CMS CAN be part of the server list by using the FQDN...