Post reply

Are the posted questions getting worse?

  • August 16, 2013 at 11:04 am

    #1642272

    Paul White (8/15/2013)

    Jeff Moden (8/15/2013)

    While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion.

    Online single partition index rebuild is present in SQL Server 2014 CTP 1.

    Very cool. Thanks for the info, Paul.

    --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)
    Intro to Tally Tables and Functions

  • August 16, 2013 at 11:14 am

    #1642276

    Grant Fritchey (8/16/2013)

    Paul White (8/15/2013)

    Jeff Moden (8/15/2013)

    While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion.

    Online single partition index rebuild is present in SQL Server 2014 CTP 1.

    I was just going to look that up because I thought it was one of the upgrades in 2014. Thanks.

    It's a real shame that they probably won't retrofit earlier versions with this fix.

    --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)
    Intro to Tally Tables and Functions

  • August 19, 2013 at 6:08 am

    #1642628

    Jeff Moden (8/16/2013)

    Grant Fritchey (8/16/2013)

    Paul White (8/15/2013)

    Jeff Moden (8/15/2013)

    While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion.

    Online single partition index rebuild is present in SQL Server 2014 CTP 1.

    I was just going to look that up because I thought it was one of the upgrades in 2014. Thanks.

    It's a real shame that they probably won't retrofit earlier versions with this fix.

    But wouldn't that be doing something you also don't like (namely, introducing / removing features in a SP)?

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • August 19, 2013 at 8:04 am

    #1642704

    WayneS (8/19/2013)

    Jeff Moden (8/16/2013)

    Grant Fritchey (8/16/2013)

    Paul White (8/15/2013)

    Jeff Moden (8/15/2013)

    While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion.

    Online single partition index rebuild is present in SQL Server 2014 CTP 1.

    I was just going to look that up because I thought it was one of the upgrades in 2014. Thanks.

    It's a real shame that they probably won't retrofit earlier versions with this fix.

    But wouldn't that be doing something you also don't like (namely, introducing / removing features in a SP)?

    Personally, I think that adding or removing features in a SP only increases the odds of breaking something. SPs are supposed to be safe and fix bugs, not introduce a whole new set of problems - that's reserved for major versions.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • August 19, 2013 at 8:21 am

    #1642713

    Ed Wagner (8/19/2013)

    Personally, I think that adding or removing features in a SP only increases the odds of breaking something. SPs are supposed to be safe and fix bugs, not introduce a whole new set of problems - that's reserved for major versions.

    I agree. And as much as I'd like these features to be downloadable add-ons, I know some of them would result in extra branches of code (with patches for those branches), which would make development a nightmare.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • August 19, 2013 at 10:05 am

    #1642747

    Steve Jones - SSC Editor (8/19/2013)

    Ed Wagner (8/19/2013)

    Personally, I think that adding or removing features in a SP only increases the odds of breaking something. SPs are supposed to be safe and fix bugs, not introduce a whole new set of problems - that's reserved for major versions.

    I agree. And as much as I'd like these features to be downloadable add-ons, I know some of them would result in extra branches of code (with patches for those branches), which would make development a nightmare.

    Also, it's not really in Microsoft's interests. The more reasons they can give for people to upgrade (often re-buying licenses), the better.

  • August 19, 2013 at 10:08 am

    #1642748

    Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have the posted questions continued to get worse over time?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • August 19, 2013 at 10:10 am

    #1642749

    The Dixie Flatline (8/19/2013)

    Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have the posted questions continued to get worse over time?

    Nah, once a question is posted, it stays about the same.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • August 19, 2013 at 10:12 am

    #1642751

    (face palm)

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • August 19, 2013 at 10:15 am

    #1642753

    The Dixie Flatline (8/19/2013)

    Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have the posted questions continued to get worse over time?

    I tried to answer this by looking in the tbl_question_quality_table table, but there's no date column. How do I order it by the oldest records first?

  • August 19, 2013 at 10:17 am

    #1642754

    The Dixie Flatline (8/19/2013)

    (face palm)

    I've been getting that a lot today.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • August 19, 2013 at 10:22 am

    #1642756

    Stefan Krzywicki (8/19/2013)

    The Dixie Flatline (8/19/2013)

    Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have the posted questions continued to get worse over time?

    Nah, once a question is posted, it stays about the same.

    Actually some of them do actually get worse when rereading them. 😛

    _______________________________________________________________

    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/

  • August 19, 2013 at 10:30 am

    #1642764

    Sean Lange (8/19/2013)

    Stefan Krzywicki (8/19/2013)

    The Dixie Flatline (8/19/2013)

    Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have the posted questions continued to get worse over time?

    Nah, once a question is posted, it stays about the same.

    Actually some of them do actually get worse when rereading them. 😛

    Have they gotten worse or have you gotten better?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • August 19, 2013 at 10:31 am

    #1642765

    Stefan Krzywicki (8/19/2013)

    Sean Lange (8/19/2013)

    Stefan Krzywicki (8/19/2013)

    The Dixie Flatline (8/19/2013)

    Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have the posted questions continued to get worse over time?

    Nah, once a question is posted, it stays about the same.

    Actually some of them do actually get worse when rereading them. 😛

    Have they gotten worse or have you gotten better?

    Definitely the questions getting worse...there is little to no chance for me. :hehe:

    _______________________________________________________________

    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/

  • August 19, 2013 at 10:40 am

    #1642772

    Stefan Krzywicki (8/19/2013)

    Sean Lange (8/19/2013)

    Stefan Krzywicki (8/19/2013)

    The Dixie Flatline (8/19/2013)

    Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have the posted questions continued to get worse over time?

    Nah, once a question is posted, it stays about the same.

    Actually some of them do actually get worse when rereading them. 😛

    Have they gotten worse or have you gotten better?

    That depends on which inertial frame you are observing the system from.

    Jason Wolfkill

Viewing 15 posts - 40,966 through 40,980 (of 66,000 total)

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