Yup, that's what I tried first, too. Seems the optimizer is not smart enough to recognize that row number partitioned by accountid combined with accountid is a primary key...

OK, some fun on a slow Friday afternoon: this can indeed be implemented so that it is very, very quick without breaking any of the rules/guarantees provided by SQL.

The key...

Jeff,

There's no disagreement that SQL Server stores rows for tables that have a clustered index in index order (more particularly, the data for the table is effectively stored in the...

Andy (1/31/2008)

---

FYI I've ONCE come across a cursor using MS's FOR UPDATE enhancement which was WAY faster than any other update method I tried (all 'best practices')...can't remember the details,...

OK, I just have to say that while this is all very clever, it also seems beyond absurd to be relying on undocumented functionality to speed up critical calculations, *especially*...

I know it's the job of the storage administrator, but I'm not sure that I want the end users worrying too much about it. At least some of them. If...

The quoted article seems to have a way low estimate: 27 exabyte (27,000 PB) in terms of disk drives isn't that many. Considering that 1TB drives are now rather...

G Bryant McClellan (11/16/2007)

---

Not only firewalls and constant scanning of perimeter security and encrypted laptops, but encrypted emails for customer communication and software monitoring email to ensure that personal information...

A company I previously worked for used the approach of trying to lock everything down. New machines all got the BIOS locked up and the drives wiped and the...

Consulting in IT today is really just a euphanism for "temporary labor"; it bears little resemblance to true business consulting (other than the high fees for service and placement alike)....

Oh, I definitely did not mean to imply that people shouldn't think about design; regardless of what scale you are building on, or how small or large your user base,...

This editorial and the 'debt' blog post referenced in the responses, continue to perpetrate one of the greatest ineffiencies of today's IT world, namely the One True Path fallacy.

All software...