After you've row compressed the data, you can get a pretty idea for page compression using SQL's estimate:

EXEC sys.sp_estimate_data_compression_savings 'dbo', 'PlayersSets', NULL, NULL, 'PAGE'

My original code gives a result for the new data, since I purposely wrote the original code generically:

~__2019121322545101GMTOFFSET=-18000&DPT=205~__2019121408520502GMTOFFSET=-18000~__2019121409443301GMTOFFSET=-18000&DPT=242~__2019121416570802GMTOFFSET=-18000~

2019-12-14 08:52:00.000

2019-12-14 09:44:00.000

If the first two values are not the correct ones, how...

The code will just get the first two numbers, which might cause an "error" of bad data if the first two numbers don't have the datetimes you need.  Otherwise, I...

DROP TABLE IF EXISTS #data;
CREATE TABLE #data ( data varchar(4000) NULL );
INSERT INTO #data VALUES
    ('~__2019121407025301GMTOFFSET=-18000~__2019121415164202GMTOFFSET=-18000~')

SELECT data, 
    DATEADD(MINUTE, CAST(SUBSTRING(data, date1_start...

Use EXISTS() instead of a JOIN (although SQL likely already is doing the equivalent of that in the plan, it doesn't hurt to be sure).

The only other thing you could...

If you typically/most often query the table by Final_date, you need to cluster the table first on Final_date.  If  you have a column that would naturally make the index unique,...

I think you would want something more like this:

DECLARE @DestinationTableName SYSNAME = 'dbo.tableA'
,@id NVARCHAR(30)
,@ProcessName VARCHAR(100) = 'ETL_InitialLoad'
,@SQL NVARCHAR(MAX)

SELECT @SQL = 'IF NOT EXISTS (SELECT * FROM dbo.ETL_lOG...

>> will process and return a table with Say DynamicMaster with column Distance added along with respective Data <<

How, specifically, does it return a table?  Does it create a temp...

Great.  Glad it helped, and that the abbreviated way I posted it made sense.

select SAR.ENC_IDN                         ...

(1) Make sure any relevant statistics on the table are up to date.

(2) Easiest might be to add:

OPTION(RECOMPILE)

to the end of the SQL and see if it helps; iirc, SQL...

Maybe like this?:

select 
       s.MBR_NAME                ...

Or maybe just this:

SELECT CompanyName, 
    LEFT(CompanyName, EndOfWord1) AS [First Word], 
    LEFT(CompanyName, EndOfWord2) AS [First  + Second Word],
 ...

You need to look at the "Estimated" plan for the one that doesn't work, just to be sure.  See if anywhere SQL is referencing or "output"ing the restricted column.

What is the specific error message (and error number and status) you get? (Using dummy column name(s) as needed, of course).

What is the query plan?  Does it give any help...

• This reply was modified 1 year, 9 months ago by ScottPletcher.