I have mixed reactions when it come to 3rd party tools. They're a great thing to have but I find they make people a fair bit lazy about learning unless they wrote their own.
An excellent example of this is Ola Hallengren's wonderful tools. His site documents what the parameters are along with what they do and he provides the code in a fully open source manner with labels for the sections of the code and, yet, we still have people asking about how to use the code or what an error reading might mean on this site.
To be a bit more metaphoric, you might not need to know how the drive train of your car works but you should know that running in 1st gear all the time is going to be a problem and, yes, you really need to learn how to change a tire.
Of course, how they use it, especially for index maintenance is even more ignorant.
And, while we're on that subject, "Index Maintenance" should NEVER be referred to as "Index Optimization". The two terms have little to do with each other and even Ola makes that mistake in his documentation.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)