I can think of a few reasons for this, but could you post your full query?

I am not sure if it is that I am running that DMV wrong, but...

As far as I know, that should work as long as you are not wiping the disk when you go from 7 to 10.  If you wipe the disk, you...

I think what you are looking for is something similar to this website:

https://key2consulting.com/how-to-execute-and-store-transact-sql-t-sql-queries-results-in-a-powershell-array/

Basically, you create the objects then throw a query at it.  After getting the result, store it somewhere...

A nice easy question once you know where to look.  Have a look at the table sys.objects for that.

The [name] column shows you the name of the object, the [type_desc]...

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 5 years, 10 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...