Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 25,591 through 25,605 (of 66,712 total)

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

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

<-- I'd like everyone to meet Henry, a cute little feller with a penchant for petting mice with his tonsils. He's actually rather friendly when his owner doesn't actually put a camera in his face.

- 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

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

Craig Farrell (4/11/2011)
<-- I'd like everyone to meet Henry, a cute little feller with a penchant for petting mice with his tonsils. He's actually rather friendly when his owner doesn't actually put a camera in his face.

Is he your pet? What kind of snake? How big? He's very bright!

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

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

Craig Farrell (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
:blink: Whaaa?
Good to see the dead hopeless romantic virgin isn't forgotten. I never could decide if killing him off made the show better or worse.

Ugh... I hate snakes...

-Roy

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

Stefan Krzywicki (4/11/2011)
GilaMonster (4/11/2011)
Stefan Krzywicki (4/11/2011)
I'm likely using the wrong word. the metrics that are gathered by SQL Server to improve performance on subsequent runnings of a query. I knew the word at one point, but can't think of it now. The stored plan?
No such thing.
The 'metrics' that it gathers based on column distribution are the column/index statistics, they're stored in the system tables and are just based on the column distribution, not previous query executions.
The cached plan is based on the optimiser's estimate of the costs. It doesn't take into account previous executions, just the table structure, indexes, column/index statistics.
If you're thinking about what's in sys.dm_exec_query_stats, that's just cumulative statistics for reporting. They're not reused by SQL in any way.
Huh. I wonder where I got that idea then. I could have sworn I'd attended a lecture or read an article that said the subsequent runnings of a query were faster because SQL Server stores reuse information. Maybe it was wishful thinking. : -) Thanks for setting me straight. I'd been worried that my test comparison speeds were off and therefore invalid.

I think you are thinking about the buffer cache. If the data is already in memory then the query will faster than if it has to go to disk to get it.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining that it's ugly, that no sensible person would have a venomous lizard as an avatar, that I should delete the 'insect' picture.

Can you send me the picture? I'll make it my avatar.:-D

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

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

😀

Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining that it's ugly, that no sensible person would have a venomous lizard as an avatar, that I should delete the 'insect' picture.
Can you send me the picture? I'll make it my avatar.:-D

The most amusing part of that comment is that people thought it was an insect, which means they looked at it long enough to decide to complain but not long enough to figure out what it was...

Stefan: Henry's not mine, I believe he was 2 feet long when that shot was taken, and I have no idea what he is other then a dyed blonde. That snake was not bright... We fished his dumb *** out of the toilet bowl twice. Yes, the first time was QUITE the surprise, too... I guess his owner wasn't that bright, either. 😀

- 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

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

Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining that it's ugly, that no sensible person would have a venomous lizard as an avatar, that I should delete the 'insect' picture.
Can you send me the picture? I'll make it my avatar.:-D

Trying to leech off my work are we? 😀 Let's see how many we can confuse...

http://www.cryptomundo.com/cryptozoo-news/gila-invade/

Doubt the photo's originally from that site, it's found in tonnes of places on the net, no indication of the origin.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 8

Roy Ernest (4/11/2011)
Craig Farrell (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
:blink: Whaaa?
Good to see the dead hopeless romantic virgin isn't forgotten. I never could decide if killing him off made the show better or worse.
Ugh... I hate snakes...

You should PM Craig, then.

Even better, I think we ALL should PM Craig! 😀

-- Gianluca Sartori

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

Gianluca Sartori (4/11/2011)
Roy Ernest (4/11/2011)
Craig Farrell (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
:blink: Whaaa?
Good to see the dead hopeless romantic virgin isn't forgotten. I never could decide if killing him off made the show better or worse.
Ugh... I hate snakes...
You should PM Craig, then.
Even better, I think we ALL should PM Craig! 😀

Ho Boy. How did you fill your PM box up quickly Jeff? :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

GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.

you crossed me up. I thought someone had hacked your account or somehow gotten a duplicate user handle for a few minutes.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 11

WayneS (4/11/2011)
Jeff, I never did get this. Did you miss my previous post to send it on?

Apparently so. I'll send it out when I get home tonight. Thanks, Wayne.

--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: 1004363 More actions · Answer 12

GilaMonster (4/11/2011)

After 30 minutes of arguing about set theory, equivalence of statements, testing requirements and development methodology I gave up and discarded the changes.

That's why I try to let the code do the talking. I setup a test and defy them to find a fault by comparing the result sets.

--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: 1004363 More actions · Answer 13

Craig Farrell (4/11/2011)
Ho Boy. How did you fill your PM box up quickly Jeff? :hehe:

I wore a shirt with a Gila Monster on it. 😛

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

Jeff Moden (4/11/2011)
Craig Farrell (4/11/2011)
Ho Boy. How did you fill your PM box up quickly Jeff? :hehe:
I wore a shirt with a Gila Monster on it. 😛

That's just wrong. But it brought a 😀 to my face!

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

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 15

GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.

I'm going to complain because you removed it. Bring back the Gila Monster. I saw one a year ago at the top of black mountain in Cave Creek, Arizona just north of Phoenix. It was Suning on a rock and looked really cool. It ran away when I tried to get closer for a picture. I wasn't going to get too close because they are poisonous. I also saw 2 rattlers on that hike.

Gila Monsters will leave you alone unless you bother them. When they bite they aren't like rattle snakes that strike then slither away. They bite and hold on.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum