Jack Corbett (10/13/2014)

---

Grant Fritchey (10/10/2014)

---

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...

Not a problem. Happy to help out.

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...

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..

Sure thing. I've got a video up here of deadlock information in SQL Monitor.

Thanks for walking through that. I kept meaning to get to it, but didn't have the time.

You might try SQL Search from Red Gate[/url].

And before anyone freaks, it's completely free.

RUN AS is a secondary set of permissions you'd need as well. Security is fun.

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...

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.

ERStudio by Embarcadero is one of my favorites.

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...

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...

The domain account that Agent is running in will need to have permissions set for it.

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....