Hello,Did you ever been asked to find all holes in document numbers (docs are sequentially numbered)? I had to do this search twice. Once for auditing purposes: holes may mean some sort of forgery. And now customers want to reuse numbers of deleted docs. And how do you think holes can be found using

Running totals... Accountants like them so much. But there is no way in SQL to make efficient query that calculate running total. Why? What is running total? It is just previous running total plus current value. But SQL syntax does not give an access to previous rows.

The article shows how one can use MS SQL Server to generate millions of guids in seconds.

A few months ago I had to optimize web portal (classified ad). The portal was built on asp.net 1.1. It seemed that portal had 2 main problems: It failed when it was more than 1 user (Collection was modified, etc.)It returned different data for the same page when I setup more than 1 IIS worker proces