Want to learn to dechiper a SQL Server data page? In this post I'll go through the contents of a data page using the SQL Server DBCC PAGE command.

Here's an example of the query optimization process. Fixing one thing allows you to optimize another, all the way until the query is perfect.

These are the slides & materials for my "Optimizing SQL Server 2005" talk presented at the Aarhus .NET User Group.

One of the best way to improve performance of any website is to reduce the load from clients by allowing them to cache resources. There are various ways to ensure we utilize client side caching to the fullest extent, an often overlooked parameter however, is the actual URL for the resource we want to cache. The traditional methods Basically client side caching comes down to three different parameters, the cache policy, the expiration dates as well as the last-modified / etag of the resource. Through the no-cache policy we can completely disallow all caching of the resource,...