Viewing 15 posts - 421 through 435 (of 5,843 total)
My recollection is that Profiler will show the entire batch completion AFTER the completion of all statements in comprises. Thus your statement completed following the sp completed event should be...
February 14, 2017 at 5:14 pm
February 14, 2017 at 5:07 pm
RVO - Tuesday, February 14, 2017 11:25 AMJeff,Is Kevin G. Boles specialty - performance issues?
What is the best way to contact Kevin?
I...
February 14, 2017 at 5:06 pm
February 14, 2017 at 5:01 pm
This has got to be pretty darn easy to do a POC for. Everything you need is in place. Just make a new sproc that is compiled and time that...
February 14, 2017 at 9:59 am
1) Don't forget to turn identity_insert back off when done! 🙂
2) You may want to consider secondary sorts for the case where the date you are ordering by...
February 13, 2017 at 10:01 pm
February 13, 2017 at 9:59 pm
The link server will have to be created on a production and i am...
February 12, 2017 at 7:10 pm
Thanks for the props Jeff!!
You bring up a good point though which is what patch level is the OP on. There are indeed memory leaks that have been...
February 11, 2017 at 7:44 pm
February 10, 2017 at 10:48 pm
It was already set to the same size - 2GB and same Autogrowth 200MB
once. Why...
February 10, 2017 at 10:42 pm
Use sp_whoisactive in differential mode to see the cumulative amount of work done by spids that run for the duration. I might try 30 or 60 seconds. Also use it...
February 10, 2017 at 4:42 pm
1) Do you have traceflags 1117 and 1118 on? Best to have those I think to ensure optimal tempdb operations.
2) I would basically redo the system if you...
February 10, 2017 at 4:38 pm
February 9, 2017 at 2:51 pm
Viewing 15 posts - 421 through 435 (of 5,843 total)