All good here - it was centred on the other island 300km from me. Earthquake map:

http://www.geonet.org.nz/earthquake/quakes/3366146g-maps.html

7.4 magnitude quake hits New Zealand (Christchurch, Sth Island) http://on.cnn.com/d3tTtl

There are two blog entries. My link was broken due to an...

I think that's a fair assessment. It's been stated...

Unless I am misunderstanding you, I think you have missed the point 😛 🙂

The...

Jeff Moden (9/3/2010)

---

If a SEEK occurs, you could get an out of order update and that's why I didn't recommend INDEX(1). INDEX(0) forces the clustered index scan that's needed...

Interestingly, there may...

Hugo,

Excellent, thank you. I do agree (as I have mentioned more than once before on this thread) that the SQLCLR or set-iteration alternatives are a better choice for production...

Gianluca,

A column named description is a great candidate for a foreign key, so long as the column is extremely poorly named 😀

Work sucks doesn't it? You won't miss it.

Paul

Hugo,

I really want to break this down to a simple point which I hope everyone can agree on:

"The single requirement for Quirky Update is that rows get updated in clustered...

Dave Ballantyne (9/3/2010)

---

Paul White NZ (9/3/2010)

---

Probably just as well - most...

Probably just as well - most people struggle to write set-based...

tonyrogerson-498793 (9/2/2010)

---

I wasn't going to respond because I knew I'd get grief for taking the opposite view to you Paul and Jeff and no doubt a few others that are...

Jeff Moden (9/2/2010)

---

I don't remember what I did it for... I only remember "why". I needed to do a "previous row" calculation in a mlTVF in 2K... obviously, Temp...

You should probably never...