Are the posted questions getting worse?

Question

Are the posted questions getting worse?

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

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

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 1

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)

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 2

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)

WayneS SSC Guru Points: 95460 More actions · Answer 3

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

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

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 5

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.

HowardW One Orange Chip Points: 29109 More actions · Answer 6

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.

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 7

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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 8

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 9

(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

HowardW One Orange Chip Points: 29109 More actions · Answer 10

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?

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 11

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 12

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/

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 13

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 14

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/

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 15

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