Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 58,801 through 58,815 (of 66,712 total)

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

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

jasona.work - Thursday, June 1, 2017 1:38 PM
GilaMonster - Wednesday, May 31, 2017 2:16 PM
I give up. Is what I asked so hard?
Fortunately I'm going to be mostly offline for the next couple days, giving training in Cape Town
Maybe something will have materialised by the time I get home.
Apparently so according to the information...
I could swear I saw the steam coming out of Gails' ears in her last reply to this person...

What gave that idea? The caps or the exclamation points?

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

Mr. Brian Gale SSC-Insane Points: 24800 More actions · Answer 2

GilaMonster - Thursday, June 1, 2017 1:45 PM
jasona.work - Thursday, June 1, 2017 1:38 PM
GilaMonster - Wednesday, May 31, 2017 2:16 PM
I give up. Is what I asked so hard?
Fortunately I'm going to be mostly offline for the next couple days, giving training in Cape Town
Maybe something will have materialised by the time I get home.
Apparently so according to the information...
I could swear I saw the steam coming out of Gails' ears in her last reply to this person...
What gave that idea? The caps or the exclamation points?

I think your signature is quite appropriate:
We walk in the dark places no others will enter

That thread reminds me of the days when I worked in IT... "Click on Help->About and read me the version number" "It is asking me which file I want to open..." "hit cancel, and then click on help->about" "I did that and it is asking me which file to open" "Ok, that is strange. I'll be right over to see what is happeneing" And then when I get to their desk - SURPRISE - by some voodoo magic it works.

The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

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

GilaMonster - Thursday, June 1, 2017 1:45 PM
jasona.work - Thursday, June 1, 2017 1:38 PM
GilaMonster - Wednesday, May 31, 2017 2:16 PM
I give up. Is what I asked so hard?
Fortunately I'm going to be mostly offline for the next couple days, giving training in Cape Town
Maybe something will have materialised by the time I get home.
Apparently so according to the information...
I could swear I saw the steam coming out of Gails' ears in her last reply to this person...
What gave that idea? The caps or the exclamation points?

I think the first three words of your reply...
Then the caps and the exclamation points.
The OP of that topic is the sort of person that drives people away from helping others.

DesNorton SSC-Insane Points: 24387 More actions · Answer 4

I am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.

To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.

How to post data/code on a forum to get the best help.

rodjkidd SSCoach Points: 15916 More actions · Answer 5

DesNorton - Friday, June 2, 2017 1:38 AM
I am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.
To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.

Hi Des,
I did a couple of weeks in Chicago, with SQL Skills. Pretty sure it was earlier in the year. I spent one day downtown on the Saturday in between... I got sunburnt! Even with it being the windy city. Pasty Englishman on holiday - what can I say. I found the weather very pleasant. I'm assuming they are using the same Hilton Homeward Suites. Just remember its nowhere near the airport or downtown Chicago. So taxi's everywhere. Although I think there is a train station nearby. There is a nice shopping mall nearby including a Cheesecake factory. Which defeated John Martin. The hotel is nice enough.
Bellevue, I can't say. But its a bit more north of Seattle if my geography is correct. And Seattle in October is pleasant enough even when its raining. But then I'm used to the British summers 😉

I'm not sure I can praise the training enough! You will have a blast.
On the middle Friday I went downtown to Reggie's to see Sound of Contact perform - this is Simon Collins (son of Phil) current project. Ticket was 15 dollars. Limo service via the hotels preferred company - 75 dollars each way! Possibly not what I was expecting! Great gig though. :O

Rodders...

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

rodjkidd - Thursday, June 1, 2017 6:11 AM
I've managed to make it through the random draw for a ticket for tonight's recording of the News Quiz. BBC Radio 4 - to quote Wikipedia - "a British topical panel game"
The only problem is you aren't guaranteed to get in! You have to make sure you are there "early enough". Jumping on the 3:20 train to that there London, and therefore having to leave the office early. Then a nice walk to the Radio Theatre.
I've been in the audience for a few BBC radio shows. But this is the first time for The News Quiz. Should be a lot of fun, considering what's been going on lately. Although next weeks is taking place on election night, so that's going to be interesting. I've almost missed the cut off point once. While I was waiting to find out if I got in, I was trying to work out what I was going to do if I didn't get. Return ticket on the train for a specified time, so no catching an early one back! Much like today.
I looking forward to it.
😀
Rodders...

So, young Rodders... how was the show?

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 7

rodjkidd - Friday, June 2, 2017 2:17 AM
DesNorton - Friday, June 2, 2017 1:38 AM
I am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.
To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.
Hi Des,
I did a couple of weeks in Chicago, with SQL Skills. Pretty sure it was earlier in the year. I spent one day downtown on the Saturday in between... I got sunburnt! Even with it being the windy city. Pasty Englishman on holiday - what can I say. I found the weather very pleasant. I'm assuming they are using the same Hilton Homeward Suites. Just remember its nowhere near the airport or downtown Chicago. So taxi's everywhere. Although I think there is a train station nearby. There is a nice shopping mall nearby including a Cheesecake factory. Which defeated John Martin. The hotel is nice enough.
Bellevue, I can't say. But its a bit more north of Seattle if my geography is correct. And Seattle in October is pleasant enough even when its raining. But then I'm used to the British summers 😉
I'm not sure I can praise the training enough! You will have a blast.
On the middle Friday I went downtown to Reggie's to see Sound of Contact perform - this is Simon Collins (son of Phil) current project. Ticket was 15 dollars. Limo service via the hotels preferred company - 75 dollars each way! Possibly not what I was expecting! Great gig though. :O
Rodders...

Hilton Homewood suites? Haha that reminds me - last autumn myself and the mrs, her sister and SO, and their parents, stayed for a long weekend in the Homewood Suites in Manhattan. Her indoors has acquired some fame for her snoring. I don't usually snore but had a cold, and with the fairly serious drinking I was keeping up with Jules. After a first night of hell, we decided to take it in turns to kip on the bathroom floor.
In a Â£350 a night hotel...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

rodjkidd SSCoach Points: 15916 More actions · Answer 8

The News Quiz was a blast.
After my arriving late for Roger Hodgson gig at the Royal Albert Hall a few weeks ago, I've been very wary on not being late. To the extent I've been far too early!
So got the train ok. It arrived and left on time!
A nice walk along Baker street, and of course I got there far too early...
4 people in the queue, five by the time I walked past. So decided to spend a little bit of time on Oxford Street. Doors were 6:15 - joined the queue at 5:15.They let us in early due to extra security.
For anyone who hasn't been to a BBC show to join the audience its done all very BBC. You get given a numbered sticker. Once you have that you can decide to go in or come back just before the theatre doors open. I was number 39 - this is important later.
I decided to go as, contrary to popular belief the food there isn't too bad! bag scanned and airport style security now in place. Got through with no problems and joined the queue at the café. Only they don't do food anymore, just snacks, cakes, tea, coffee and alcohol! Oh well. quick check that I leave and come back... yes...
Try number two, went back in, security again. and waited for the doors to open. Then let you in in groups. Production tickets first then the first 50 numbered stickers, next 50 extra. See I told you 39 was important. Ended up 3 rows from the front.
The producer comes out as the warm and tells us this is only his second show and last weeks was terrible.
Then the host and the panel. They are semi prepared I discovered, so not all the funny lines and wit are off the cuff!
They also prepare a lot of stuff that just can't be broadcast. Either due to subject matter or language .
One silly highlight was Miles, the chairman, went to ask the next question and his piece of paper was blank.... The producer had to come running through with his laptop and show him the question... In the meantime he said something like "so the question we discussed on the phone two days ago, would you like to answer it?"
There were also some great moments where Miles couldn't stop laughing himself and had to take a moment before composing himself again.
Also he went to move on to the next question and the producers voice came over the speakers asking him do a little more on the previous question, for the edit... Miles then spent most of the show asking "the boss" to confirm if everything was OK, and could they move on etc. But in a very funny way each time.
They also do this thing where press cuttings or clips are sent in where the meaning doesn't quite come over as intended...
For example:
Police reveal that a woman arrested for shoplifting had a whole salami in her knickers. When asked why, she said it was because she was missing her Italian boyfriend. (Reuters via The Manchester Evenings News)

One of them had to read out a newspaper article from my neck of the woods. Norfolk is a lazy dialect - for example Heigham Street is pronounced Ham Street. But of course.
I missed my moment of fame, they had issues with saying Dereham... I should have shouted out how to say it. as they said it very, very wrong. Its dear-rum - Not Der Ham 🙂
Some true side splitting moment, but I fear they won't make the final cut!
It will be interesting to see how the edit works tonight.
It was over a little earlier than I expected so I ended up having to waste an hour in London as my ticket was for the 22:40 train and no other!

A very funny evening, I'll just remember next time to queue up get my number then go elsewhere for food! And not be too early!

Rodders...

rodjkidd SSCoach Points: 15916 More actions · Answer 9

ChrisM@Work - Friday, June 2, 2017 2:27 AM
rodjkidd - Friday, June 2, 2017 2:17 AM
DesNorton - Friday, June 2, 2017 1:38 AM
I am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.
To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.
Hi Des,
I did a couple of weeks in Chicago, with SQL Skills. Pretty sure it was earlier in the year. I spent one day downtown on the Saturday in between... I got sunburnt! Even with it being the windy city. Pasty Englishman on holiday - what can I say. I found the weather very pleasant. I'm assuming they are using the same Hilton Homeward Suites. Just remember its nowhere near the airport or downtown Chicago. So taxi's everywhere. Although I think there is a train station nearby. There is a nice shopping mall nearby including a Cheesecake factory. Which defeated John Martin. The hotel is nice enough.
Bellevue, I can't say. But its a bit more north of Seattle if my geography is correct. And Seattle in October is pleasant enough even when its raining. But then I'm used to the British summers 😉
I'm not sure I can praise the training enough! You will have a blast.
On the middle Friday I went downtown to Reggie's to see Sound of Contact perform - this is Simon Collins (son of Phil) current project. Ticket was 15 dollars. Limo service via the hotels preferred company - 75 dollars each way! Possibly not what I was expecting! Great gig though. :O
Rodders...
Hilton Homewood suites? Haha that reminds me - last autumn myself and the mrs, her sister and SO, and their parents, stayed for a long weekend in the Homewood Suites in Manhattan. Her indoors has acquired some fame for her snoring. I don't usually snore but had a cold, and with the fairly serious drinking I was keeping up with Jules. After a first night of hell, we decided to take it in turns to kip on the bathroom floor.
In a Â£350 a night hotel...

With the SQL Skills rate it wasn't anywhere near that much... But you still got a big enough bathroom to sleep in! 🙂

Rodders...

rodjkidd SSCoach Points: 15916 More actions · Answer 10

ThomasRushton - Friday, June 2, 2017 2:21 AM
rodjkidd - Thursday, June 1, 2017 6:11 AM
I've managed to make it through the random draw for a ticket for tonight's recording of the News Quiz. BBC Radio 4 - to quote Wikipedia - "a British topical panel game"
The only problem is you aren't guaranteed to get in! You have to make sure you are there "early enough". Jumping on the 3:20 train to that there London, and therefore having to leave the office early. Then a nice walk to the Radio Theatre.
I've been in the audience for a few BBC radio shows. But this is the first time for The News Quiz. Should be a lot of fun, considering what's been going on lately. Although next weeks is taking place on election night, so that's going to be interesting. I've almost missed the cut off point once. While I was waiting to find out if I got in, I was trying to work out what I was going to do if I didn't get. Return ticket on the train for a specified time, so no catching an early one back! Much like today.
I looking forward to it.
😀
Rodders...
So, young Rodders... how was the show?

See my post 😉

I will add Jeremy Hardy was on the show - he was in fine form. Really went for it. if he's on next weeks show (for those who don't know he's a left wing comedian who is on the show more often than not) he'll probably explode! He is also a lot ruder than I expected with the stuff he knows will not be broadcast. I was shocked quite frankly :w00t:

Rodders...

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

bmg002 - Thursday, June 1, 2017 1:52 PM
GilaMonster - Thursday, June 1, 2017 1:45 PM
jasona.work - Thursday, June 1, 2017 1:38 PM
GilaMonster - Wednesday, May 31, 2017 2:16 PM
I give up. Is what I asked so hard?
Fortunately I'm going to be mostly offline for the next couple days, giving training in Cape Town
Maybe something will have materialised by the time I get home.
Apparently so according to the information...
I could swear I saw the steam coming out of Gails' ears in her last reply to this person...
What gave that idea? The caps or the exclamation points?
I think your signature is quite appropriate:
We walk in the dark places no others will enter

It's the Anla'shok oath, from Babylon 5.

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
We live for the One, we die for the One
Entil'zha Veni. In Valen's name.

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

DesNorton SSC-Insane Points: 24387 More actions · Answer 12

rodjkidd - Friday, June 2, 2017 2:17 AM
DesNorton - Friday, June 2, 2017 1:38 AM
I am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.
To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.
Hi Des,
I did a couple of weeks in Chicago, with SQL Skills. Pretty sure it was earlier in the year. I spent one day downtown on the Saturday in between... I got sunburnt! Even with it being the windy city. Pasty Englishman on holiday - what can I say. I found the weather very pleasant. I'm assuming they are using the same Hilton Homeward Suites. Just remember its nowhere near the airport or downtown Chicago. So taxi's everywhere. Although I think there is a train station nearby. There is a nice shopping mall nearby including a Cheesecake factory. Which defeated John Martin. The hotel is nice enough.
Bellevue, I can't say. But its a bit more north of Seattle if my geography is correct. And Seattle in October is pleasant enough even when its raining. But then I'm used to the British summers 😉
I'm not sure I can praise the training enough! You will have a blast.
On the middle Friday I went downtown to Reggie's to see Sound of Contact perform - this is Simon Collins (son of Phil) current project. Ticket was 15 dollars. Limo service via the hotels preferred company - 75 dollars each way! Possibly not what I was expecting! Great gig though. :O
Rodders...

Thanks Rodders.

I'm not much of a tourist - Don't do well with crowds.

How to post data/code on a forum to get the best help.

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

DesNorton - Friday, June 2, 2017 1:38 AM
I am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.
To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.

In August, Chicago can be hot. Not sure about Bellevue. In October, you have a 50-50 chance that weather in Chicago will be pleasant or suddenly (abruptly) freezing as a snow storm or ice storm swings through.

Again, not sure about Bellevue, but I believe it's in rainforest territory, which means rainy and chilly, but not frozen.

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.

rodjkidd SSCoach Points: 15916 More actions · Answer 14

Des,

Another thing, about the books. Depends on the hotel, but most will take mail and parcels for you for a short period before you arrive and while you are there. They may charge you for this.

Rodders...

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

Brandie Tarvin - Friday, June 2, 2017 4:28 AM
DesNorton - Friday, June 2, 2017 1:38 AM
I am from Sunny, Hot & Humid Durban, on the East Coast of South Africa.
I have never crossed the pond, but I may have an opportunity to attend some SQL training in USA.
To help me figure out which one to choose,
1 - What is the weather like in Chicago, IL vs Bellevue, WA in August and October? I don't handle the cold very well.
2 - How difficult would it be for me to purchase books and get them delivered to my hotel? - Postage to ZA is more than the cost of the books.
In August, Chicago can be hot. Not sure about Bellevue. In October, you have a 50-50 chance that weather in Chicago will be pleasant or suddenly (abruptly) freezing as a snow storm or ice storm swings through.
Again, not sure about Bellevue, but I believe it's in rainforest territory, which means rainy and chilly, but not frozen.

Bellevue is just on the East side of Lake Washington. It has the same weather as Seattle. Definitely not rainforest, although there is the only temperate rainforest in North America a couple hours away on the peninsula. People always say that it rains a lot in Seattle. This is sort of true and untrue at the same time. There are lots of rainy days but it almost never rains hard. It is more of a light mist/sprinkle most of the time. In October is can be chilly but not super cold. The problem with winter in the NW is that it is so humid the cold goes to the bone and you can't get warm. October shouldn't be bad at all but given the climate differences you would definitely want a hoodie and/or a jacket. Most likely in the 50s-60s Fahrenheit during the day and dropping 10-15 degrees at night.

_______________________________________________________________

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/