Lowell (8/30/2012)

---

i get very few false positives when i go after my procedure and function definitions using that technique:

SELECT definition,T1.*,T2.* from sys.sql_modules

CROSS APPLY dbo.DelimitedSplit8K(definition,' ') T1

CROSS APPLY dbo.DelimitedSplit8K(definition,' ')...

Hey! Almost missed your thanks there! 😛 You're very welcome.

And don't listen to ChrisM@Work - he's just a grumpy old,...

ChrisM@Work (8/30/2012)

---

dwain.c (8/29/2012)

---

RBarryYoung (8/29/2012)

---

Unless the queries all strictly follow the same very simple format, this is going to fall somewhere between "Impossible" and "Incredibly Hard" to do in SQL.

If the...

Ah yes, the bible on this subject. It appears Jeff has revised...

sjsubscribe (8/30/2012)

---

Dwain, works perfectly. Thanks very very much.

First off, I never thought about quirky update though I used it before.

Second, your code ran in 5.1 seconds for 300K records...

First of all, and a good thing for you because I suck at them, I don't think this is a gaps and islands problem. It looks more like a...

RBarryYoung (8/29/2012)

---

Unless the queries all strictly follow the same very simple format, this is going to fall somewhere between "Impossible" and "Incredibly Hard" to do in SQL.

If the queries are...

Well, one thing that you could do if you were so inclined is to add the schema prefix (e.g., dbo.) to each referenced table in each query.

This is supposed to...

Very messy, but kinda fun!

;WITH Tally (n) AS (

SELECT TOP 200 ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

...

Jo Pattyn (8/29/2012)

---

How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?

*edit* Not an...

Gus,

That's an interesting point on the IOs but in the below test harness (5 docs) it still runs pretty fast, although clearly not as fast as Mark's.

Create table #Doc (

DocNum...

ChrisM@Work (8/29/2012)

---

It refers to "fields" too - and took me ages to call them "columns" when I...

ChrisM@Work (8/29/2012)

---

It refers to "fields" too - and took me ages to call them "columns" when I...

Yep. That's the same error I got.

Whatever it is saying, it's odd.

ChrisM@Work (8/29/2012)

---

-- casting GETDATE as INT gives different results before and after midday ...