Are the posted questions getting worse?

  • For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • All the SSxS (SSIS, SSAS, SSRS, SSMS).

    SSDT and BIDS.

    CDC (change data capture)

    sa

    dbo

    mdf

    ndf

    ldf

    These are the first that pop into my head.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    How about:

    PITA

    CYA

    WTF

    OMG

    I don't know why those were the first to pop into my head. :w00t:


    My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]

    My thought question: Have you ever been told that your query runs too fast?

    My advice:
    INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
    The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

    Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
    Since random numbers are too important to be left to chance, let's generate some![/url]
    Learn to understand recursive CTEs by example.[/url]
    [url url=http://www.sqlservercentral.com/articles/St

  • RBAR

    CTE

    rCTE

    Edit: Added two more.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    RTFM

    seriously.........

    ---------------------------------------------------------------------

  • george sibbald (11/6/2012)


    Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    RTFM

    seriously.........

    PEBCAK

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    ACID

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Matt Miller (#4) (11/6/2012)


    Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    ACID

    Wow. I can't believe I forgot that one. Thanks, Matt.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (11/6/2012)


    Matt Miller (#4) (11/6/2012)


    Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    ACID

    Wow. I can't believe I forgot that one. Thanks, Matt.

    BOL - your first port of call (theoretically)

    edited due to dislaxik fongers

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    How about PICNIC as we used to use when I worked on a helpdesk - Problem In Chair - Not In Computer

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • We referred to that as an ID 10 T error...

  • George M Parker (11/6/2012)


    We referred to that as an ID 10 T error...

    Eye Dee Ten Tea????

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • ROFL. I drove past this bar the other day...honest it is called RBAR.

    See the attached photo.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Brandie Tarvin (11/6/2012)


    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to add?

    GHU shouldn't be left out, even if included only to advise people not to use it in the wrong company.

    Tom

  • Sean Lange (11/6/2012)


    ROFL. I drove past this bar the other day...honest it is called RBAR.

    See the attached photo.

    Heh... truly kindred "spirits". 😛

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    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.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 15 posts - 38,236 through 38,250 (of 66,738 total)

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