http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63&displaylang=en
http://davidhayden.com/blog/dave/archive/2008/01/19/SQLServer2005BestPracticesAnalyzerJanuary2008.aspx

http://www.exforsys.com/tutorials/sql-server-2005/maintaining-sql-server-indexes.html

An Overview of XML Support in SQL Server 2005
http://www.15seconds.com/issue/050803.htm

Improving XML Data Access Performance with SQL Server 2005
http://www.15seconds.com/issue/050811.htm

Improving XML Update Performance with SQL Server 2005
http://www.15seconds.com/issue/050818.htm

http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

http://www.setfocus.com/TechnicalArticles/sql-server-2005-tsql-3.aspx

http://geekswithblogs.net/lorint/archive/2006/08/04/87166.aspx

USE AdventureWorks;
GO
-- Passing values as constants.
EXEC dbo.uspGetWhereUsedProductID 819, '20050225';
GO
-- Passing values as variables.
DECLARE @ProductID int, @CheckDate datetime;
SET @ProductID = 819;
SET @CheckDate = '20050225';
EXEC dbo.uspGetWhereUsedProductID @ProductID, @CheckDate;
GO
-- Try to use a function as a parameter value.
-- This produces an error message.
EXEC dbo.uspGetWhereUsedProductID 819, GETDATE();
GO
-- Passing the function value as a variable.
DECLARE @CheckDate datetime;
SET @CheckDate = GETDATE();
EXEC dbo.uspGetWhereUsedProductID 819, @CheckDate;
GO

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

http://www.w3schools.com/sql/sql_select_into.asp

http://www.msdner.com/dev-archive/84/19-85-847101.shtm

SELECT
Cast(a.XML_Data as XML) as XML_Data
FROM
OPENQUERY([LINKED SERVER NAME HERE],'
SELECT
Cast(XML_Data as Varchar) as XML_Data
FROM
[DATABASE NAME].[SCHEMA].[TABLE NAME]'
) A

Basically, the data is queried on the remote server, converts the XML data to a varchar, sends the data to the requesting server and then reconverts it back to XML.

StephenDudzic at 2007-9-3 22:09:22 >

"Re: XML data type not supported in Distributed Queries This is a limitation in SQL Server 2005. Columns of xml type or CLR type cannot be queried directly or referenced from one server to another - this means the following:

1. You cannot use a table or view that contains xml or clr type as 4-part name in your query
2. You need to cast the column to either nvarchar(max) or varbinary(max) or other appropriate type to use
3. If you have a table that has xml type for example then you need to create a view that contains all columns other than xml and query it instead. Or you can issue a pass-through query using OPENQUERY with the appropriate columns only."

http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx

http://www.simple-talk.com/sql/sql-server-2005/practical-sql-server-2005-clr-assemblies/

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

http://technet.microsoft.com/en-us/library/ms345144.aspx

http://msdn2.microsoft.com/en-us/asp.net/Aa336619.aspx
http://msdn2.microsoft.com/en-us/library/aa479568.aspx

WITH cteStatusCounts(FormsCount, SubjectID,StatusCodeID)
AS
(
    SELECT     COUNT(FormID) AS FormsCount, SubjectID,StatusCodeID
    FROM         tblFeedbackForms
    Where SubjectAreaID=2
    GROUP BY SubjectID,StatusCodeID
)

SELECT
    FormsPivot.SubjectID as KeyID,
    stTotalIncoming=ISNULL([1]+[2]+[3]+[4],0),
    stOpen=ISNULL([1], 0),
    stMoreInfo=ISNULL([2], 0),
    stWithdrawn=ISNULL([3], 0),
    stCoached=ISNULL([4], 0)
FROM
    cteStatusCounts
PIVOT(sum(FormsCount) FOR StatusCodeID in([1],[2],[3],[4])) as FormsPivot
Order by FormsPivot.SubjectID