Write Queries

• 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