Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 22,441 through 22,455 (of 66,712 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

GSquared (12/14/2010)
CirquedeSQLeil (12/14/2010)
Does this frighten anybody else?
A missing image file? Not sure that "frighten" is the right word for that...

Hmmm - it looks fine to me 😀

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 2

Alvin Ramard (12/14/2010)
CirquedeSQLeil (12/14/2010)
Does this frighten anybody else?
All I see is a red x, so, no, it doesn't frighten me. 😛

Hmmm - lemme see

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

LutzM SSC Guru Points: 107049 More actions · Answer 3

CirquedeSQLeil (12/14/2010)
Does this frighten anybody else? ...

Not as much as the reverse version of "99 bottles of beer" going on right now regarding Stefans "join performance" issue...

While we're at it: make it 4 😀

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

GSquared SSC Guru Points: 260824 More actions · Answer 4

CirquedeSQLeil (12/14/2010)
GSquared (12/14/2010)
CirquedeSQLeil (12/14/2010)
Does this frighten anybody else?
A missing image file? Not sure that "frighten" is the right word for that...
Hmmm - it looks fine to me 😀

Yes, the fact that it looks fine to you does frighten me ....

- 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

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

Steve Jones - SSC Editor

SSC Guru

Points: 736270

December 14, 2010 at 2:25 pm

#1262521

Is it now more, or less, frightening?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?

Much less frightening and much more appropriate.

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

LutzM SSC Guru Points: 107049 More actions · Answer 7

Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?

Yes. More or less. 😀

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

GSquared SSC Guru Points: 260824 More actions · Answer 8

Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?

Yep.

- 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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 9

Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?

I'm now wishing I was underwater in the scuba gear... kilts skeer me! Won any blue ribbons you don't remember earning lately? :hehe:

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

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

Craig Farrell (12/14/2010)
Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?
I'm now wishing I was underwater in the scuba gear... kilts skeer me! Won any blue ribbons you don't remember earning lately? :hehe:

LOL, no ribbons at all. No one even saw me in the kilt since I was in Denver for SQL Kilt day.

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

I had an idea about the problem I mentioned earlier and I just wanted a quick sanity check.

If I run the process with around 15 days in the date range, I get acceptable speeds: 3 to 12 minutes.

If I run the process with 30 days, I get speeds of 2 to 4 hours.

I used to run the process with a third of a year at a time at speeds of an hour or two per query.

Sometime since then, my boss implemented resource limiting on the machine, keeping me from using all the RAM. Is this the kind of effect you'd see from that or is that not likely related? It seems to me that it would be, but I wanted to check with people that know this area better than I do.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Stefan Krzywicki (12/14/2010)
I had an idea about the problem I mentioned earlier and I just wanted a quick sanity check.
If I run the process with around 15 days in the date range, I get acceptable speeds: 3 to 12 minutes.
If I run the process with 30 days, I get speeds of 2 to 4 hours.
I used to run the process with a third of a year at a time at speeds of an hour or two per query.
Sometime since then, my boss implemented resource limiting on the machine, keeping me from using all the RAM. Is this the kind of effect you'd see from that or is that not likely related? It seems to me that it would be, but I wanted to check with people that know this area better than I do.

yes that could be a contributing factor.

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

WayneS SSC Guru Points: 95460 More actions · Answer 13

Gail, are you trying for sainthood?

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 14

WayneS (12/14/2010)
Gail, are you trying for sainthood?

Yeah, she is.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 15

I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.

:rolleyes:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP