Matt Whitfield (9/23/2009)

---

That's a bit weird.

I can create this on my 2000, 2005 and 2008 instances. Not invalid syntax at all. Of course - i did replace the 'schema' with...

Matt Whitfield (9/22/2009)

---

... And then it still doesn't work in a lot of products. For example - try creating this proc

CREATE PROC

schema -- schema

.

proc -- procname

AS

print 'hello'

Then rename it, then...

Jon, did you actually try...

GSquared (9/22/2009)

---

I'd also be more inclined to believe that it's either a parameter sniffing problem, or a case of where you really need two different execution plans.

Have you tried running...

Matt: FYI, I am pretty sure that SQL Server 2000 bug is fixed in SQL Server 2005.

*whew* OK, now I remember why I quit fooling around with this tricky technique: 1) it's really tricky and hard to work with. Every time I try to...

Heh. Ok, Seth enough, I give. You have succeeded in shaming me into trying to do this. :blush:

Gimme an hour or so ...

OK, so I guess we're throwing caution (or ethics) to the wind then?

Zipping them almost always works.

I am pretty sure that we were actually talking about the same thing.

SSSolice (9/22/2009)

---

...One little piece of this monster query is a subquery that uses a join which is very curious. I've seen this used once before but cannot remember the term...

Important Question: how can we know that you are what you say you are and not say, someone who has obtained an illicit copy of a database server's disks...

Meh. Interesting historical references, but i'm not very impressed with the author's faux peer reviews. I read two of these papers when they were published (Codd's and RSA)...

Garadin (9/20/2009)

---

Barry, I briefly tested dropping the index all together before inserting data into a temp table, but I'm not sure if that's fair since the index did...

Garadin (9/18/2009)

---

And the results are in. It probably wasn't a fair contest to begin with. You were going up against a gut accustomed to eating 2 day old...