If you're going to cite an article, it would be polite to provide the link, as well,
Now... notice that the tip says IF your server has a lot of memory... DO YOU!!!??? And why would you want to waste it on possibly thousands of queries that don't need the help?
It also implies a big IF you have a lot of queries that have sorting or hashing going on (which should be fixed, BTW)... DO YOU!!!???
And do you realize that those tips were written for SQL Server 2000? DO YOU!!!???
Some of those recommendations in that article are fine but some of them have been proven to be a bit dangerous, as well. For those that want to see the article, here's the link...
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)