VSS is still heavily used.  Most 3rd party backup software now uses VSS as it’s primary backup method.

Get a copy of WinDirStat or TreeSize, run them as administrator and see where they think the space is being used.

You may have some VSS based data which is not...

That's one of the joys of sorting strings.

You would need to strip out all the alpha data and convert the remaining numeric data to an int, then sort on that...

You can use the -d switch and pass it a database name on the SQLCMD call, which will automatically issue a use command as part of the connection.

sqlcmd -S LA...

Looks like you need to debug the issue some more.

Take the procedure/function generating this output and debug why the value is not showing.

So the equation is working inside a tablix?

The same equation is not working inside a separate text box?

As the text box is outside of the tablix and therefore dataset, you...

You would be looking at Azure Automation Accounts or things like Azure SQL Elastic Jobs.

https://techcommunity.microsoft.com/t5/azure-database-support-blog/automating-azure-sql-db-index-and-statistics-maintenance-using/ba-p/368974

I would suggest that you take the function and break it down and run things in a piecemeal fashion and verify where the issue is then.

If you have copied the...

You need to write it yourself.

If that data is static someone manually wrote a script to insert it as a one time operation into QA, it is not stored in...

It’s not going to be in the database solution as that’s your schema only.

You have the data in the QA database just copy that and convert it to an insert...

No it will be DML.

INSERT INTO dbo.auditLevyBreakdown VALUES
(row one data),
(row two data)

You would need to write a script to insert the two rows from QA copy auditLevyBreakdown into your prod copy auditLevyBreakdown table.

Or you may use the import/export data wizard instead.

OK at a guess then, on your local copy of the production data, insert the missing data as it is in the QA copy to the production copy and verify...

Well Jeff there is referring to static data.  Do you know if the data in that table is static data or is it dynamic data?

Comparing data in QA to Production...

Well you shouldn't compare data in QA to data in Production, the two data sets will be entirely different, also you shouldn't have production data in any other environment than...