Only getting a couple of hundred IOps per 15K drive isn't really accurate because in reality we don't do a fully random workload across the entire disk.

I wrote the blog...

I take the business of customer data integrity very seriously - its no joking matter and there should be no room for possible corruption of that data imho.

Lol - the...

Yes - I do mean a cursor; a static one and not a "update where current".

I don't honestly know what your problem is here Paul - even Jeff has found...

Hi Gabriel,

I think you've hit why myself, Hugo and others have been saying don't use this Quirky Update technique.

Look at another approach - seriously; an approach that works, is documented...

Paul White (2/4/2010)

---

1. This undocumented method has worked for at least ten years in all versions, service packs, cumulative updates, and what-have-you.

2. Yes, you would need to test...

Its on my list to blog about but I'm concentrating on my MSc at the moment, here you are....

If you hunt around the presentation may be online - I did...

Not in my testing they don't!

I've presented a number of times at UK user group meeting on running totals; I have an example that proves the opposite.

The cursor was faster...

Jeff Moden (2/4/2010)

---

tony rogerson (2/4/2010)

---

Cursor is imho the best approach for this because you can put an ORDER BY - you have repeatable results with syntax that is well defined...

Relying on query hints to force a side effect feature is just madness - you are relying on the behaviour of the engine in specific product versions (and builds).

Seriously -...

Cursor is imho the best approach for this because you can put an ORDER BY - you have repeatable results with syntax that is well defined in terms of behaviour...

Using non-deterministic functions like ROW_NUMBER and NEWID need to be done carefully - my blog article: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/06/12/bug-in-inline-expansion-of-non-deterministic-functions-in-derived-tables-and-cte-s-causes-incorrect-results.aspx explains the serious bug that exists in SQL Server 2005 with...

Also check out my blog article: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/03/28/send-table-or-view-as-embedded-html-lt-table-gt-in-an-email-stored-procedure.aspx which given a table or view will convert it into html and email it.

Tony Rogerson, SQL Server MVP

http://sqlblogcasts.com/blogs/tonyrogerson

http://sqlknowhow.com -- Real world training

Using columns in functions means SQL Server can no longer do a seek; instead it must do a scan.

If there was a unique index on CustomerID, orddate.

Say you had 1...

Derived tables are a great performance optimisation tool but always check because the derived table approach is not always the best and temporary tables are sometimes a necessary approach.

The derived...