Viewing 15 posts - 1 through 15 (of 1,178 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....
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.
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...
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...
May 23, 2017 at 3:15 am
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.
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.
May 17, 2017 at 4:13 am
Does SQL Profiler or Audit server your purpose?
May 17, 2017 at 4:04 am
Nice and easy one.
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...
March 10, 2016 at 4:16 am
Thank you, Steve.
Easy one on the last day of the week 🙂
July 3, 2015 at 12:57 am
July 3, 2015 at 12:52 am
Thank you! Nice Question.
July 2, 2015 at 8:01 am
Nice question, thanks Tom.
June 30, 2015 at 4:53 am
You can do the same with the executing jobs. Refer follwoing link for further details:
June 29, 2015 at 6:38 am
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...
June 29, 2015 at 3:29 am