If you're really looking to automate and control this, SSIS is the magic place for data movement within SQL Server.

However, if you want to stick to a command line driven...

I assume you jumped from below SQL Server 2014 to SQL Server 2017?

Your best bet would be to change the compatibility mode back to the old compatibility so that SQL...

2012 supports causality tracking right? I'd add that to the extended event so you can see these things grouped.

As long as you're all going for "jobs like mine" and not my job. I'm not done with it yet.

As to pay cuts. A long time ago (and let's hope...

No, please. Ask away. It's just so clear that you're over your head and suffering. We're trying...

Not a problem. We're all here to help out when and where we can.

For the Monitor to stop monitoring you have to be stopping the service. That shouldn't be dependent on you logging in. Are you sure that things are actually running? You...

The information put into the missing index DMVs is taken from the information put into execution plans. So, yes. they are directly correlated.

I strongly recommend you abandon the missing index...

A strong suggestion.

Listen to what Lynn has said. Your best bet would be to get someone who knows what they're doing in to teach you. Not to have them do...

Just to be a contrarian, I'm ok...

Whoa!

No. Absolutely not. You structure your data as is appropriate with primary keys and enforced referential...

Which version of SQL Server are we talking about because CXPACKET waits either mean nothing at all, or are strong indicators of CPU use.

Regardless, if I were you, you know...

I have actually received that as an answer before....

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency, it...

Words to live by.