vlad navazhylau's blog

SQL Server 2005 XQuery and XML-DML

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

Tips for Rebuilding Indexes SQL Server 2005

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

Common Table Expressions

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

Understanding SQL 2005 PIVOT clause

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

SQL SELECT INTO Statement

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