Challenge Yourself

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Challenge Yourself

Challenge Yourself

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Sunday, September 30, 2012 4:40 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

Comments posted to this topic are about the item Challenge Yourself

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1366247

TravisDBA

Posted Monday, October 01, 2012 9:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:23 AM
Points: 1,288, Visits: 2,996

"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. BigGrin

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ... BigGrin

Post #1366617

srienstr

Posted Monday, October 01, 2012 9:35 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:07 AM
Points: 214, Visits: 380

I am curious on the rule against temp tables. Is that in preference for work tables?

Puto me cogitare, ergo puto me esse.
I think that I think, therefore I think that I am.

Post #1366627

jfogel

Posted Monday, October 01, 2012 12:43 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 6:37 PM
Points: 309, Visits: 685

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

Post #1366706

Steve Jones - SSC Editor

Posted Tuesday, October 02, 2012 8:53 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1367093

TravisDBA

Posted Tuesday, October 02, 2012 11:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:23 AM
Points: 1,288, Visits: 2,996

Understand, but I think the term "iron" rule, was what threw some people like myself. BigGrin

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ... BigGrin

Post #1367191

« Prev Topic | Next Topic »

Permissions