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...

Something to check is database autogrow.  If the database is growing when you do this import, it will slow things down.  
Another thing you could try that we did in...