After getting some well needed sleep following Miracle OpenWorld 2010 and adhering to the we-do-not-use-sleep rule, I'm finally starting to get on top again, though my body still aches all over.
Read the complete 450 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
Deadlocks in any database can be a hard beast to weed out, especially since they may hide latently in your code, awaiting that specific moment when they explode. An API website, exposing a series of webservices, had been working fine for months, until I decided to run my client app with a lot more threads than usual.
Read the complete 12007 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
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
In this post I'll take a practical approach at talking about what SQL Server Mirroring is, the advantages and considerations that follows.
Read the complete 19534 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
When performing queries against a SQL Server database, there are a couple of methods readily available. However, an option is missing.
Read the complete 3059 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
There are no built-in functions for selecting weighted averages in SQL Server. Fortunately it's a simple task to do so oneself.
Read the complete 1755 bytes...
Digg it |
Kick it |
Dzone it |
Reddit
As feature complete as MS SQL Server may be, it really lacks some simple datetime rounding functions. Here is a simple trick to easily round of datetimes at any precision you wish.
Read the complete 2173 bytes...
Digg it |
Kick it |
Dzone it |
Reddit