Best Practices and Band Plans

  • Grant Fritchey

    SSC Guru

    Points: 395510

    Comments posted to this topic are about the item Best Practices and Band Plans

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Marcus Hopfinger

    SSC Rookie

    Points: 49

    Good article! Glad to see Amateur Radio get a little love. I have talked to some people that state "our best practices is to never use..." because they tried it when it was first introduced in SQL Server 2005 and it didn't work for them so now they won't use it at all. I try to point out that in the past fourteen years that feature has seen lots of improvement and if it was truly horrible Microsoft would have dropped it. I know vague statement but I don't remember the exact feature...but we are using it in our environment with great success whatever it was. The point is we can't be stuck on what may have been best over a decade ago and best practices have to evolve along with the technology and have to be accepted throughout the community not just "this is OUR best practice."

    Good luck on the license upgrade, I hope to go for Amateur Extra this coming winter myself.

    73,

    KA0SQL (Marcus)

  • sqlman63

    SSC-Addicted

    Points: 474

    Nice article!  It's interesting how some best practices change over time...

    And good luck with your license I got my advanced license years ago, and 73.

     

    WA3MH (Mark)

  • BrianWS1O

    SSC Rookie

    Points: 30

    KC1KCE 73 DE WS1O

  • ronaldkunenborg

    SSC Enthusiast

    Points: 156

    "I have talked to some people that state "our best practices is to never use..." because they tried it when it was first introduced in SQL Server 2005 and it didn't work for them so now they won't use it at all. "

    Yeah. My pet peeve: people saying that views are banned because they cause performance issues. Despite those same people having no real background in databases, and hiring me as an expert they still manage to tell me this. Fortunately I can usually ignore their rules. But more junior permanent co-workers are not always as lucky.

    Oh, and the "no foreign keys" always makes me mad. If you as a developer don't understand database integrity, you have no business touching my database in the first place. Grrrr....

    One of my best practices is: not putting hints in queries (emergencies exempted). I've seen people putt hints in EVERY SINGLE QUERY they write because it's best practice to always force hash joins or something. What the heck? If you need to force every plan to get it to perform, perhaps there is something wrong with your database settings or your queries? Naah... that could never be the case...

  • Grant Fritchey

    SSC Guru

    Points: 395510

    Great to see all the hams.73 to you all

    This fight, like so many others, does come down to ignorance. We have to constantly educate ourselves and others.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • TUellner

    SSCrazy

    Points: 2371

    Great article Grant.

    Former WN4NKJ

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

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