Heh... ok... here's another thought.  If you don't think you own the data (not like the guy in the story Steve related), let something happen to it and find out...

Maybe a bit more directly....

https://www.google.com/search?q=how+to+find+queries+taking+the+most+memory+in+sql+server

I've not had to do such a thing because I've never had the same problem.  If I did, I'd probably start with the following search...

https://duckduckgo.com/?q=How+to+determine+which+databases+are+consuming+th+most+buffer+memory+in+SQL+Server

As an alternative this could possibly/probably be better handled by SSIS than what you describe as your current solution.

Instead of writing to a temp table, just pass the data...

Well....there's always a way.  The way you are looking for here is exporting it as a bacpac and then importing it into the 2016 server.  It's not nearly as...

The free edition of SQL Server is called the "Developers Edition" and it has the same capabilities as the "Enterprise Edition".

https://www.microsoft.com/en-us/sql-server/sql-server-downloads?SilentAuth=1&wa=wsignin1.0

Be advised the download is for 2019.  I did a...

Hello Jeff, thank you for you explanation, i absolutely agree with you, but situation i have is that on separate disk for log files i have physically limited space...

An even easier way for the future might be to make an update-able  partitioned view that would auto-magically evaluate the data from the temp table and auto-magically write it to...

What would be better would be to make it so that groups of rows in the temp table that will be written to the same tables are handled all at...

Just ran across this article... I agree!  Very nicely done, especially with the page-level proofs!

As a bit of a sidebar, the reason why such a small change caused the Clustered...

You should also post which browser you're using when reporting such problems.

Amazing... you had to write all of that for a pipeline?  Guess I'm glad I don't have to work with such a thing.

Since I don't know about pipelines, would it...

Hi Kathi,

Congratulations on the new job and thank you for what you've done for this community as a member of Redgate and long before that.  I was thrilled to have...

Hi and welcome aboard. That's actually a really pertinent post for this 11 year old post and that's why I like this site so much. No "Comments are Closed" here!...

I don't know much about PowerBI but the last answer at the following link appears to be the ticket.  You'll need to change all the reports once but then you'll...