In general it's not about always using a CTE over CURSOR...the main point to take away is...

Jim Murphy (6/9/2011)

---

GilaMonster (6/9/2011)

---

SQLRNNR (6/9/2011)

---

Steve Jones - SSC Editor (6/9/2011)

---

Just an FYI, those of you that posted in the "real world financial problem", I whacked the thread. No replies or...

Tangent to the OP but since you asked: ALTER TABLE...REBUILD or you can add a CI and then immediately...

Since it is a heap, and you were deleting from it every 5 minutes (and I assume something else was inserting into it just as often) it could have been...

James A. Lawrence (6/9/2011)

---

Thanks to all for your input on this!

I actually was able to find yet one more way to get this to work!

select distinct

t1.A_PREFIX,...

hxkresl (6/9/2011)

---

Yes, I see how that would work. I am sticking with my cursor based script because it is strictly an administrative task, but I appreciate knowing about this...

@Offices.nodes('/Offices/OfficeID', '/Offices/OfficeID/PracticeID')

If these files are sent for a business purpose it would be best to ask the source for...

That will still require another access to the base table. There is a way to do it without touching the table again, and we know the query he shared is...

BOL says you can partition a heap...not that anyone would, would they? Uggh.

Profiler will generate a lot more data than you need. You could load your trace files into a table as needed and delete what you do not need however that's...

I am confident the original query could be fixed but here is the cte with the query you just provided. The downside is that it only handles default constraints. It...

Oh, it's a command line tool 😀

It's a good one to keep in your toolkit for troubleshooting these kinds of issues. Sometimes the network folks unintentionally get involved and break...

:w00t: I'll add it to the list of things to try as a last resort when I see these issues come up...and they do come up regularly. Thanks for posting...

kurtyue (6/9/2011)

---

@opc.three - Server 1 is a named instance. SQL Browser is running. Tried PortQryv2 but it wouldn't run for some reason. Workstation1's client matches Server1 perfectly,...