I have a query that pulls in from 7 tables..

One of those tables i just need 1 column returned for each record. The issue is that the table...

AS Gail suggested, this will not work to reduce your licensing.

This server looks like it would be a great candidate for a VM host.

Are any of your...

Is this homework, and what have you tried so far?

Assuming you have columns named "Inserts" and "Updates", this will not work for a default constraint.

You will need to create a persisted computed column.

But the question is...

Not to sound like I am piling on, but it really sounds as if you are in way over your head.

There are so many things in this thread that...

I have to do it on Excel. So yes I need the credentials. The previous dba just leave his post without leaving any documentation and with no warning. I...

Why do you need to log onto the server to do...

If you have configured read-only routing properly between the primary and readable secondaries, adding "ApplicationIntent=ReadOnly" to your connect strings will automatically route these connections to the secondaries.

If your connection...

If you have configured read-only routing properly between the primary and readable secondaries, adding "ApplicationIntent=ReadOnly" to your connect strings will automatically route these connections to the secondaries.

If your connection...

Agree with all of the previously written issues, and the site is extremely slow.