SQL Server stores all of it's data in what is basically a large array of "pages". Each page is exactly 8kb and can contain various kinds of data, depending on the page type. In this entry we'll explore how to decipher a data page.
Read the complete 19723 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
Yesterday I did an interview with
Søren Spelling Lund for
ANUG (Aarhus .NET User Group) on SQL Server Optimization, as a followup to my recent talk on that subject. He asked me an interesting question - what is the normal process of determining the need of an optimization, and how to actually do it? This is a case study from today.
Read the complete 12834 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
Tonight I held my SQL Server Optimization talk at
ANUG. There was an impressive turnout of almost 50 people, and based on the feedback I've received so far, I think it went alright :)
Read the complete 1424 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
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.
Read the complete 6743 bytes...
Digg it |
Kick it |
Dzone it |
Reddit