L' Eomot Inversé (1/18/2012)

---

SQLRNNR (1/18/2012)

---

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able to copy...

I haven't had time to get back to this one yet. Sorry about that.

The next step I'd take on it is running step five (that's the slow one, right?)...

paul.knibbs (1/19/2012)

---

GSquared (1/18/2012)

Tropical islands are usually near the ocean (go figure), which operates as a heat moderator. The only two US states that haven't broken the 100F mark on...

Take a look at the discussion here: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/29f30130-3a64-4b91-86b3-5fa09dbc4220

Does that help?

It'll need to be image in SSIS, and varbinary(max) in the parameter list of the stored proc.

Personally, I still don't think an algorithm should do my judging and thinking for me, on a subject like this.

There are far too many holes in the idea.

All things considered...

Cadavre (1/18/2012)

---

GSquared (1/18/2012)

---

Cadavre (1/18/2012)

---

Admittedly, the answer to that is "no".

However IMO, to avoid ambiguity, whether or not your method works is...

GilaMonster (1/18/2012)

---

TravisDBA (1/18/2012)

---

Dave Ballantyne (1/18/2012)

---

It hasnt been said explicity in this thread , so i will 🙂

Never...

Steve Jones - SSC Editor (1/18/2012)

---

GSquared (1/18/2012)

---

So I really don't think it's entirely comparable, apples:apples, to compare bringing a toolbelt, hardhat, and good boots to work, to bringing a laptop,...

I see what the original method is doing. The way it goes about achieving it isn't particularly sensible, but it does have a functional pattern to it.

Is the query...

Me

paul.knibbs (1/18/2012)

---

Me! Sounds far...

The usual way to do that is to nest XML queries instead of joining tables.

SELECT ColA, ColB,

(SELECT Col1, Col2

FROM dbo.MySubtable

WHERE MySubtable.MainTableID = MainTable.ID

...

Steve Jones - SSC Editor (1/18/2012)

---

Fair points about hammers not wearing out, but we have tools that last longer than two years, we have subscription services, and we also get...

XBox, abacus, post-IT notes, whatever you want to use, if it gets the job done.

There would definitely be security issues with something like this. Would the cost of implementing...