Can you post your query?

Looking at the screenshots the first result set shows row 91 and the second result set shows row 1.  Since no row in data set 2...

As a crazy thought, what happens if you try opening the error log file outside of SQL?  With the new instance you can shut it down and have a look...

Welcome to the forum and to SQL Server!

So looking at your queries, my understanding is the first one is adding columns to an already existing table.  That one looks good...

I have been working as a DBA for about 8 years (roughly) and I don't see the "light" at the end of the tunnel for becoming a Sr. DBA anywhere...

I just realized I misread that configuration... it isn't 122 GB of memory, it is 12.2 GB of memory.

Depending on database size, that may be too small, but I'd still...

When you say a "slow server", is it every query that is slow?  Is it a specific stored procedure or view that is slow or everything you do on the...

This may be an unpopular opinion, but I feel that this is more of a user training issue than a forum software issue.

If the end user uses the tool the...

Looking at the query, your @Time1 and @Time2 variables are going to show the time difference between how long it takes to call GETDATE().  And that time is going to...

I have a question about this:
When it gets suddenly slow, are you able to reproduce the slowness on your machine from SSMS?

What I am thinking is to...

Another way to get this inventory is through RedGate SQL Monitor.
Not sure where they scrape their data from, but in version 8 (possibly sooner) they have an Estate tab...

As a thought, is your .NET up to date?

I quite enjoy being a DBA overall.  Every now and then I get hit with odd problems that make me think and hopefully I have time to think and resolve...

Have you tried using the "right" and "left" functions?  something like:
LEFT(RIGHT(<string>,6),1)

Can you post some DDL?
Looking at the sample data, it looks like you'd just need to look at the status column and member email.  the other columns sshouldn't matter.

This sounds like a DNS issue to me.  Your DNS server is likely pointing to the old address or prioritizing the old NIC.
You will want to update the DNS...