If you are still confused if its full featured download, here is what Microsoft SQL Server 2008 Express with Advanced Services means:
- SQL Server database engine – create, store, update and retrieve your data * SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases * Full-text Search – powerful, high-speed engine for searching text-intensive data * Reporting Services – integrated report creation and design environment to create reports
Note: Please go through all the details mentioned in Microsoft details before downloading Download SQL Server 2008 here