If you’re interested in scale-out improvements for reporting and read-only scenarios…check this out: KB 910378. This KB is actually a feature release KB and describes a new feature of SQL Server 2005 which allows multiple servers to simultaneously share the same database files on a SAN. This is NOT possible for read/write databases, only read-only databases; however, it does allow you to leverage multiple server’s hardware to perform complex reporting locally – using that node’s memory, tempdb, etc.

If you implement this – report back (no pun intended) as I’d love to hear your good/bad experiences!

Have fun,