MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Administering a Full-text Search

http://msdn2.microsoft.com/en-us/library/ms142557.aspx

An Overview of SQL Server 2005 for the Database Administrator

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx

Using the USE PLAN Query Hint

http://msdn2.microsoft.com/en-us/library/ms186954.aspx

Forcing Query Plans

http://www.microsoft.com/technet/prodtechnol/sql/2005/frcqupln.mspx

Invoke UDFs that Accept Tables with SQL Server 2005's APPLY Operator

http://builder.com.com/5100-6388_14-6108869.html

New T-SQL Features in SQL Server 2005, Part 1

http://www.sqlservercentral.com/columnists/sramakrishnan/2734.asp

Returning Ranked Results with Microsoft SQL Server 2005

http://www.4guysfromrolla.com/webtech/010406-1.shtml

Optimizing Distributed Queries

http://msdn2.microsoft.com/en-us/library/ms180972.aspx

XQuery 1.0: An XML Query Language

http://www.w3.org/TR/xquery/

Understanding SQL Server Full-Text Indexing

http://www.developer.com/db/article.php/3446891

Lesson 5 XML Integration with SQL Server 2005

http://www.programmersheaven.com/2/SQL-server-2005-school-lesson-5