Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 25,261 through 25,275 (of 66,738 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

Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I gave up on him first time I encountered him after a few times going in circles with him. Gave it the old college try but I think it's ESL difficulties coupled with a lack of knowledge that's really got him done for here, add to that he can be downright lazy about asking for help.
It's the same questions over & over with ZERO indication that he listened to a word you said in the earlier responses. He just wants the "go faster" button and I can't provide it.

Yeah, tried that with me and I Gibbs-whapped him one. That was close to the time I think I decided to walk away before I wrote some troll generation script... 😎 I don't remember that well. I tried to put it behind me like most bad experiences. :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

WayneS SSC Guru Points: 95460 More actions · Answer 2

I was asked a question a few minutes ago by a developer. Didn't want to laugh in his face, primarily because he didn't believe this either. But at his last job, he was told that in SQL 2008, that a select * was no longer a performance problem. Anyone else heard anything like this?

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 3

WayneS (3/31/2011)
I was asked a question a few minutes ago by a developer. Didn't want to laugh in his face, primarily because he didn't believe this either. But at his last job, he was told that in SQL 2008, that a select * was no longer a performance problem. Anyone else heard anything like this?

Maybe, if he's talking about EXISTS queries. (SELECT 1 vs. SELECT *). Reading one of Ben-Gan's books at the moment and he actually prefers the SELECT * and says it has no effect on the optimization.

- 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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 4

Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I gave up on him first time I encountered him after a few times going in circles with him. Gave it the old college try but I think it's ESL difficulties coupled with a lack of knowledge that's really got him done for here, add to that he can be downright lazy about asking for help.
It's the same questions over & over with ZERO indication that he listened to a word you said in the earlier responses. He just wants the "go faster" button and I can't provide it.
Yeah, tried that with me and I Gibbs-whapped him one. That was close to the time I think I decided to walk away before I wrote some troll generation script... 😎 I don't remember that well. I tried to put it behind me like most bad experiences. :hehe:

What's the link for that one?

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

Jeff Moden (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I gave up on him first time I encountered him after a few times going in circles with him. Gave it the old college try but I think it's ESL difficulties coupled with a lack of knowledge that's really got him done for here, add to that he can be downright lazy about asking for help.
It's the same questions over & over with ZERO indication that he listened to a word you said in the earlier responses. He just wants the "go faster" button and I can't provide it.
Yeah, tried that with me and I Gibbs-whapped him one. That was close to the time I think I decided to walk away before I wrote some troll generation script... 😎 I don't remember that well. I tried to put it behind me like most bad experiences. :hehe:
What's the link for that one?

http://www.sqlservercentral.com/Forums/FindPost1085826.aspx

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

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

CirquedeSQLeil (3/31/2011)
Stefan Krzywicki (3/31/2011)
WayneS (3/31/2011)
WayneS (3/31/2011)
CirquedeSQLeil (3/31/2011)
@Wayne - did I miss something? What's up with the SQLRally logo in your sig?
It's the "I'm attending" logo, not the "I'm speaking" one.
Well, now it's the correct one.
And thanks to the magic of the internet, it always has been! (as far as anyone can see...)
And without a picture to prove otherwise (rule 32)

Dammit... I knew I didn't have a life. I can read rule -5.

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

WayneS (3/31/2011)
Jeff Moden (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I gave up on him first time I encountered him after a few times going in circles with him. Gave it the old college try but I think it's ESL difficulties coupled with a lack of knowledge that's really got him done for here, add to that he can be downright lazy about asking for help.
It's the same questions over & over with ZERO indication that he listened to a word you said in the earlier responses. He just wants the "go faster" button and I can't provide it.
Yeah, tried that with me and I Gibbs-whapped him one. That was close to the time I think I decided to walk away before I wrote some troll generation script... 😎 I don't remember that well. I tried to put it behind me like most bad experiences. :hehe:
What's the link for that one?
http://www.sqlservercentral.com/Forums/FindPost1085826.aspx

Oh my... and I see (s)he went back and deleted all of his/her attachments except for the spreadsheet to top it all off. I'm going to go flip a pork chop at the wall and pretend I didn't even see that one. Congrats to all of those who have exhibited patience in the extreme.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Craig Farrell (3/31/2011)
WayneS (3/31/2011)
I was asked a question a few minutes ago by a developer. Didn't want to laugh in his face, primarily because he didn't believe this either. But at his last job, he was told that in SQL 2008, that a select * was no longer a performance problem. Anyone else heard anything like this?
Maybe, if he's talking about EXISTS queries. (SELECT 1 vs. SELECT *). Reading one of Ben-Gan's books at the moment and he actually prefers the SELECT * and says it has no effect on the optimization.

I have been meaning to do some performance testing on the whole select * thing. I ran into some cases where select * actually beat the pants off a select with all of the columns listed out. This was an atypical result where I had a realllllllllllly wide select statement. And it was after we upgraded a database from sql 2000 to sql 2008.

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

Jeff Moden (3/31/2011)
WayneS (3/31/2011)
Jeff Moden (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I gave up on him first time I encountered him after a few times going in circles with him. Gave it the old college try but I think it's ESL difficulties coupled with a lack of knowledge that's really got him done for here, add to that he can be downright lazy about asking for help.
It's the same questions over & over with ZERO indication that he listened to a word you said in the earlier responses. He just wants the "go faster" button and I can't provide it.
Yeah, tried that with me and I Gibbs-whapped him one. That was close to the time I think I decided to walk away before I wrote some troll generation script... 😎 I don't remember that well. I tried to put it behind me like most bad experiences. :hehe:
What's the link for that one?
http://www.sqlservercentral.com/Forums/FindPost1085826.aspx
Oh my... and I see (s)he went back and deleted all of his/her attachments except for the spreadsheet to top it all off. I'm going to go flip a pork chop at the wall and pretend I didn't even see that one. Congrats to all of those who have exhibited patience in the extreme.

That was mildly perturbing because it really limits who can help. Basically saying that you better help within the first couple of minutes or you won't be let into the party.

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

David Burrows SSC Guru Points: 65143 More actions · Answer 10

CirquedeSQLeil (3/31/2011)[hrHa - why stop there. I plan on working on SQL Server 2210 (you know when the file system be run by the DBMS).

Meh! By then it will be running you 🙂

Or the thread has assimilated you 😛

Far away is close at hand in the images of elsewhere.
Anon.

David Burrows SSC Guru Points: 65143 More actions · Answer 11

Craig Farrell (3/31/2011)[hrI like the glass idea. I wonder if that's feasible in price for a home office... hmmmmm....

Yeah and you could go outside and the solution would look better from there and you could always shout at the idiot on the other side 😉

Far away is close at hand in the images of elsewhere.
Anon.

GSquared SSC Guru Points: 260824 More actions · Answer 12

I seriously can't believe Celko did this: http://www.sqlservercentral.com/Forums/Topic1087228-61-1.aspx

I'm seriously hoping it's followed up with "April Fools!" or something. Just, wow, if not.

- 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

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

CirquedeSQLeil (3/31/2011)
I have been meaning to do some performance testing on the whole select * thing. I ran into some cases where select * actually beat the pants off a select with all of the columns listed out. This was an atypical result where I had a realllllllllllly wide select statement. And it was after we upgraded a database from sql 2000 to sql 2008.

I for one would be surprised if that were true , maybe the parsing would be faster, but once the plan is in the cache i doubt it. Though if it were a 'simple' statement ,that may not happen.

Interesting......

Clear Sky SQL
My Blog[/url]

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 14

GSquared (3/31/2011)
I seriously can't believe Celko did this: http://www.sqlservercentral.com/Forums/Topic1087228-61-1.aspx
I'm seriously hoping it's followed up with "April Fools!" or something. Just, wow, if not.

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

Kiara SSCarpal Tunnel Points: 4185 More actions · Answer 15

Craig Farrell (3/31/2011)
Stefan Krzywicki (3/31/2011)
Chad Crawford (3/31/2011)
Kiara (3/31/2011)
Hm - I'd love to know which brand it was, since the stuff I've used (albeit on fairly small areas) seemed to work fine. If you can spare the time to dig the info up, that would be useful.
I asked and they said it was Rustoleum. It was facilities that applied it so they were not professional painters, but they weren't IT folk either :-D. Since trying the paint they've moved on to either using bathboard and framing around it or painting the wall white and attaching a sheet of glass in front of it (nice effect, especially when it's spaced a small distance from the wall).
Chad
Yeah, that latter method can look quite nice.
Maybe you could suggest this brand of paint to them and they can try it on a small test area. If it works it'll be cheaper.
I like the glass idea. I wonder if that's feasible in price for a home office... hmmmmm....

Depends on how big an area and what you're willing to spend. (Oh, dear... I sound like a DBA. "It depends.")

Seriously, though - if you don't need anything too large, and you have an Ikea nearby, they have some nice glass "whiteboards" that are easy to mount and easy to work with.

For the size area *I* want, glass is a bit unwieldy and heavy.

Unless I take the top off my dining room table and try to wall mount it - but I don't think it will make it around the corners on the way up the stairs to the room it would need to go in...

On that note, however, local glass guys will often come out, measure, cut, and deliver custom glass for a really reasonable price. The guy who did my table top (I was tired of having a gorgeous wood table at risk from teenagers) was a lot less expensive than I'd expected, and we've gotten years of use out of it. Worth looking into if you want to go the glass route.

-Ki