|
|
-
|
|
This is normally not a place where we advertise for events held by our friends, but today I’ll make an exception to that rule. Our friends at Orangeman has made a scoop, two that is actually .
In October, Orangeman is hosting two interesting courses here ...
|
|
-
|
|
If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in the lucky possition to be able to compress your SQL Server backups. Often I see installations of these versions, where compression is not en...
|
|
-
|
|
In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected wait stats with Microsoft Excel, so this is what this blog post will be about.
The blog post from last week will be the basic setup for this one, s...
|
|
-
|
|
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every once in a while. I knew for certain, that the affected queries were waiting for 30 seconds for an intent exclusive lock on something, before a timeout oc...
|
|
-
|
|
I like hunting. Not the kind where you are walking around the forrest and trying to find a target. No, I like hunting for SQL queries that are messy, or down right nasty. My latest hunting adventure was to find the root cause for intermittent query timeout...
|
|
-
|
|
In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at work. The session was no surprise about SQL Server performance. If you missed the ANUG event, you now have the option to listen to an ANUGCast with ...
|
|