Index selectivity and index scans

There was a question raised some time back ‘If an index is not selective, will the query operators that use...

Repairing a replication subscriber

It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...

Unusual errors with Distributed Replay

I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...

How not to do a Masters degree

There are many, many guides to successfully completing a post grad degree, so I am not going to add to...

Premature Optimisation

Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.

On the importance of a complete break

If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.

But, but, but, my data is clean!

Gail Shaw on the challenges of trying to extract meaningful data from a database containing customers who have the name 'Dummy **DO NOT USE**''.

How to Post Performance Problems

How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.

It's not you; it's us

The announcement that the MCM program was being discontinued brings us a few thoughts from Gail Shaw, one of the 0.08% to achieve the certification.

It's not you; it's us

Mirrored from http://www.sqlservercentral.com/articles/Editorial/101894/

By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those...