We have observed one thing. Our old server has 4 processors with 8 cores each and 8 logical processors each...no hype threading enabled but new server has 2 processors with...

does it has to do anything with high amount of available memory on this server, 870Gb available.

Also, we are having query compile issue and i found this artcle...anyone aware of...

Grant Fritchey (11/22/2016)

---

I don't see any mention of cost threshold for parallelism? What's that set to?

Also, in addition to the cardinality estimator, all sorts of changes have been made to...

TheSQLGuru (11/22/2016)

---

All kinds of issues here:

1) I assume this is testing BEFORE upgrading, right? That way you don't have production issues that could have been avoided. It irks me to...

Thanks Grant for your input. We have faced the CE issues on other servers when we migrated to SQL 2014 and for some queries we did use the query hint...

Eirikur Eiriksson (11/22/2016)

---

Robin35 (11/22/2016)

---

Hello,

We have migrated SQL standard edition from 2008R2 to SQL 2014. After the migration we are seeing huge amount of blocking and overall SQL instance is very...

ScottPletcher (11/14/2016)

---

You have a couple of choices.

If you are willing to allow them to run any (local) job, you can add them to the SQLAgentOperatorRole in msdb.

If you want them...

John Mitchell-245523 (11/1/2016)

---

Thom's right. Go to the Security tab on your Linked Server properties and change the connection to Be made using this security context, and enter your SQL...

Thom A (10/31/2016)

---

If you wish to use a SQL Login, and haven't set these up, you need to define these settings. You can find them in your Server Objects, Linked...

John Mitchell-245523 (10/31/2016)

---

Indeed. The double-hop issue means you can't use Windows authentication for your linked server unless you have Kerberos configured on the remote server. Have a read...

John Mitchell-245523 (10/31/2016)

---

It sounds as if you're suffering from the double-hop problem. You need either to create a SQL login on the remote server for the linked server object...

Thom A (10/31/2016)

---

Seems like you don't have the login credentials set up correctly for the user running the agent task, as it's trying to authenicate to the other server as...

Thank you....

Thanks for the confirmation Alan. It makes sense now.

i thought of opening a case with Microsoft but before that i wanted to confirm with the experts here.

Thanks for your...

no, you are refreshing the view and executing the view again. That makes sense you are seeing new column and seeing the correct values for Total column as well.

My...