Interesting. I'll have to double-check to be 100% sure, but I'm pretty sure that SQL...

Hey Jeff and Mr Coffee - I'm not saying a SQLCLR solution won't suck (it might...

No worries - I was being daft really. 🙂

The table has been created immediately before the population, the indexes haven't yet been added to the target table...

Hugo Kornelis (5/4/2010)

---

Here is another repro that runs fine on all clients, to demonstrate that SQL Server itself actually does not have any issues with this code:

-- Or, the more...

r.hensbergen (5/4/2010)

---

I got the answer correct for the wrong reason... This really surprises me and definitely learned a lot from this! Shows how important it is to always convert your...

Hey Christian,

Thanks for the awesome feedback there - but have you noticed that...

I am beginning to feel sad, lonely, and ignored in this thread 🙁 :crying: :laugh:

Please someone read my previous post. Say it's nonsense, I don't care, just read it...

Jeff Moden (5/4/2010)

---

Heh... sorry... I was being a bit of an "SA".... I 100% agree about the right tool for the right job. I just didn't want folks to...

Jeff Moden (5/3/2010)

---

...Here's the gap detection code I spoke of. It takes about 3 seconds to run on that same 8 year old machine. I'm thinking that because...

For SQL Server magazine subscribers, Itzik Ben-Gan has an article on exactly this issue at:

http://www.sqlmag.com/article/microsoft-products/max-and-min-aggregates-against-partitioned-tables.aspx

That was published March 16 2010.

Anyway, about this article. I'm afraid I did not rate...

Hugo Kornelis (5/4/2010)

---

Good observation, Christian. The format of the error message, which looks quite different from errors that are thrown by SQL Server, is also an indication that there is...

Christian Buettner-167247 (5/4/2010)

---

One important observation: This is an error caused within the client tool, not within SQL Server. Query Analyzer has no issues; SQL Server management Studio does have...

Yes 🙂

There are plenty of...

tobyteel (5/3/2010)

---

What's the point of the second CTE in your Key Seek solution? It seems like that could easily be incorporated into the final select statement. Seems to...

Hey Flo, thanks very much! I'm a big fan of your blog by the way.