Top 10 Hidden Gems in SQL Server 2005
By Cihan Biyikoglu
SQL Server 2005 has hundreds of new and improved components. Some of these improvements get a lot of the spotlight. However there is another set that are the hidden gems that help us improve performance, availability or greatly simplify some challenging scenarios. This paper lists the top 10 such features in SQL Server 2005 that we have discovered through the implementation with some of our top customers and partners.
Read original Microsoft TechNet Article for detailed explanation.
Reference : Pinal Dave (http://blog.SQLAuthority.com)