Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 13,036 through 13,050 (of 66,712 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

Paul White NZ (3/19/2010)
GilaMonster (3/19/2010)
The Dixie Flatline (3/19/2010)
We get at most a few weeks of temperatures below freezing.
What is this 'below freezing' that you mention?
Also intrigued.
edit: Thanks G², I see. But why would anyone want to live in the top part of the refrigerator?

Well, I get to tell stories about riding a horse home through the woods at 40 degrees below zero with enough wind-chill to make spit freeze before it could hit the ground, at night, in a blizzard. Unfortunately, it was only uphill one way, but it was after school, so that counts for something.

If I'm telling that one, and you're telling a story about, "I went outside and it was pleasantly warm", guess which one will get more attention in most audiences.

I'm not sure that's a valid reason, but it's the only advantage I can currently think of.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

Paul White NZ (3/19/2010)
GilaMonster (3/19/2010)
The Dixie Flatline (3/19/2010)
We get at most a few weeks of temperatures below freezing.
What is this 'below freezing' that you mention?
Also intrigued.
edit: Thanks G², I see. But why would anyone want to live in the top part of the refrigerator?

because heat rises. 😛

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Paul White SSC Guru Points: 150467 More actions · Answer 3

GSquared (3/19/2010)
If I'm telling that one, and you're telling a story about, "I went outside and it was pleasantly warm", guess which one will get more attention in most audiences.

An excellent point. Please go on with the snow story...!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 4

GSquared (3/19/2010)
Paul White NZ (3/19/2010)
GilaMonster (3/19/2010)
The Dixie Flatline (3/19/2010)
We get at most a few weeks of temperatures below freezing.
What is this 'below freezing' that you mention?
Also intrigued.
edit: Thanks G², I see. But why would anyone want to live in the top part of the refrigerator?
Well, I get to tell stories about riding a horse home through the woods at 40 degrees below zero with enough wind-chill to make spit freeze before it could hit the ground, at night, in a blizzard. Unfortunately, it was only uphill one way, but it was after school, so that counts for something.
If I'm telling that one, and you're telling a story about, "I went outside and it was pleasantly warm", guess which one will get more attention in most audiences.
I'm not sure that's a valid reason, but it's the only advantage I can currently think of.

What about being able to eat your neighbors when it's too cold?

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

jcrawf02 (3/19/2010)
What about being able to eat your neighbors when it's too cold?

There are too many of those stories that are true.

One time at band camp...

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 6

Paul White NZ (3/19/2010)
GSquared (3/19/2010)
If I'm telling that one, and you're telling a story about, "I went outside and it was pleasantly warm", guess which one will get more attention in most audiences.
An excellent point. Please go on with the snow story...!

Ice on the lakes is going quick.

I still think if I head up north about 100 miles, I can walk out to drill a hole and go fishing.:-P

Done with driving on the ice until December.

Greg E

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

Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.

I have noticed the same thing. Let me find my links and post them. Back in a few.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Found it faster than I expected.

This one has a few other links on the same topic.

http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

CirquedeSQLeil (3/19/2010)
Found it faster than I expected.
This one has a few other links on the same topic.
http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

I ask for a link, you provide it, and where do I use it? In post right after yours.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Lynn Pettis (3/19/2010)
CirquedeSQLeil (3/19/2010)
Found it faster than I expected.
This one has a few other links on the same topic.
http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
I ask for a link, you provide it, and where do I use it? In post right after yours.

It's all good.

I was going to make the nolock suggestion. I had a code snippet ready to go that removed it - but was waiting on feedback from the OP.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 12

Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.

I like this one..

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

10,000 rows which never has a count of 10,000

Clear Sky SQL
My Blog[/url]

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

Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.

This is the one I have in my ready-to-use snippets of text

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

Dave Ballantyne (3/19/2010)
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
I like this one..
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx
10,000 rows which never has a count of 10,000

That one is a link in the link that I gave Lynn - I like that one too.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

GilaMonster (3/19/2010)
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
This is the one I have in my ready-to-use snippets of text
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Thanks - just bookmarked that one too.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events