September 30, 2012 at 4:40 am
Comments posted to this topic are about the item Challenge Yourself
October 1, 2012 at 9:15 am
"I used to tell all junior DBAs working for me that no cursors or temp tables were allowed. It was an iron rule for them to work within in the SQL Server v6.5 days and they needed to abide by it. Then one of them saw me using a cursor to perform some administrative update and asked me why. "
I personally do not make "ironclad rules" like this for a very obvious reason. It sounds dictatorial. I agree their use should be discouraged as a front line go to tool, but I think establishing an "iron rule" to not use them is a bit much.:-D
"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
October 1, 2012 at 9:35 am
I am curious on the rule against temp tables. Is that in preference for work tables?
October 1, 2012 at 12:43 pm
How can you say to never do something, turn around and do it and they say it isn't hypocritical? Of course it is and this applies to any topic where a person preaches 'this' and does 'that'. This editorial should have never been written much less posted again. This article started off being about a rule that couldn't be enforced so the title should have been more about being flexible but instead it seems to lead down a road of denial.
We can all agree that doing things right the first time is very important as we can agree that standards and rules are. However, rules were made to be broken and I'd like to suggest that instead of saying "you can never do this" try implementing some sort of justification process. If someone insist they need to use a cursor for a given task make them justify it. If others in the room can suggest a more efficient/effective solution then no cursor. If nobody has anything to offer then...
Cheers
October 2, 2012 at 8:53 am
Setting down a rule is intended to do just that, set a rule. However I do understand that there will be exceptions to the rule. What I didn't want was every person thinking exception first.
October 2, 2012 at 11:15 am
Understand, but I think the term "iron" rule, was what threw some people like myself.:-D
"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply