SQL Server 2005 Hidden Gems

I just came across an article on MSDN that lists ten great features of SQL Server 2005 you most likely not know of.

The article shows you (among others):

• how easily you can enable login/logout auditing
• boosting performance through PCC
• setting the DEFAULT_SCHEMA for a user so SQL Server no longer checks [USERNAME/SCHEMA].Objectname
• Using Dynamic Management Views (DMV's) to find the top queries on your database