Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 5,776 through 5,790 (of 66,712 total)

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

ps. One Orange Chip Points: 29422 More actions · Answer 1

GilaMonster (6/16/2009)
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking for it, aren't you. 😉 😀
Go Proteas!

cant predict anything now. 3 overs and 30 runs. Proteas are in good position.

Pradeep Singh

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

I have noticed that sometimes it will show up in the Active Threads list and at other times it doesn't. Seems really strange.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

In fact it is at the top of the list for me right now.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Oh dear, this one's not going to be pretty....

http://www.sqlservercentral.com/Forums/Topic735954-357-1.aspx

Suspect DB, and a very new 'DBA'

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

GilaMonster (6/16/2009)
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking for it, aren't you. 😉 😀
Go Proteas!

And it's over. South Africa win by 12 runs.

South Africa 130/5

India 118/8

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

ps. One Orange Chip Points: 29422 More actions · Answer 6

GilaMonster (6/16/2009)
GilaMonster (6/16/2009)
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking for it, aren't you. 😉 😀
Go Proteas!
And it's over. South Africa win by 12 runs.
South Africa 130/5
India 118/8

India played pathetic in last three games... lots of introspection to be done in near future..

SA looks unstoppable. Unless they've a REAL bad day, they will be champions this year.

Pradeep Singh

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 7

Okay Gail, you proved your point... SA kicked Indias back side pretty well.... 😛

I am ready to eat my hat now... :hehe:

-Roy

RBarryYoung SSC Guru Points: 143329 More actions · Answer 8

Lynn Pettis (6/16/2009)
I have noticed that sometimes it will show up in the Active Threads list and at other times it doesn't. Seems really strange.

I've always suspected that this had to do with locking. Seriously. 🙂

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 9

GilaMonster (6/16/2009)
Jeff Moden (6/6/2009)
Paul White (6/6/2009)
The requirement to alias a table variable for UPDATE is not spectacularly well documented in BOL. A quick skim over the entry for the UPDATE statement revealed nothing to me - I may have missed it, but I don't think so. It is logical once you think about it, but I don't think it is obvious.
It is logical. But, it's also an undocumented feature (it's not to be found in BOL or any Microsoft document I've ever seen). With that in mind, lots of folks say to never use undocumented features because they could change anytime without notice.
Digging up the past, I know, however...
I just got word from the documentation people. The lack of the UPDATE <alias> was simply an oversight and it will be corrected in a future version of BoL. Apparently it was documented in both the 6.5 and 7 docs, but somehow fell out of the SQL 2000 revision and was never added back.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=466432

Very Nice Gail! I really like this syntax, but I don't use it for wor normally and undocumented implies unsupported which is a real no-no for a corporate consultant. I'm looking forward to using it again. thanks.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 10

This reminded me of a certain visitor to our forum recently: http://www.37signals.com/svn/posts/1768-i-dont-care-how-good-you-are-at-programming

Anyone want to guess who it is?

Bruce W Cassidy SSChampion Points: 12668 More actions · Answer 11

RBarryYoung (6/16/2009)
Lynn Pettis (6/16/2009)
I have noticed that sometimes it will show up in the Active Threads list and at other times it doesn't. Seems really strange.
I've always suspected that this had to do with locking. Seriously. 🙂

[font="Verdana"]So I guess that would be page locking? :hehe:[/font]

WayneS SSC Guru Points: 95460 More actions · Answer 12

Luke L (6/16/2009)
ps (6/16/2009)
no i'm getting all updated posts if i click on posts added today.
except this thread.. also tried to refresh by ctrl+F5.. same results...
Same here, getting updated lists of posts from the Posts Added Today link, but this topic does not appear. It used to, but for some reason it no longer does. Perhaps it's just grown too large? That or it's trying to hide itself as it prepares to take over the world...
-Luke.

I don't think this behavior is restricted to this thread... I've tried to find threads that I know when I last posted in them, and was not able to find the thread from that time to now.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 13

Steve Jones - Editor (6/16/2009)
This reminded me of a certain visitor to our forum recently: http://www.37signals.com/svn/posts/1768-i-dont-care-how-good-you-are-at-programming
Anyone want to guess who it is?

My guess, little Snarky Malarky?

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 14

george sibbald (6/16/2009)
Please note that the overall percentage of correct answers for QOTD has recently gone up from 57% to 58%

Heh... probably a rounding error by the same programmers that can't get the code boxes to work correctly with IE. 😉

--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: 1004340 More actions · Answer 15

GilaMonster (6/16/2009)
I just got word from the documentation people. The lack of the UPDATE <alias> was simply an oversight and it will be corrected in a future version of BoL. Apparently it was documented in both the 6.5 and 7 docs, but somehow fell out of the SQL 2000 revision and was never added back.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=466432

I certainly don't mind that kind of "digging up the past". It's good to know that such a useful thing is actually supported.

Now, if we could just get them to say that UPDATEs always work in clustered index order... 😛

--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)