Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 62,281 through 62,295 (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

Lynn Pettis

SSC Guru

Points: 442467

September 19, 2018 at 10:45 am

#2006304

What is so hard about creating a Cartesian Product?

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

Lynn Pettis - Wednesday, September 19, 2018 10:45 AM
What is so hard about creating a Cartesian Product?

Besides the fact that I can never spell it in order to package it properly? @=)

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.

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

Brandie Tarvin - Wednesday, September 19, 2018 10:49 AM
Lynn Pettis - Wednesday, September 19, 2018 10:45 AM
What is so hard about creating a Cartesian Product?
Besides the fact that I can never spell it in order to package it properly? @=)

:hehe:

😎

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

Brandie Tarvin - Wednesday, September 19, 2018 10:49 AM
Lynn Pettis - Wednesday, September 19, 2018 10:45 AM
What is so hard about creating a Cartesian Product?
Besides the fact that I can never spell it in order to package it properly? @=)

It's easy peasy Brandie. It is spelled c-r-o-s-s-[space]-j-o-i-n

:laugh::laugh::laugh:

_______________________________________________________________

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/

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

Me trying to explain Cartesian produce to my young daughter (failed of course)
😎
Image result for Cartesian

How can I translate this to a 9YSpeak?

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 6

Eirikur Eiriksson - Wednesday, September 19, 2018 11:26 AM
Me trying to explain Cartesian produce to my young daughter (failed of course)
😎
How can I translate this to a 9YSpeak?

Lettuce, grown by Rene Descartes, easy.

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

Michael L John One Orange Chip Points: 27056 More actions · Answer 7

I love it when developers need to do some sort of update on a lot of rows, such as re-calculating the price of something, and they put a one row re-calc proc in a cursor.
And hours later, it's still running and they come running to me because the server is broken.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

drew.allen SSC Guru Points: 76988 More actions · Answer 8

We're doing a major reclassification of our assets and we've asked our QA people to verify the reclassification before we deploy to prod. They're coming back to me with "errors" that the new classification doesn't match the old classification. SMH.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

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

jonathan.crawford - Wednesday, September 19, 2018 11:27 AM
Eirikur Eiriksson - Wednesday, September 19, 2018 11:26 AM
Me trying to explain Cartesian produce to my young daughter (failed of course)
😎
How can I translate this to a 9YSpeak?
Lettuce, grown by Rene Descartes, easy.

Simple times table will do it if she knows what that is.

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

Neil Burton SSC-Insane Points: 23002 More actions · Answer 10

drew.allen - Wednesday, September 19, 2018 2:54 PM
We're doing a major reclassification of our assets and we've asked our QA people to verify the reclassification before we deploy to prod. They're coming back to me with "errors" that the new classification doesn't match the old classification. SMH.
Drew

'It doesn't match the old report, it isn't right',
'We fixed it like you asked because you told us the old report is wrong'
'How am I supposed to test it if it's not the same as the old one?'
'You'll have to check it manually against the figures you calculated to realise the old report is wrong.'
'That'll take ages, can't you make a report?'

This conversation actually happened.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 11

Eirikur Eiriksson - Wednesday, September 19, 2018 11:26 AM
Me trying to explain Cartesian produce to my young daughter (failed of course)
😎
How can I translate this to a 9YSpeak?

You have a bag of candies in three colours: red, orange, and yellow.
There are four children at the birthday party: (list names of her best friends)
Every child can take one candy of each colour. Now you have a red, an orange, and a yellow candy; (name) has a red, an orange, and a yellow candy; and (last two naems) also each have a red, an orange, and a yellow candy.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

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

Hugo Kornelis - Thursday, September 20, 2018 1:37 AM
Eirikur Eiriksson - Wednesday, September 19, 2018 11:26 AM
Me trying to explain Cartesian produce to my young daughter (failed of course)
😎
How can I translate this to a 9YSpeak?
You have a bag of candies in three colours: red, orange, and yellow.
There are four children at the birthday party: (list names of her best friends)
Every child can take one candy of each colour. Now you have a red, an orange, and a yellow candy; (name) has a red, an orange, and a yellow candy; and (last two naems) also each have a red, an orange, and a yellow candy.

Now I get it 😀
😎

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

Okay, not really sure where to post this so I think the water cooler is as good a place as any. My daughter needs ideas for a Big Data Project this semester and I am at a loss. Any ideas are welcome and apparently there is no other information regarding requirements at this time, so high level ideas with perhaps some links to potential data, i don't know (that's why i am asking for help).

Thom A SSC Guru Points: 99130 More actions · Answer 14

Lynn Pettis - Thursday, September 20, 2018 9:56 AM
Okay, not really sure where to post this so I think the water cooler is as good a place as any. My daughter needs ideas for a Big Data Project this semester and I am at a loss. Any ideas are welcome and apparently there is no other information regarding requirements at this time, so high level ideas with perhaps some links to potential data, i don't know (that's why i am asking for help).

I dare to ask it, but have you considered the Stack Overflow database? That's pretty "big": https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/

The number of objects in there is pretty low, if I recall correctly, but (as you can guess), there's a huge amount of data in there.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

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

Thom A - Thursday, September 20, 2018 10:06 AM
Lynn Pettis - Thursday, September 20, 2018 9:56 AM
Okay, not really sure where to post this so I think the water cooler is as good a place as any. My daughter needs ideas for a Big Data Project this semester and I am at a loss. Any ideas are welcome and apparently there is no other information regarding requirements at this time, so high level ideas with perhaps some links to potential data, i don't know (that's why i am asking for help).
I dare to ask it, but have you considered the Stack Overflow database? That's pretty "big": https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/
The number of objects in there is pretty low, if I recall correctly, but (as you can guess), there's a huge amount of data in there.

Actually, nope, that's why I was asking for ideas that I can pass on to her. That is one, thanks.