Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,711 through 55,725 (of 66,712 total)

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

David Burrows SSC Guru Points: 65142 More actions · Answer 1

Grant Fritchey (9/9/2016)
GilaMonster (9/9/2016)
Grant Fritchey (9/9/2016)
BrainDonor (9/9/2016)
I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so glad I'm not working with him.
OK. share.
If you insist: http://www.sqlservercentral.com/Forums/Topic1815214-392-1.aspx
Ah, the joys of being stupid (and I mean me), I can just walk away from something like this whistling.
:Whistling:

Don't walk away mad, just walk away 😛

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

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 2

Grant Fritchey (9/9/2016)
GilaMonster (9/9/2016)
Grant Fritchey (9/9/2016)
BrainDonor (9/9/2016)
I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so glad I'm not working with him.
OK. share.
If you insist: http://www.sqlservercentral.com/Forums/Topic1815214-392-1.aspx
Ah, the joys of being stupid (and I mean me), I can just walk away from something like this whistling.
:Whistling:

Don't walk. Run.

Thomas Rushton
blog: https://thelonedba.wordpress.com

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

ThomasRushton (9/9/2016)
Grant Fritchey (9/9/2016)
GilaMonster (9/9/2016)
Grant Fritchey (9/9/2016)
BrainDonor (9/9/2016)
I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so glad I'm not working with him.
OK. share.
If you insist: http://www.sqlservercentral.com/Forums/Topic1815214-392-1.aspx
Ah, the joys of being stupid (and I mean me), I can just walk away from something like this whistling.
:Whistling:
Don't walk. Run.

Any bets on whether the OP responds to the accepted challenge?

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 4

Lynn Pettis (9/9/2016)
ThomasRushton (9/9/2016)
Grant Fritchey (9/9/2016)
GilaMonster (9/9/2016)
Grant Fritchey (9/9/2016)
BrainDonor (9/9/2016)
I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so glad I'm not working with him.
OK. share.
If you insist: http://www.sqlservercentral.com/Forums/Topic1815214-392-1.aspx
Ah, the joys of being stupid (and I mean me), I can just walk away from something like this whistling.
:Whistling:
Don't walk. Run.
Any bets on whether the OP responds to the accepted challenge?

seems he wasnt happy with MS 12 years ago

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

:w00t:

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

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

I'm not listening anymore.... lalalalalalaaaaaaaaaaaa

__________________________________________________

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

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 6

The Dixie Flatline (9/9/2016)
I'm not listening anymore.... lalalalalalaaaaaaaaaaaa

....and he isnt going to listen to anyone either

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

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

Lacquered bacon, also known as candied bacon, is (American) bacon slices smothered in brown sugar and a bit of red pepper flake, then baked.

http://altonbrown.com/roasted-bacon-recipe/[/url]

I can eat it like candy. Seriously. 😛

There are other recipes. I'm partial to the Pecan-Rosemary myself.

http://www.myrecipes.com/recipe/pecan-rosemary-bacon

Bon Apetit

__________________________________________________

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

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

Okay.... although I'm not going back into the divide by zero thread.

Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF will give him the behavior he wants.

Anyone who cares can give him that information and let him live with the consequences

https://msdn.microsoft.com/en-us/library/ms190368.aspx

https://msdn.microsoft.com/en-us/library/ms190306.aspx

__________________________________________________

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Grant Fritchey (9/9/2016)
GilaMonster (9/9/2016)
Grant Fritchey (9/9/2016)
BrainDonor (9/9/2016)
I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so glad I'm not working with him.
OK. share.
If you insist: http://www.sqlservercentral.com/Forums/Topic1815214-392-1.aspx
Ah, the joys of being stupid (and I mean me), I can just walk away from something like this whistling.
:Whistling:

:hehe::hehe::hehe::hehe::hehe:

Laughing all the way to the market.

Was it elementary math where we discussed that concept?

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

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 10

The Dixie Flatline (9/9/2016)

Okay.... although I'm not going back into the divide by zero thread.

Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF will give him the behavior he wants.

Anyone who cares can give him that information and let him live with the consequences

https://msdn.microsoft.com/en-us/library/ms190368.aspx

https://msdn.microsoft.com/en-us/library/ms190306.aspx%5B/quote%5D

Yeah, I thought about mentioning that he could set both of those to off and get the desired result for divide by zero, but they have so many other consequences that I figured I'd stick with offering NULLIF like you and some of the other posters.

Still weird that he was so confident the scalar UDF performed at least as well as NULLIF; there's no way he ever tested it, so whence the confidence?

The world's a funny place sometimes...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

The Dixie Flatline (9/9/2016)
I'm not listening anymore.... lalalalalalaaaaaaaaaaaa

LMAO

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 12

Still weird that he was so confident the scalar UDF performed at least as well as NULLIF; there's no way he ever tested it, so whence the confidence?

Confidence can come from ignorance.

People who know a little something are often dangerous because they don't realize what they don't know.

I used to be that way myself before Jeff, and Gail, and a few other kind souls beat it (fiercely) into my head that I didn't know jack about SQL.

Fortunately my hard head survived, learned humility, and then learned a lot more than it used to know.

Hopefully that learning will continue until the day I die.

Hopefully Mr. Hart will have the same epiphany.

__________________________________________________

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

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

The Dixie Flatline (9/9/2016)
Lacquered bacon, also known as candied bacon, is (American) bacon slices smothered in brown sugar and a bit of red pepper flake, then baked.
http://altonbrown.com/roasted-bacon-recipe/[/url]
I can eat it like candy. Seriously. 😛
There are other recipes. I'm partial to the Pecan-Rosemary myself.
http://www.myrecipes.com/recipe/pecan-rosemary-bacon
Bon Apetit

I have been making bacon like that for years...never knew it had a name. Another great way is to put a liberal amount of brown sugar on top of the raw bacon and bake them on a sheet pan. Super sticky but holy cow is it tasty.

_______________________________________________________________

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/

drew.allen SSC Guru Points: 76989 More actions · Answer 14

Jacob Wilkins (9/9/2016)

The Dixie Flatline (9/9/2016)
Okay.... although I'm not going back into the divide by zero thread.
Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF will give him the behavior he wants.
Anyone who cares can give him that information and let him live with the consequences
https://msdn.microsoft.com/en-us/library/ms190368.aspx
https://msdn.microsoft.com/en-us/library/ms190306.aspx%5B/quote%5D
Yeah, I thought about mentioning that he could set both of those to off and get the desired result for divide by zero, but they have so many other consequences that I figured I'd stick with offering NULLIF like you and some of the other posters.
Still weird that he was so confident the scalar UDF performed at least as well as NULLIF; there's no way he ever tested it, so whence the confidence?
The world's a funny place sometimes...

And he thinks that he didn't use TSQL to write his function. I'm wondering what language he thinks that is, but I don't really want to get involved in that thread.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Gazareth One Orange Chip Points: 27737 More actions · Answer 15

drew.allen (9/9/2016)

Jacob Wilkins (9/9/2016)
The Dixie Flatline (9/9/2016)
Okay.... although I'm not going back into the divide by zero thread.
Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF will give him the behavior he wants.
Anyone who cares can give him that information and let him live with the consequences
https://msdn.microsoft.com/en-us/library/ms190368.aspx
https://msdn.microsoft.com/en-us/library/ms190306.aspx%5B/quote%5D
Yeah, I thought about mentioning that he could set both of those to off and get the desired result for divide by zero, but they have so many other consequences that I figured I'd stick with offering NULLIF like you and some of the other posters.
Still weird that he was so confident the scalar UDF performed at least as well as NULLIF; there's no way he ever tested it, so whence the confidence?
The world's a funny place sometimes...
And he thinks that he didn't use TSQL to write his function. I'm wondering what language he thinks that is, but I don't really want to get involved in that thread.
Drew

What I've learnt from that thread:

1. Gail's desktop is faster than mine.

Also steered clear of mentioning the arithabort & ansi warnings settings because of the wider-ranging implications.

Although if changing them means a few people get off their mortgage payments maybe it's a good idea 🙂