Personally, I'd start investigating your wait_state on the spid running the process and looking into your locks. You sound blocked, not slow.

EDIT: If you're sure it's just slow, we...

SQLRNNR (12/14/2011)

---

Revenant (12/14/2011)

---

bitbucket-25253 (12/14/2011)

---

SQLRNNR (12/14/2011)

---

Jim Murphy (12/14/2011)

---

Steve Jones - SSC Editor (12/14/2011)

---

SQLRNNR (12/14/2011)

---

Steve Jones - SSC Editor (12/13/2011)

---

40F in Denver, no need for pants...

Eddie Wuerch (12/14/2011)

---

if the two instances are on the same domain, then just set up the endpoints with Windows Authentication:

CREATE ENDPOINT BrokerEndpoint

STATE = STARTED

AS TCP(LISTENER_PORT =...

Stefan Krzywicki (12/14/2011)

---

Jim Murphy (12/14/2011)

---

Steve Jones - SSC Editor (12/14/2011)

---

SQLRNNR (12/14/2011)

---

Just as...

Nice question Ron.

Have we made a case for sp_Tally?

Not really. Two instances are two servers, and between two servers you need to generate endpoints and routes. This is most often done via certificates.

tigerlilly_783 (12/14/2011)

---

It seems like I somehow have to get the stored procedure to execute for every row.

1) Is there a better way to do this without making tons of calls...

Stefan Krzywicki (12/14/2011)

---

The're not new, but there'll be a new one coming up and we'll transfer to that.

So separate physical spindles for the data and log files? And those should...

NineIron (12/14/2011)

---

Jeff,

Pardon my ignorance. I should have read your post regarding forum etiquette first.

I hope I did this correctly.........here is three months of data for one provider. From here...

Stefan Krzywicki (12/14/2011)

---

I don't know enough about SANs to know if this is a reasonable suggestion for SQL Server. Could there be throughput problems? Would there still be resource allocation...

I must be crazy, I haven't lost track of the thread and I'm pretty sure I know the story Gus is talking about! I think I played Getzalif the...

NineIron (12/12/2011)

---

I've attached an ACCESS db with some data. The post periods run from 11010 (October, 2011) thru 11106 (June, 2011). This data is for one provider but, many locations,...

I'm going to go grab a glass pipe...

jsmith08 (12/13/2011)

---

I realize that by posting here I am opening myself up to criticism in general that doesn't necessarily apply to the question at hand. Since this is my...

TravisDBA (12/13/2011)

---

Evil Kraig F (12/12/2011)

---

GSquared (12/12/2011)

---

You're probably thinking of the (much later) Feudal-period "bards". Same job title, but more entertainer than keeper of lore. That's a post-literate development....