This should sort the output by SECTION (header first) and then my [MyPKCol] - a column(s) from your actual table so that the individual data rows are ordered. You...

The problem is your header record...if you don't have an ORDER BY on the query then that row could be returned by SQL Server as the first row, the last...

This has a p

I thought about doing a new Row 1 with just these items and then filling in the following columns with empty data and then...

That is why I asked how you are doing this now...it seems you are using the import/export wizard, or you used that and saved the package.

@JeffModen probably has a set...

What process are you using to create this file?  Is it an SSIS package - BCP output - Powershell - something else?  It really depends on how you are building...

You don't have to delete the database on the secondary - you can recover the database and then restore.

1. Remove DB from AG
2. Perform maintenance tasks on primary
3. Recover database...

This might help: https://docs.microsoft.com/en-us/sql/relational-databases/performance/specify-query-parameterization-behavior-by-using-plan-guides?view=sql-server-ver15

But - research and test fully on your system.

Also - take a look at the setting 'Optimize for ad-hoc workloads'.  This might also be an option.

First things first - you should review this document: https://www.brentozar.com/archive/2014/06/trace-flags-1117-1118-tempdb-configuration/.  If you are on a version lower than 2016 then you might want to enable the trace flags so auto growth...

It isn't clear what you are asking - what does moving from server A to server B have to do with availability groups?  You also stated there is no connectivity...if...

I 'reported' the message so it should no longer be visible or available.

Ok so I attached a zip with a bunch of files (.xml and .csv file and the actual report .rdl). The xml has data with it. I'm not sure...

Attached a modified RDL

• This reply was modified 4 years, 10 months ago by Jeffrey Williams.

4. You really have to know the tools that you're working with.  As Jeffrey Williams stated in the first reply on this thread, the original problem could be avoided...

I don't have Report Builder - nor do I have data to support the report.  But go ahead and put it up here and I will see what I can...

Since you are on 2014 - the only method will be to backup/restore - apply tlog backups - and join.  If you were on 2016 or higher you could set...