Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 61,156 through 61,170 (of 66,547 total)

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

Michael L John One Orange Chip Points: 27038 More actions · Answer 1

It's good to know that roads stink world-wide, not just western Pennsylvania!

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/

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

I promise, from what I've seen of your roads, they're in good shape.
I remember a tour group in Scotland, the driver was cursing about the poor quality of the back road he was driving (single-track road near Loch Ness). It was in better shape than any of the highways around JHB.

I keep considering taking a weekend and photographing the potholes I can find and putting them up on twitter. Just mu suburb and the couple around should get me photos for months.

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

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 3

jasona.work - Tuesday, February 27, 2018 10:11 AM
GilaMonster - Tuesday, February 27, 2018 9:34 AM
jasona.work - Tuesday, February 27, 2018 8:09 AM
Well, we're getting ready to go into construction season here, and it's going to be a doozy...
A major east-west freeway is going to have all the westbound lanes closed for the entire summer (April through November) for a 10 mile stretch between two major north-south freeways...
One of the north-south freeways is (still) going to be closed for a big stretch south of the city to replace a bridge (which has desperately needed the work for years)...
There's quite a bit more I'm not even mentioning here...
It's almost to the point of, if someone asks "how do I get there, from here," the answer will be "you can't get there from here."
We're joking about allowing people to work remotely 5 days a week until after the summer...
Sounds fun. One of our major highways (the one running north-south through the center of the city) has been under major renovation for the last 2 years.
It needed doing badly (bridge with gaps forming in the connector plates), but it's made travel a nightmare.
Here's a recent picture of one of the potholes on the bridge they've been working on since last year (it's, I believe, a full-fledged rip up the bridge deck and build a new one job):
(OK, the link to a picture doesn't work for me at work, so)
https://goo.gl/images/wQP3jP

BWAAA-HAAAA!!!! "RBAR on the road"! 😉

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

jasona.work SSC Guru Points: 50083 More actions · Answer 4

GilaMonster - Tuesday, February 27, 2018 1:53 PM
I promise, from what I've seen of your roads, they're in good shape.
I remember a tour group in Scotland, the driver was cursing about the poor quality of the back road he was driving (single-track road near Loch Ness). It was in better shape than any of the highways around JHB.
I keep considering taking a weekend and photographing the potholes I can find and putting them up on twitter. Just mu suburb and the couple around should get me photos for months.

I'll be honest, I'm in one of the northern 'burbs and the roads, in the main, are decent out here. Except for the main roads that see a LOT of traffic and especially a LOT of truck traffic. Those in many places can rattle your fillings out of your teeth and your car into itty-bitty pieces...

And, at least the roads where I work are in quite decent shape (considering they were presumably designed to support 72ton tanks driving on them) although many of the parking lots could stand a rip-out and replace...

Neil Burton SSC-Insane Points: 22908 More actions · Answer 5

GilaMonster - Tuesday, February 27, 2018 1:53 PM
I promise, from what I've seen of your roads, they're in good shape.
I remember a tour group in Scotland, the driver was cursing about the poor quality of the back road he was driving (single-track road near Loch Ness). It was in better shape than any of the highways around JHB.
I keep considering taking a weekend and photographing the potholes I can find and putting them up on twitter. Just mu suburb and the couple around should get me photos for months.

The town where my parents live had\have this crusader on the council's back. He was most active a couple of years ago but they still pop up (so to speak) occasionally. To warn you, it's a valid news site but some of his art may be a little on the NSFW side 😀

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

Sergiy SSC Guru Points: 110206 More actions · Answer 6

Sean Lange - Tuesday, February 27, 2018 8:58 AM
We have had two incredibly major renovations to the highway around KC for over a decade now. This has been a real engineering marvel as the project has crossed state boundaries and they have had to coordinate everything. There was even a website to track progress on the Missouri side. They finished the Missouri side a few years ago and have another couple of years on the Kansas side until it is complete. Glad I don't have to commute through that mess.

What about commuting over this beautiful bridge?

Amur Bridge
https://en.wikipedia.org/wiki/Amur_Bridge_Project

_____________
Code for TallyGenerator

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 7

SQL in the City today, if you have time: https://www.youtube.com/watch?v=0qyMutBkZsg

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 8

Sergiy - Wednesday, February 28, 2018 5:30 AM
Sean Lange - Tuesday, February 27, 2018 8:58 AM
We have had two incredibly major renovations to the highway around KC for over a decade now. This has been a real engineering marvel as the project has crossed state boundaries and they have had to coordinate everything. There was even a website to track progress on the Missouri side. They finished the Missouri side a few years ago and have another couple of years on the Kansas side until it is complete. Glad I don't have to commute through that mess.
What about commuting over this beautiful bridge?
Amur Bridge
https://en.wikipedia.org/wiki/Amur_Bridge_Project

Heh... guess they're not "rushin" to finish. 😉

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

jasona.work SSC Guru Points: 50083 More actions · Answer 9

Ugh, users...

Them: Yeah, we can't get our reports from SSRS, we're getting an error.
Me: OK, have the reports worked at all since we moved to the new servers, or has no one run a report in the last few months?
Them: {dead air, and you wonder if they're still alive}

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

jasona.work - Thursday, March 1, 2018 8:49 AM
Ugh, users...
Them: Yeah, we can't get our reports from SSRS, we're getting an error.
Me: OK, have the reports worked at all since we moved to the new servers, or has no one run a report in the last few months?
Them: {dead air, and you wonder if they're still alive}

Did you ever get an answer?

Greg Edwards-268690 SSC-Insane Points: 20676 More actions · Answer 11

jasona.work - Thursday, March 1, 2018 8:49 AM
Ugh, users...
Them: Yeah, we can't get our reports from SSRS, we're getting an error.
Me: OK, have the reports worked at all since we moved to the new servers, or has no one run a report in the last few months?
Them: {dead air, and you wonder if they're still alive}

Maybe it's not a bad idea to get some user testing and sign off process for any upgrades / changes.
Or possibly you have that already and have someone else to ask about how they tested.
We used to always do some stub testing on our own, to avoid the chance that a user signed off but never tested.

A report that is never run only becomes a crisis when someone finds it is broken.
Hope it's a simple fix like connection strings.

jasona.work SSC Guru Points: 50083 More actions · Answer 12

Lynn Pettis - Thursday, March 1, 2018 11:11 AM
Did you ever get an answer?

Nope, probably just try asking again in a bit. The problem is, I'm now having problems getting to the server that hosts the SSRS (working from home today,) so that's going to make things even *more* interesting.
And, I work from home again tomorrow because they're doing upgrades to the office network, so rather than sitting around for an hour or two with no network access, they're having me work from home (remote access won't be impacted.)

Greg Edwards-268690 - Thursday, March 1, 2018 11:21 AM
Maybe it's not a bad idea to get some user testing and sign off process for any upgrades / changes.
Or possibly you have that already and have someone else to ask about how they tested.
We used to always do some stub testing on our own, to avoid the chance that a user signed off but never tested.
A report that is never run only becomes a crisis when someone finds it is broken.
Hope it's a simple fix like connection strings.

The annoying part is, I'm 99% sure when we migrated to the new server several months ago, I had this person check the reports and they were working. BUT none of the users use the reports very often for this application, so they could've broke shortly after, or just recently, or somewhere in-between.
We checked the strings first, he had thought it was going to the wrong server (the old SSRS instance,) then realized he was looking at the QA system (which is / was pointing at a non-existent SSRS.) The datasource is pointing at the right server, the reports he mentioned are pointing at the datasource, so that shouldn't be the problem. I'm leaning towards somewhere between the new server and now, a network rule was changed or tightened up, and now it's broken SSRS.
And, I can't check with another customer as he's the only one using that SSRS instance...

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

Lynn Pettis

SSC Guru

Points: 442467

March 2, 2018 at 9:43 am

#1981784

Ghost in the machine

Sean Lange SSC Guru Points: 286573 More actions · Answer 14

Lynn Pettis - Friday, March 2, 2018 9:43 AM
Ghost in the machine

They seem to be just asking random questions.

https://www.sqlservercentral.com/Forums/1925877/is-it-possible-to-limit-the-size-of-the-sql-server-log-in-megabytes

_______________________________________________________________

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/

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