Unfortunately, the only sizing information you provided was a raw number, without any kind of qualification as to whether those numbers represented kilobytes, megabytes, gigabytes, or terabytes.   You also made...

There's no obvious date field that would represent the date for which the retrieved values occurred on.   Without that being detailed, and a good idea of exactly how all the...

Take a good look here:    https://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx

You'll have to provide more details.   The feature in SQL Server is known as FULL TEXT SEARCH.  I don't know that it was ever designed to look at the entire...

How about something like this:
CREATE TABLE dbo.orders (
    OrderID int NOT NULL,
    CustomerID varchar(5) NOT NULL,
    sourceid varchar(12) NOT NULL,
    [Status] varchar(50) NULL,
    ordertype varchar(20) NULL,
    ordershipped datetime NULL,

That...

Let's try using a string splitting function "DelimitedSplit8K" to do the heavy lifting:
CREATE TABLE #Weights (
    WeightID int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
    TotalWeight varchar(20)
);
INSERT INTO...

The only thing I can think of is maybe something OS - related ???   I'm just thinking that Windows Server 2012 might not have had that same issue...   Of course,...

That doesn't answer the question.   Was there a change in Edition.   That's a PART of your SQL Server version.   For example, you can get SQL Server Standard Edition, or SQL...

Read my last post again.   It DOES provide a recommended way.   You DO have to do some of this work yourself, you know...

Was there a change in Edition ?