What do you mean by "content"?

Where did you learn about SPA/MPA?

PHXHoward (3/11/2013)

---

I think I found the problem.

There was another index out there that included 32 of the 35 columns which it was referencing. That seems like a really big...

I assume you're using xp_cmdshell. If so, then is the account running xp_cmdshell in the sysadmin Role? If yes, then yes, the SQL Server service account is making the connection...

The SSIS Export Column Transformation can do that for you.

SQLSACT (3/12/2013)

---

opc.three (3/12/2013)

---

Not sure. I cannot get the numbers to tie on my system so I am assuming there are other factors in play. Post back if you get it...

Not always. You can achieve minimal logging with INSERT INTO...SELECT as well. Some people prefer to create...

EXEC() AT inked_server might be an option.

You can also adapt Example G to pass a variable containing your SQL of type N/VARCHAR(MAX) to EXEC(): http://msdn.microsoft.com/en-us/library/ms188332(v=sql.105).aspx

Not sure. I cannot get the numbers to tie on my system so I am assuming there are other factors in play. Post back if you get it sorted, or...

Honestly, I think that is a great next step.

Anytime.

Pretty much any structural change to the file. One thing to keep in mind though is that you do not need to...

Are you sure the queries you're using to check both the cached plans and the clerks are meant to tie out? i.e. that there are not other mitigating internal factors...

Bed, Bath...

If you had added PERSISTED when adding the computed column there is a possibility you might still be waiting for that complete 🙂

And you are concerned...