As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version. Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and most of the times we have to depend upon the web resources or forums. There are few gotchas that every new DBA should be aware of about enabling indexes and online index operations, few of them are extracted from SQL 2005 Books online and reliable...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/10/08/2400.aspx