Viewing 15 posts - 1 through 15 (of 1,179 total)
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....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2019 at 11:29 am
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2017 at 3:42 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2017 at 3:31 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2017 at 3:15 am
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, ---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 17, 2017 at 6:31 am
It is advisable to create AD account to run SQL Server services. Which will be easy to manage with better security.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 17, 2017 at 4:13 am
Does SQL Profiler or Audit server your purpose?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 17, 2017 at 4:04 am
Nice and easy one.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 4, 2017 at 7:30 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 10, 2016 at 4:16 am
Thank you, Steve.
Easy one on the last day of the week 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 3, 2015 at 12:57 am
Toreador (7/1/2015)
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 3, 2015 at 12:52 am
Thank you! Nice Question.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 2, 2015 at 8:01 am
Nice question, thanks Tom.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 30, 2015 at 4:53 am
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 29, 2015 at 6:38 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 29, 2015 at 3:29 am
Viewing 15 posts - 1 through 15 (of 1,179 total)