Quick google brought me to this page:

https://docs.microsoft.com/en-us/archive/blogs/sqltips/ordering-guarantees-in-sql-server

which states in point number 4:

INSERT queries that use SELECT with ORDER BY to populate rows guarantees how identity values are computed but not...

Have you tried creating an alias on server B?

Where I work, we have the SQL aliases pushed out through the logon script (VBScript) to each end user machine.  Putting an...

One thing to watch out for is with your linked server, are you passing your credentials along OR using a hard-coded username and password?

If it is hard coded, that account...

If I am looking at that execution plan correctly, the left-most operation is a cursor.  Cursors will impact performance as they are row based operations. If you can remove that...

that is, as far as I can see, an older paper.

Visual Studio Subscriptions (formerly MSDN subscriptions) - latest licensing whitepaper here.

from it

Different Licensed Users Can Run the Same...

Quick thing about MSDN licensing - End users who are doing acceptance TESTING do not require a license.  To quote Microsoft's licensing terms:

Acceptance Testing and Feedback. Your end users may...

This would probably be written better as an "IF" statement rather than a CASE... something along the lines of:

IF EXISTS (SELECT 1 FROM [ITRM_ITBF].[Dflt].[MANUAL_LSV_PERMISSIONS] WHERE USERNAME =...

Blanks are a bit harder to deal with.  One way would be to add a UNION onto the query... something like:

UNION
SELECT NULL
WHERE NOT EXISTS(SELECT 1
FROM <table>
WHERE SSN...

My preference is to avoid maintenance plans wherever possible.  I have run into issues with them and when a problem comes up, it can be tricky to reproduce and debug. ...

I've not used developer edition, but we also run SQL Server Standard at my workplace.  I am just offering a different option: Visual Studio subscription licensing for your test/dev environment.  Everyone...

Hello JSB_89,

Have you checked the logs?  That would be my first step.  Check PBI logs and IIS logs and windows event logs.  One of them should have something useful in...

Your max memory is set way too high.  I would drop that down to a more reasonable value.

As Frederico_fonseca said, you should have at LEAST 1 GB free for the...

Looking at the log it says it out of memory.  "Memory allocation failure".  You need more memory on your VM or need to allocate your memory differently.

As a thought, do you have a linked server on Server1 that points back to Server1?

If this is a manual process of extracting the data to CSV, you could probably do a find-and-replace in the CSV.

If you are using a tool (SSRS for example), you...