Do what I say, not what I do

Nolock
Nolock
You’ll hear a lot of rules and best practices from senior IT people (not just data folks, all of them). You’ll also then see those same people do what they told you not to.


That doesn’t seem fair, does it?

It is and it isn’t. Take NOLOCK as an example. I tell people “Don’t use NOLOCK”. In fact, I’ve done a number of rants about it. But I do use it every now and again. Want to know the difference? I know when NOLOCK is appropriate.

Tools are just that, tools. They can be useful or they can cause damage if you don’t know how to use them. Some tools get misused so frequently that senior IT people start telling everyone “do not use” because the chances of them being used correctly are slim, and conversely the chances of them being misused are great.

The simple answer is to just explain how to use the tools correctly right? In a perfect world, yes; that would be the correct thing to do. Unfortunately, not everyone understands what you are teaching. And certainly not everyone understands it the first time, or the second, or the third etc. Not because they aren’t smart enough, or not paying enough attention, but because it’s the nature of learning.

Continue reading on SQLStudies.com.

Continue reading on SQLStudies.com.

54321
(0 votes. Average 0 of 5)
Leave a reply

Your email address will not be published. Required fields are marked *