vlad navazhylau's blog

Essential knowledge and tools for web site performance optimization

Best Practices for Speeding Up Your Web Site
http://developer.yahoo.com/performance/rules.html#etags
Firebug
https://addons.mozilla.org/en-US/firefox/addon/1843
YSlow    
http://developer.yahoo.com/yslow/

Asynchronous Systems Architecture for the Web

Nice presentation
http://udidahan.weblogs.us/2008/01/07/presentation-files-asynchronous-systems-architecture-for-the-web/

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

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

Tuning Up SQL Server 2005 Databases

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