Cache on native database

We all know that the theoretical limit is 1GB for the cache on the native database.
But the practical maximum we ever reached (or heard/read from others) is around 850MB.
The same for me. I never installed or heard someone install a native database service and got over that 850MB limit (and sometimes even getting there is […]

How hard is it to pick the right non-clustered indexes?

When reading this blog, I first thought it was such an obvious thing, hardly worth to blog about it. But then I read the last part and he points out something that is obvious for me but probably it isn’t THAT obvious for everyone: You really have to know your workload and your data to […]

How to Integrate Performance Monitor and SQL Profiler

On Directions EMEA 2008, Mark Brummel showed how to integrate performance monitor and SQL profiler. Later I tried to do it but couldn’t and asked Mark to blog about it. But seems he is too late for it!
I found this blog : How to Integrate Performance Monitor and SQL Profiler

I found a bug!

Well, we all find (a lot of) bugs in programs.
So why talk about them?
Well, this bug is REALLY different. This bug is a very ancient one. One that came from the era of the first computers!
What it is the story?
Well, I was at a customer when suddenly someone told me to have a look on […]

Create a new blog and join in the fun!