Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 35,866 through 35,880 (of 66,712 total)

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

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

GilaMonster (4/27/2012)
Lynn, take care in the 'Accidental DBA' thread, check the OP's history.

I remember. I just wanted to give some advice as I find myself in a similar position. Having worked both sides of the house, the other side is usually skeptical of what I may be able to offer.

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

Steve Jones - SSC Editor (4/27/2012)
Roy Ernest (4/27/2012)
So Steve, the article I submitted that still needs to be edited wont come out in May at all. Maybe June 2nd week if I am lucky?
Probably early June, maybe May. I took a glance at it and it looks pretty good. Your writing is getting better, less work for me 🙂

Thanks Steve... You have been helping me out pretty well in that area. Now a days when I write a sentence, I try to think about all your advice.

-Roy

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

Nice hat, Roy 😎

__________________________________________________

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

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

So two things.

1) Who's heading to SQL Saturday in Phoenix? I know Steve's going and I'm looking forward to meeting him, any other threadizens? Oh, warning: I don't get along with 7 AM as a rule, I'll be along eventually.

2) Friday humor. A discussion over one of our vendor apps, and this came from BUSINESS describing how they built it to ME! (Mind you, you've heard me vent about this piece of trash off and on for two years now).

If you put an infinite number of monkeys at an infinite number of computers, one of them will design the perfect application.

If you use 10,000 monkeys, your odds are not as good.

I kept wanting to modify that but it's so perfectly balanced as is... Brightened my Friday at least.

- 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

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

Evil Kraig F (4/27/2012)
So two things.
1) Who's heading to SQL Saturday in Phoenix? I know Steve's going and I'm looking forward to meeting him, any other threadizens? Oh, warning: I don't get along with 7 AM as a rule, I'll be along eventually.
2) Friday humor. A discussion over one of our vendor apps, and this came from BUSINESS describing how they built it to ME! (Mind you, you've heard me vent about this piece of trash off and on for two years now).
If you put an infinite number of monkeys at an infinite number of computers, one of them will design the perfect application.
If you use 10,000 monkeys, your odds are not as good.
I kept wanting to modify that but it's so perfectly balanced as is... Brightened my Friday at least.

Having been in Arizona (Prescott to be exact) two weekends ago, not me. I can't afford a second trip so close together. Plus, I would probably be driving by myself, and that thought isn't to appealing at the moment.

I do wish I could have made the trip, it would be nice to meet some other Threadizens.

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

Evil Kraig F (4/27/2012)
If you put an infinite number of monkeys at an infinite number of computers, one of them will design the perfect application.
If you use 10,000 monkeys, your odds are not as good.

I think I have one of those (or my client does anyway)

This kind of thing...

Update Table1

Set Table1.Column1 = Table2.Column2

From Table1 Inner Join Table2 on Table1.Column1 = Table2.Column2

Inner Join Table3 on Table2.Column3 = Table3.Column4

Where CAST(RTRIM(LTRIM(Table1.Year)) AS Integer) = 2012

I wish I could see look on vendor's face when they get my report.

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

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

GilaMonster (4/27/2012)
Evil Kraig F (4/27/2012)
If you put an infinite number of monkeys at an infinite number of computers, one of them will design the perfect application.
If you use 10,000 monkeys, your odds are not as good.
I think I have one of those (or my client does anyway)
This kind of thing...
Update Table1
Set Table1.Column1 = Table2.Column2
From Table1 Inner Join Table2 on Table1.Column1 = Table2.Column2
Inner Join Table3 on Table2.Column3 = Table3.Column4
Where CAST(RTRIM(LTRIM(Table1.Year)) AS Integer) = 2012
I wish I could see look on vendor's face when they get my report.

Gail, without really digging into this, isn't this just an expensive NOP?

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

Lynn Pettis (4/27/2012)
Gail, without really digging into this, isn't this just an expensive NOP?

Yup.

On the plus side, SQL's smart enough not to log the update.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 9

GilaMonster (4/27/2012)
Lynn Pettis (4/27/2012)
Gail, without really digging into this, isn't this just an expensive NOP?
Yup.
On the plus side, SQL's smart enough not to log the update.

Or maybe that's part of the minus side - if it wasted disc IO logging the non-update maybe people would notice something was wrong.

Although if they have things like that in their system, and haven't noticed any effect, maybe not.

Tom

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

L' Eomot Inversé (4/27/2012)
GilaMonster (4/27/2012)
Lynn Pettis (4/27/2012)
Gail, without really digging into this, isn't this just an expensive NOP?
Yup.
On the plus side, SQL's smart enough not to log the update.
Or maybe that's part of the minus side - if it wasted disc IO logging the non-update maybe people would notice something was wrong.
Although if they have things like that in their system, and haven't noticed any effect, maybe not.

I think he-who-is-without-clues has relatives all around the world working in various IT shops. 😛

Sean Lange SSC Guru Points: 286590 More actions · Answer 11

This post, http://www.sqlservercentral.com/Forums/FindPost1291791.aspx is when it is nice to show stupid amounts of patience. It seems this person is finally starting to realize the importance of posting ddl and sample data. This is what Lynn is always hoping will happen with "he who cannot be clued".

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

Sean Lange (4/27/2012)
This post, http://www.sqlservercentral.com/Forums/FindPost1291791.aspx is when it is nice to show stupid amounts of patience. It seems this person is finally starting to realize the importance of posting ddl and sample data. This is what Lynn is always hoping will happen with "he who cannot be clued".

Yes, yes it is. Too bad I will probably be long dead before he-who-is-without-clues ever gets a clue. 😛

Sean Lange SSC Guru Points: 286590 More actions · Answer 13

I particularly liked his last comment.

i am putting it in if condition,does that is the problem?

I know exactly where the problem is...that big blob right between the keyboard and the chair.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

The Dixie Flatline (4/27/2012)
Nice hat, Roy 😎

Thanks... I had this hat for quite some time now. But I havent been around SSC lately. 🙁 I have to make time to get back into SSC mode.

-Roy

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Lynn Pettis (4/27/2012)
L' Eomot Inversé (4/27/2012)
GilaMonster (4/27/2012)
Lynn Pettis (4/27/2012)
Gail, without really digging into this, isn't this just an expensive NOP?
Yup.
On the plus side, SQL's smart enough not to log the update.
Or maybe that's part of the minus side - if it wasted disc IO logging the non-update maybe people would notice something was wrong.
Although if they have things like that in their system, and haven't noticed any effect, maybe not.
I think he-who-is-without-clues has relatives all around the world working in various IT shops. 😛

Why is everybody so afraid to say his name?

Just say it already: VOLDEMORT

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