SELECT GivenPartNumber_Non,  vcompanyid int, SourceType

FROM #notmappedsources

WHERE SourceType = 484456

This is very basic.

My _DBA account is local admin on both nodes but not domain admin, I've been informed this isn't a requirement but could be wrong.

And the IP (well, two IPs...

This is your second post related to this.  A fresh install of 2019 will create the "old" folders.

You run the risk of breaking your installation of SQL.  Why are you...

Is the account being used to create this a domain admin?

You are not re-using an IP that was previously in use, correct?

Upgraded SQL 2008 to 2016 years ago and never removed 2008 correctly and now on 2019 I am having issues uninstalling 2008. I removed the setup files by accident...

Before you set up an AG from a cluster, one of the main differences is that there is no shared storage.  While you need a cluster to run an AG,...

• This reply was modified 3 years, 7 months ago by Michael L John.

one of those I refuse to help now - ignores suggestions and fails to supply requested information and just...

This person is in way over their head.

https://www.sqlservercentral.com/forums/user/bruin

Hi

Good morning.

What is the better approach when applying DML statements on the OLTP transactions?

1. when updating the rows in a table delete the rows and insert new rows or...

I think you have not used "sys.dm_db_index_physical_stats" correctly. I attach a Query that could help you. Contains various flags indicating whether to rebuild indexes, reorganize indexes, or compact lobs....

Can you provide more details?  Is the system slow?  What specifically is going on?

If...

Indexes can't be "inline".  I would suggest using Brent Ozar's tools...

SOS_SCHEDULER_YIELD is not one I would usually be particularly concerned...

If you are concerned that the MEMORY_ALLOCATION_EXT wait type is hurting your performance, then...

Hi

Restoring a backup of a 2012 database to 2017 instance and will copying over logins and Jobs using scripts, just wondering what I do with compatibility level of the...