[font="Verdana"]Reverse-key indexes and sub-partitions I might give you. But the three you picked as "do not exist in the SQL Server world" kind of sort of do, or at least in some form.

Try creating an index on a bit field in SQL Server 2005. Yes, it works. 😀 Does anyone know if that's still a B* index? I suspect it is.

I know that SQL Server 2008 included some additional query optimisations for star schemas.

Materialized views have existed in SQL Server for a while now. They are called "indexed views".

[/font]