Post reply

Advice Required : TSQL best practice advise

  • January 30, 2005 at 1:33 pm

    #163179

    http://www.nyx.net/~bwunder/dbChangeControl/standard.htm

    I found this article of TSQL best practice, its for SQL 7, a bit old, some things I dont agree with, are there any other links out there like this, post yours.Thanks

  • January 31, 2005 at 2:07 am

    #539688

    I would say I agree with 45%-50% of what is in this article.

    For example, I wouldn't create scripts that use the fully qualified object name i.e. database.owner.object because that means everytime you need to reuse a procedure in a different database you have to edit your scripts.

    There are a lot of opinions on "best practice" so I would approach it from a different angle.  Look and Andy Warren's "Worst Practice" articles and make sure you are not doing something in them.

    A search for "Worst practice" on this site will return umpteen links on the subject.

    LinkedIn Profile

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply