Everybody agrees that clustered index is needed (and usage of heap tables in amateurish).

1) We know that clustered index (vs. heap) slows down the insert.

Did anybody made serious measurements- what...

There is a datawarehousing MCP exam 070-019 Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0 , it is still a SQL 7.0 (i.e. they did not upgraded it...

I started as applied programmer in 80s with Modula-2 on PDP-11 Architecture (TSX-Plus, RSX11). There were couple of databases, that I can not recollect names of.

Then came emigration to...