Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 51,886 through 51,900 (of 66,712 total)

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

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 1

Here's my QOTD:

If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

WayneS SSC Guru Points: 95460 More actions · Answer 2

Brandie Tarvin (12/23/2015)
Here's my QOTD:
If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?

now that depends upon the value specified for the 62nd parameter to DBCC TIMEWARP.

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Sean Lange (12/23/2015)
It is hard to tell if the spammers or IWasBornReady clutters up the feed more. So many useless comments on QOTD from 10 years ago.

I know what you mean. I saw that earlier this morning and posted a response, but I doubt he'll get it.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

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

Ed Wagner (12/23/2015)
Sean Lange (12/23/2015)
It is hard to tell if the spammers or IWasBornReady clutters up the feed more. So many useless comments on QOTD from 10 years ago.
I know what you mean. I saw that earlier this morning and posted a response, but I doubt he'll get it.

I have sent him a couple PM's in the past that if he wants to add to the discussion even for old QOTD that is great but pointless comments like "great question" to a QOTD that is several years old is just silly. He responded that he was sorry he flooded the forum but continued. Apparently they just want some points or really enjoy seeing their name on the internet. Oh well. It is certainly less annoying than spammers. 😀

_______________________________________________________________

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/

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 5

WayneS (12/23/2015)
Brandie Tarvin (12/23/2015)
Here's my QOTD:
If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?
now that depends upon the value specified for the 62nd parameter to DBCC TIMEWARP.

63rd parameter. 🙂

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Brandie Tarvin (12/23/2015)
Here's my QOTD:
If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?

This reminded me of last week. The family was at Disney and on the counter at the hotel was a menorah. My 7 year old looked at and immediately said "look daddy, there is a harmonica". I almost died laughing. 😀

_______________________________________________________________

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 7

Alvin Ramard (12/23/2015)
WayneS (12/23/2015)
Brandie Tarvin (12/23/2015)
Here's my QOTD:
If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?
now that depends upon the value specified for the 62nd parameter to DBCC TIMEWARP.
63rd parameter. 🙂

Only if the 47th optional parameter is set to a value other than null.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 8

Well, I didn't shoot anything lately, but I spent 3 days with my kid on the Space coast.

As a bonus, we were standing on the causeway in Port Canaveral Mon night and saw Space X launch, and land, the Falcon rocket. That was amazing.

Shot video, which doesn't do it justice, but we could clearly see the rocket above the flame, well barely.

Takeoff: https://youtu.be/fEGZKn01L3o

Landing: https://youtu.be/jUcm07dSN2Y

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 9

Ed Wagner (12/22/2015)
Michael L John (12/22/2015)
Phil Parkin (12/22/2015)
It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D
It's better stress relief than choking developers.
I find that people have a better chance of learning if they aren't choked too often.

"It Depends". I've found that if you squeeze the pork chop you rammed down their throat between your thumbs, they get real interested in what you say.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Brandie Tarvin (12/23/2015)
Here's my QOTD:
If it is Christmas, but you don't celebrate, does the tannenbaum still sing carols to the yule log during the Hanukkah code camp?

There's only an answer to that if you ignore the self-contradiction. The Hanukkah code camp can't be held with celebrating, because Hanukkah is nothing other than the celebration of the miracle of the oil (aka the celebration of the lights or the ceelbration of the [re]dedication[ of the temple]). But ignoring that:-

It depends on how many children there are at the camp. If there are a lot of them, the answer is likely to be "No", because you've had to cut down the tannenbaum in order to make enough sevivon for all those the children to play dreidel with. With fewer children you don't need as many tops so the tannenbaum is not cut down and can happily sing s'vivon sov sov sov to the yule log (provided of course that the yule log hasn't been convered into tops; and actually it's usually the children who sing it, not the tree, but...) - does that count as a carol?

I think the suggestions made by some that parameters of dbcc timewarp are involved are based on a misunderstanding of the occassion when the DBAs at camp cut down the tannenbaum AFTER the 8TH day of Hanukkah, making spinning tops with it, and then use DBCC TIMEWARP to carry them back to the 1ST day of Hanukkah so that the children can have both sevivon and tannenbaum that year. I can't remember when that will have happened, maybe it already has.

Tom

jasona.work SSC Guru Points: 50117 More actions · Answer 11

OK, who here has created a "spoof" stored procedure so they can make it look like they're calling DBCC TIMEWARP in their code? Maybe calling it DBCC_TIMEWARP or something so it actually can do something...

:hehe:

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 12

jasona.work (12/24/2015)
OK, who here has created a "spoof" stored procedure so they can make it look like they're calling DBCC TIMEWARP in their code? Maybe calling it DBCC_TIMEWARP or something so it actually can do something...
:hehe:

Guilty and few variations also

😎

DBCC_TIMEBOMB, USP_THIS_PROC_WILL_EXPLODE etc.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 13

Date math is hard

http://www.seattletimes.com/seattle-news/politics/inslee-error-releases-inmates-early-since-2002/

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 14

Steve Jones - SSC Editor (12/24/2015)
Date math is hard
http://www.seattletimes.com/seattle-news/politics/inslee-error-releases-inmates-early-since-2002/

Banks seem to be capable of doing date math, I've for instance seen interests paid early

😎

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 15

Eirikur Eiriksson (12/24/2015)
Banks seem to be capable of doing date math, I've for instance seen interests paid early
😎

I'm not sure that's capable. More just "able".

Or just it's doing some math, related or not.