There are multiple things when you are comparing the performance of a query from 1 server to another server. If considering all the measures like CPU, MEMORY, IO, schema etc....

You can try creating the variable file and use these value while you call the program. Please refer following link which might help.

https://stackoverflow.com/questions/2763875/batch-file-include-external-file-for-variables

HTH

Thank you Kevin and all.

Posting my experience so that it help to others too.
Finally I found the culprit. The issue was with the view.
I have...

But the challenge is this task needs to be performed without having access to the database. Do you have access to that specific database? Now don't tell that you need...

Hello Chris,

It will be difficult to post actual plan as it is production server and query can't complete on database 2 due to very slow execution.

Br,

It is advisable to create AD account to run SQL Server services. Which will be easy to manage with better security.

Does SQL Profiler or Audit server your purpose?

Nice and easy one.

That might be due to Third Party backup internals. We are using Avamar and while restore it also do the same thing but restore will be on development/test it should...

Thank you, Steve.

Easy one on the last day of the week 🙂

Toreador (7/1/2015)

---

Well English clearly isn't the poster's first language, but I'd have hoped the wording could have been changed by whoever approved the question! It was a bit of a...

Thank you! Nice Question.

Nice question, thanks Tom.

Hello Welsh,

You can do the same with the executing jobs. Refer follwoing link for further details:

https://msdn.microsoft.com/en-us/library/ms151783(v=sql.110).aspx

HTH

Thanks Shiva.

It would be good if more context have been used. As ROW_NUMBER and DENSE_RANK is "Ranking Functions", DATEADD and CURRENT_TIMESTAMP is "Date and time function". Now NEWID is sytem...