But I didn't change the login parameters. So I don't know why is working the 1st case and why is not working the 2nd case?

What was the exact command? Can you copying it?

And the best way if you show us the execution plan of this query.

Hello,

I think your idea is great, but I have a problem with it. Your tbl_config table cannot to change dynamically. Maybe you should to store the config in...

I guessed I have to you the CROSS APPLY, but I did't know how to.
So,  thanks, I have a new pattern now 🙂

Hello,

The problem is solved.
The bulk insert was changed in SQL Server 2016.
I need to use trace flag 692 (which is introduced in SQL Server 2016).

Here is the result of sp_spaceused:

server...database_name.database_size..unallocated space
server1: <db name>.....20480.00 MB....11893.83 MB
server2: <db name>.....33408.00 MB....24551.65 MB

server...reserved......data..........index_size...unused
server1: 3549360 KB....2674104 KB....872056 KB....3200 KB

I ran this query on both servers and here are the results:

SELECT     ips.*
FROM sys.dm_db_index_physical_stats (DB_ID(),898102240,1,NULL,'DETAILED') ips
where ips.database_id = DB_ID()
order by ips.page_count


Here is the query:

SELECT
    'ServerX' as [server],
  t.NAME AS TableName,
  p.rows AS RowCounts,
    i.[name],
    i.[fill_factor],
  SUM(a.total_pages) * 8 AS TotalSpaceKB,
 ...

Additional information:
    After rebuild the UnusedSpaceKB was little (about 1000) and the UnusedSpaceKB is growing fast to 1,505,568 under SQL Server 2016. But under SQL Server 2012 is not.

Maybe this one:

;WITH cte as (
    SELECT TOP 1 'ACCTEmplyeeBillpartiallyPAid,' as string, 1 as orderby
    FROM EmplyeeCodes
    WHERE EmplyeeNumber = @EmplyeeNumber
    AND AmountRemaining > 0
    AND...

It is work fine. Thanks!

Maybe this query?

;with cte as (

select TOP (select ((MD.TotalCount*80)/100) as TotalCount from [dbo].[Message_Identifier] MD where MD.MessageID = 1141)

DMQD.SubmitDate

from [dbo]. message_queue_details

DMM DMM.MessageID = 1141

order by SubmitDate

)

select

DATEDIFF(SECOND,MIN(SubmitDate), MAX(SubmitDate)) as TimeDiff

from cte

I think,...