I think that your "physical memory in use kb" is the number you are looking for, but even if things aren't running, stuff is in memory. SQL will keep things...

Just wanted to point out that rmeldrum indicated in their script that temp tables put the results in memory. This is not accurate. Temp tables are written to tempdb which...

My opinion - I wouldn't make changes to the core SSRS files. My reasoning - you make all your changes and make things work exactly how you want and everyone...

As a completely random guess, are you renaming the column inside PowerBI at the presentation layer?

As far as I am aware, PowerBI shouldn't be renaming columns on you.

Alternately, any chance...

Possibly a dumb question, but if secondary should never become primary, do you even need AG to be set up? Could you set up something like replication instead?

As for having...

How is this (performance wise and for what you need):

DECLARE @Histo AS DATE;
SET @Histo = '1900-12-31';


;WITH Customers
AS
    (
      ...

• This reply was modified 1 year, 8 months ago by Mr. Brian Gale. Reason: converted tabs to spaces because the forum seems to hate tabs in code
• This reply was modified 1 year, 8 months ago by Mr. Brian Gale.

I am glad you got it optimized. One thing that MAY also help with your optimization is to change your UNION to a UNION ALL. That will remove an implicit...

• This reply was modified 1 year, 8 months ago by Mr. Brian Gale.

That is a long run time... so it sounds like it needs some optimizing.

How much data are you working with and where are you presenting the data? If it is...

For handling it dynamically, I imagine it would be possible, but dynamic SQL is always risky. Since this would be a "write once and never again" (hopefully), my opinion is...

There was some problems with your CTE's for the between_rows data due to the filter on RN=1. That shouldn't be applied on the between_rows set of data (happens higher up...

Feel free to ask. In my experience, I haven't needed to use the import functionality before. I've exported when I needed a data dump of all my reports to disk...

This looks like a homework or assignment or an interview question, so you will forgive me for not just spitting out a full TSQL query for this. What is always...

The best way I know how to do it then is to do an export to disk and then import it back in a new folder.

Here is the export script: