This seems to be the official description of the bug we ran into on our cloudy day :-(
Check out the KB article here
We are carefully playing around with new SQL Server 2005 features however since we are planning to go for it again in Q1 2007.
- Database mirroring
- Database snapshots
- Analysis services
Very exciting stuff! If I run into obscure behavior you will read about it.
The first one would be to beware of snapshots and statistics, remember that snapshots are read only so when you query a snapshot the statistics should exist (and be up-to-date) in the source database when the snapshot is created or your query plans may not be as optimal as you like ;-) It's pure logic but something to remember!