In the execution plan, are you getting any extra memory grants or spills to tempdb or anything?  I expect that something is different somewhere.

And I believe you; I've seen weird...

That is very strange.  Can you post the execution plan?  If not, I'd start by examining that.

My understanding is that comments SHOULD be stripped out when it gets to the...

Step 1 is going to be to upgrade your SQL Server unfortunately.

https://social.technet.microsoft.com/Forums/en-US/4fdede66-c47e-4c88-8e39-4f63dad29a03/can-you-install-sql-server-2008-on-windows-10

SQL Server 2008 and 2008 R2 are not supported on Windows 10 or Windows Server 2016.

IF the SQL...

The (admittedly obscure!) intention of my post was not to criticize your response, but to highlight the fact that in making things dynamic, SSIS slides out of the equation....

That is true that it doesn't relate to SSIS directly.  My intent with the post was to determine what the end result was and if SSIS could handle it well.

You...

It also depends on how "full" your database is.  A 400 GB database file that has 1 MB in use will compress most of that.  We have a database that...

This sounds like it could be handled by linked servers and some dynamic SQL and some fun stored procedures to gather all of the schema level data and compare it...

My opinion, overall SSIS is nice and easy to work with.  Has a bit of a learning curve and I think as long as you aren't trying to do anything...

That sounds like a pretty easy task:

WITH cte AS (
SELECT [RANGE], [STATUS], LAG([DATE]) OVER (PARTITION BY [ID] ORDER BY [RANGE]) AS [PrevDATE]
FROM <table name>
)
UPDATE [cte]
SET [STATUS]='Y'
WHERE [RANGE]='001'...

• This reply was modified 6 years, 2 months ago by Mr. Brian Gale. Reason: Code cleanup - was pulling data that is never used

My recommendation would be to try it out.  You are licensed for it; give it a shot.

Build up a proof of concept data migration and compare it to the C#...

I have only had budget laptops with upgraded parts (such as an upgraded drive).

My HP Envy was problematic from day 1.  Had a stuck pixel.  Got it returned under warranty...

My next thought on things to check would be the IIS logs.  If the PBI logs look fine, it is likely something in your IIS logs.

As a random guess (as...

The resulting data type in your calculation is Numeric. I am thinking it is probably a floating point precision error that is giving you a near but slightly lower than...

That really depends on what you are trying to do.  If it was me, and just guessing based on a lot of the variable names and trying to eyeball that...

What about something like this on your last query:

DECLARE
    @i_from_date DATE = '2019-10-10'
    , @i_to_date DATE = '2019-10-10';

WITH [object_changes]
AS
  ...