Viewing 15 posts - 7,381 through 7,395 (of 22,213 total)
Jack Corbett (10/13/2014)
Grant Fritchey (10/10/2014)
October 14, 2014 at 4:59 am
Estimated 20, Actual 861K.... Uhm, I'm thinking a seek is absolutely a bad thing for this query to be running. Are we looking at a bad parameter sniffing? Really bad...
October 10, 2014 at 4:14 pm
You might want to look into external management of this type of long running distributed transaction. The BizTalk server[/url] is build around managing this sort of thing..
October 10, 2014 at 4:09 pm
Sure thing. I've got a video up here of deadlock information in SQL Monitor.
October 10, 2014 at 4:06 pm
Thanks for walking through that. I kept meaning to get to it, but didn't have the time.
October 10, 2014 at 3:50 pm
October 10, 2014 at 10:22 am
RUN AS is a secondary set of permissions you'd need as well. Security is fun.
October 10, 2014 at 7:52 am
With the huge variety of things going on within SQL Server, I've no doubt there are places or instances where you'll see faster performance. But they're going to be a...
October 10, 2014 at 6:25 am
You're not simply nesting the functions, you're self-referencing. That's very different, and, as you're seeing in the error message, not allowed.
October 10, 2014 at 6:22 am
No. You can't.
The language for manipulating SQL Server is T-SQL. Not HTML. That stands for Hyper Text Markup Language. Transaction Structured Query Language is for SQL Server. They are not...
October 10, 2014 at 6:09 am
I'd suggest looking at a few more pieces of information. What are your wait statistics like. And, check this article for a few more[/url]. Note, the query that shows you...
October 10, 2014 at 6:07 am
The domain account that Agent is running in will need to have permissions set for it.
October 10, 2014 at 6:02 am
Best suggestion, you take it a step at a time. Be structural in your approach. Understand what's happening and why, then make adjustments to change the behaviors you don't like....
October 10, 2014 at 5:03 am
Viewing 15 posts - 7,381 through 7,395 (of 22,213 total)