Are the posted questions getting worse?

  • GilaMonster (9/1/2016)


    I uploaded the slide-deck in progress. Comments?

    http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948

    I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.

    Looking good. Maybe consider adding a brief example of the types of projects (high level of course) SQL Devs work on and / or what people (job types) they might find themselves working with?

    On the other hand you said you only had 30 minutes? So this might be enough and you might still not get through it.

    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.

  • Jeff Moden (9/1/2016)


    People correctly say "Use them when appropriate" but most newbies aren't qualified to figure out what's actually appropriate.

    That's not true! When I was a noob, I knew to use cursors for EVERYTHING.

    :w00t:

    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.

  • Lynn Pettis (9/1/2016)


    Jeff Moden (9/1/2016)


    GilaMonster (9/1/2016)


    I uploaded the slide-deck in progress. Comments?

    http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948

    I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.

    Looks good, Gail.

    Just a couple of things that I'd include if I got volunteered for such a thing.

    I can't speak for others but I owe a great amount of my personal success, not only in forums but on the job, to being able to rapidly create large volumes of test data that closely mimics what the tables being queried will actually contain. This is especially important where no such quantity of data exists on new projects and, of course, when building things like functions. It's also necessary to know how to put that data out on a file similar to what you might receive if you're designing some form of ETL whether it be in T-SQL or some tool such as SSIS.

    You might even want to run a narrow example of something like that just to show them how fast it can run to wet their appetite.

    Knowing how to interrogate execution plans is also a key. Although it may be a bit of an advanced subject for newbies, they should at least learn how to turn it on and start looking and learning. For example, do you really want that Index Seek, which turns out to be executing 60,000 times because of an improper index selection?

    Learning some of the basic but uber important stuff, like SARGability, very early will make a new Developer's life a whole lot easier, as well.

    Last but not least, no newbie should be allowed to use a Cursor or While loop for at least the first year because it's too easy to fall back on. People correctly say "Use them when appropriate" but most newbies aren't qualified to figure out what's actually appropriate.

    IMPORTANT!! Find a mentor! Doesn't have to be someone at work or even locally. I credit ssc for much of what I have learned, and Jeff Moden is just one of the many heavy hitters that have had an big impact on my knowledge of SQL Server over the past 11 years and I have been working with SQL Server since 96 (SQL Server 6.5).

    +1

    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.

  • Took a look at local weather over lunch time and immediately saw:

    83° Mostly Cloudy

    feels like 90°

    H 84° / L 77°

    UV Index 4 of 10

    ? Thunder start 2:15 pm

    ? Thunder stop 7:00 pm

    OH COME ON! The hurricane hasn't even made landfall yet and now I have to deal with almost 5 hours of thunderstorms? REALLY?

    Siiiiiiiiiiiiggggggggghhhhhhhh. Better make sure my laptops & phone are charged up.

    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 (9/1/2016)


    Took a look at local weather over lunch time and immediately saw:

    83° Mostly Cloudy

    feels like 90°

    H 84° / L 77°

    UV Index 4 of 10

    ? Thunder start 2:15 pm

    ? Thunder stop 7:00 pm

    OH COME ON! The hurricane hasn't even made landfall yet and now I have to deal with almost 5 hours of thunderstorms? REALLY?

    Siiiiiiiiiiiiggggggggghhhhhhhh. Better make sure my laptops & phone are charged up.

    And work wonders why I don't want to go to Tampa.

  • And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

  • Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.

    _______________________________________________________________

    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/

  • Sean Lange (9/1/2016)


    Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.

    Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx

  • djj (9/1/2016)


    Sean Lange (9/1/2016)


    Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.

    Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx

    Actually, here.

  • Lynn Pettis (9/1/2016)


    djj (9/1/2016)


    Sean Lange (9/1/2016)


    Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.

    Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx

    Actually, here.

    He was actually showing improvement in other threads. Well, nothing lasts forever.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • djj (9/1/2016)


    Sean Lange (9/1/2016)


    Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.

    Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx

    He must have a massive copy and paste response library. So many of his responses have more to do with ring knocking and being condescending than they do with the actual topic at hand. He reminds me of those guys holding a "REPENT: the end is near" sign.

    _______________________________________________________________

    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/

  • Luis Cazares (9/1/2016)


    Lynn Pettis (9/1/2016)


    djj (9/1/2016)


    Sean Lange (9/1/2016)


    Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.

    Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx

    Actually, here.

    He was actually showing improvement in other threads. Well, nothing lasts forever.

    I was really enjoying the quiet while he was away. I suppose all good things must end.

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    "Forced vacation"... I can think of several interpretations of that... 😀

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • ThomasRushton (9/2/2016)


    Lynn Pettis (9/1/2016)


    And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?

    "Forced vacation"... I can think of several interpretations of that... 😀

    Yeah, there are several meanings to it.

    However, here in the US, this is the start of Labor Day weekend. We'll have a whole lot of people traveling, padding the weekend with extra days to take the end-of-summer vacation and grilling. I hope everyone has a safe weekend.

  • Ed Wagner (9/2/2016)


    I hope everyone has a safe weekend.

    It's the beginning of the SQLSaturday madness for me. 3 SQL Saturdays, 3 cities, 3 weeks

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 15 posts - 55,636 through 55,650 (of 66,815 total)

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