Why is my SELECT COUNT(*) running so slow?
Take a look at the execution plan for your query. You’ll notice that the query is doing an Index Scan (or a table scan), not an Index Seek which is why the SELECT COUNT(*) takes so long. The reason for this is that the COUNT(*) function needs to look at every record in the table. […]
Database superstition
Sean McCown posted what I think is an excellent blog post about Database superstition. I’ve worked in shops and had the same problems that Sean is talking about. I think it’s an excellent read. Denny
My blogs 1 year birthday
Well today is the one year birthday of my blog. It’s been a very fun and exciting year. Here’s hoping that the next year will be just as fun. Denny
We just moved into our new office in Marina Del Rey, and the view is great.
The company I work for just finished our office move into our newer slightly larger office. I’ve managed to snag myself a Window seat this time around. I just wanted to share the view with everyone. This is the view out my desk window. Some times its great to live in Southern California. Denny