See the .WRITE syntax here:

https://msdn.microsoft.com/en-us/library/ms177523.aspx

Bill Talada (11/28/2016)

---

You seem to have missed the poster's single problem he mentioned which is query timeout. All my suggestions answer that one problem. If a pre-select is...

S_Kumar_S (11/28/2016)

---

Thanks Bill for giving some really nice alternatives. For point 3 , we have already increased timeout to some 60 secs. I will try point 1,2 and 4.

POint 5...

Robin35 (11/28/2016)

---

TheSQLGuru (11/23/2016)

---

Robin35 (11/23/2016)

---

Thanks for your valuable inputs.

in old serverSQL 2008 R2 is using all 32 physical cores.

in new server SQL 2014 is using 16 physical cores or 32 logical...

Indianrock (11/25/2016)

---

ORMs work, up until they don't. Too many tables joined, sometimes with outer joins, too many values in "IN" statements ( e.g. 50+ ), parameters declared...

If you...

Just one example: we turned on forced parameterization years ago -- probably after observing many single-use plans. ( even though the application code almost always sends parameterized sql ). Was...

Did you read the requirements for doing a SWITCH before you decided to use paritioning?? It is quite clear that what you are trying to do is not allowed:

https://technet.microsoft.com/en-us/library/ms191160(v=sql.105).aspx

The fifth...

I don't understand this statement:

What error did it throw? Or is this just the...

Sounds like a SQL Service Broker scenario too, although I very much like the scripted SQL Agent job method too. I have used both for such scenarios.

Robin35 (11/23/2016)

---

Thanks for your valuable inputs.

in old serverSQL 2008 R2 is using all 32 physical cores.

in new server SQL 2014 is using 16 physical cores or 32 logical cores.

Per our...

Robin35 (11/22/2016)

---

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

I don't follow what you mean here or what the issue is. Can you be a bit more explicit and give an example?

Robin35 (11/22/2016)

---

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

Robin35 (11/22/2016)We did test in non production environments before moving to production but the issues is happening only on production and yes we moved to prod and its live now.

we...