Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 16,366 through 16,380 (of 66,712 total)

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

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

Gianluca Sartori (7/14/2010)
Ah! I'll make sure to remember next year and maybe have a thread of mine waiting for an answer... 😀

Gifts help 😀

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White NZ (7/14/2010)
Gianluca Sartori (7/14/2010)
Ah! I'll make sure to remember next year and maybe have a thread of mine waiting for an answer... 😀
Gifts help 😀

Gift Peddies?

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

jcrawf02 (7/14/2010)
Paul White NZ (7/14/2010)
Gianluca Sartori (7/14/2010)
Ah! I'll make sure to remember next year and maybe have a thread of mine waiting for an answer... 😀
Gifts help 😀
Gift Peddies?

Ouch

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

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

Okay... someone alleviate my ignorance and tell me what "dfft" means.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Ben Teraberry SSChampion Points: 11845 More actions · Answer 5

The Dixie Flatline (7/14/2010)
Okay... someone alleviate my ignorance and tell me what "dfft" means.

I assume you mean "dftt" ... Don't Feed The Trolls

I had to look it up when I saw it last week. I'm not fluent in kiddie language.

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Steve Jones - Editor (7/13/2010)
I usually say "never do x.... until you have to"
In the v6/6.5 days, temp tables where an issue. So we told all developers to "never" use temp tables.
Until we had no other solution, or it was a large performance boost.

And that has continued even though the problem was fixed in SP1 of 6.5 and was "never" a problem starting with 7.0....

I put "never" in quotes because it's sometimes still a problem if a linked server is in place and you're using SELECT/INTO to both create and populate the temp table.

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

LutzM SSC Guru Points: 107049 More actions · Answer 7

OUCH!!!!

I immediately blacklist vendors with such a philosophy as soon as I'm getting aware of it...

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]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

LutzM (7/14/2010)
OUCH!!!!
I immediately blacklist vendors with such a philosophy as soon as I'm getting aware of it...

I agree with you on that one.

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

Hey Steve, could you go back and alter the title [/url]again?

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

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

Steve Jones - SSC Editor

SSC Guru

Points: 736270

July 14, 2010 at 8:58 pm

#1193221

tx, fixed

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

CirquedeSQLeil (7/14/2010)
LutzM (7/14/2010)
OUCH!!!!
I immediately blacklist vendors with such a philosophy as soon as I'm getting aware of it...
I agree with you on that one.

What "philosophy" are you good folks referring to?

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

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

Jeff Moden (7/14/2010)
What "philosophy" are you good folks referring to?

Presumably something around people who won't take the time to 'fix' a problem 'properly'.

As it happens, I think the comments on that thread have missed the point a bit.

A column with the IDENTITY property is not the only valid design.

It looks to me like the guy is implementing a Sequence Table.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White NZ (7/14/2010)
Jeff Moden (7/14/2010)
What "philosophy" are you good folks referring to?
Presumably something around people who won't take the time to 'fix' a problem 'properly'.
As it happens, I think the comments on that thread have missed the point a bit.
A column with the IDENTITY property is not the only valid design.
It looks to me like the guy is implementing a Sequence Table.

I just realized the OUCH!!! was a clickable link. You did a classic T-SQL thing to resolve the problem without exacerbating the problem with deadlocks. I used the same method to resolve a 640 per day deadlock problem at a previous job. Well done, 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: 1004363 More actions · Answer 14

I'm on vacation in RI to see my parents. It just so happened that my vacation coincided with the local PASS user group meeting. The meeting was fine but I finally got to do something I've been waiting for almost a year to the day to do... I got a chance to do some 12 oz. curls with and chat one-on-one and face-to-face with one of the giants in the SQL world... Mr. Grant Fritchey.

Grant, good talking with you and Raghuram. It was a real pleasure. Thanks for making the time.:-)

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 15

Jeff Moden (7/14/2010)
I'm on vacation in RI to see my parents. It just so happened that my vacation coincided with the local PASS user group meeting. The meeting was fine but I finally got to do something I've been waiting for almost a year to the day to do... I got a chance to do some 12 oz. curls with and chat one-on-one and face-to-face with one of the giants in the SQL world... Mr. Grant Fritchey.
Grant, good talking with you and Raghuram. It was a real pleasure. Thanks for making the time.:-)

You kidding the pleasure and honor were all mine. It was a blast. Can't wait to do it again in Seattle and maybe add a few more Threadizens to the mix.

Thanks for coming to the SNESSUG meeting. Any ideas you have for bumping up membership, I'm all ears.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning