Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,381 through 55,395 (of 66,712 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

tindog (8/17/2016)
ChrisM@Work (8/17/2016)
Luis Cazares (8/17/2016)
Brandie Tarvin (8/17/2016)
Eirikur Eiriksson (8/17/2016)
BrainDonor (8/17/2016)
ChrisM@Work (8/17/2016)
We have git hubs all over the UK. They're also known as Weatherspoons.
You owe me a new keyboard...
😀
...just managed to save mine
😎
I have apparently missed the joke here.
It might be a British thing, with a wrong spelling of Wetherspoons[/url]? (which would make googling it a bit more difficult)
Yes it is, top work Luis. Wetherspoons is known over here for being inhabited all day long by old men because the beer is cheap (it's often very good too). So they are hubs for all the local old gits.
Edit: as Blobby well knows, they are also famous for their stonkingly good breakfasts.
"Good"? I hope that's a joke.

Three or four years ago they did reasonable breakfasts. Now the ones I know do absolutely rubbish breakfasts, the worst and most overpriced in town. There's a nice little pub just up the road from the local Wetherspoons where I am this month, and it does a good breakfast for a lot less than Wetherspoons charges for a not very good one; and it does an excellent large breakfast too, more eggs, more bacon, more sausage, more beans, more toast, and more tomato than Wetherspoons' standard breakfast and it costs quite a bit less too.

Tom

ChrisM@home SSC-Insane Points: 24260 More actions · Answer 2

drew.allen (8/17/2016)
I'm writing an article explaining my solution to Credits and Debits and am looking for two or three people to review it before I submit it. Any takers?
Drew

Definitely.

[font="Arial"]^{Low-hanging fruit picker and defender of the moggies}[/font]

For better assistance in answering your questions, please read this[/url].

Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

BLOB EATER SSChampion Points: 14609 More actions · Answer 3

jasona.work (8/17/2016)
Man, take a week and change off from here, and have a lot to catch up on...
Forums being moved to a new back-end, cheap beer pubs with hair in the food...
At least my back-up DBA (who's an Oracle goddess) was able to keep the nitty-gritty caught up so I wasn't inundated when I got back to work today.

what is the new back-end?? MySQL?

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

Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"

erm... SELECT GETDATE()

Thanks Jeff! Without you, I would never have known that answer.

*cough*

Except the asker then said "no, I just want the date part, no time" And she's running on SQL2005, so no DATE. Bloody users, changing the requirements halfway through the project...

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

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

TomThomson (8/17/2016)
tindog (8/17/2016)
ChrisM@Work (8/17/2016)
Luis Cazares (8/17/2016)
Brandie Tarvin (8/17/2016)
Eirikur Eiriksson (8/17/2016)
BrainDonor (8/17/2016)
ChrisM@Work (8/17/2016)
We have git hubs all over the UK. They're also known as Weatherspoons.
You owe me a new keyboard...
😀
...just managed to save mine
😎
I have apparently missed the joke here.
It might be a British thing, with a wrong spelling of Wetherspoons[/url]? (which would make googling it a bit more difficult)
Yes it is, top work Luis. Wetherspoons is known over here for being inhabited all day long by old men because the beer is cheap (it's often very good too). So they are hubs for all the local old gits.
Edit: as Blobby well knows, they are also famous for their stonkingly good breakfasts.
"Good"? I hope that's a joke.
Three or four years ago they did reasonable breakfasts. Now the ones I know do absolutely rubbish breakfasts, the worst and most overpriced in town. There's a nice little pub just up the road from the local Wetherspoons where I am this month, and it does a good breakfast for a lot less than Wetherspoons charges for a not very good one; and it does an excellent large breakfast too, more eggs, more bacon, more sausage, more beans, more toast, and more tomato than Wetherspoons' standard breakfast and it costs quite a bit less too.

I've never had a bad pint in a Wetherspoons. They're a bit McPub in that you can walk into one anywhere and know what you're going to get. Don't get me wrong, I'll pick the local 'independent' where I can but sometimes the choice of independent can be a bit limited. Up until recently, the only pub in Bury worth refuelling in during an extended sampling of refreshing beverages was the Wetherspoons.

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

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

BLOB_EATER (8/18/2016)
jasona.work (8/17/2016)
Man, take a week and change off from here, and have a lot to catch up on...
Forums being moved to a new back-end, cheap beer pubs with hair in the food...
At least my back-up DBA (who's an Oracle goddess) was able to keep the nitty-gritty caught up so I wasn't inundated when I got back to work today.
what is the new back-end?? MySQL?

You'd have to ask Steve that question...

😀

Brandie Tarvin SSC Guru Points: 173056 More actions · Answer 7

ThomasRushton (8/18/2016)
Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"
erm... SELECT GETDATE()
Thanks Jeff! Without you, I would never have known that answer.
*cough*
Except the asker then said "no, I just want the date part, no time" And she's running on SQL2005, so no DATE. Bloody users, changing the requirements halfway through the project...

*cough*

SELECT CONVERT(DATETIME,CONVERT(CHAR(10),GETDATE(),101),101);

We have that happen all the time in our environment. EDIT: 101 is assuming you're using MM/DD/YYYY in your date formatting. Check BOL under CONVERT to get the code you need if that's not true. We used this in SQL 2000, 2005, etc. Still use it because bloody csv files that need dates formatted for other systems and legacy DATETIME columns that cannot be converted to DATE upon pain of being thrown in the lagoon with the alligator.

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.

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

Brandie Tarvin (8/18/2016)
ThomasRushton (8/18/2016)
Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"
erm... SELECT GETDATE()
Thanks Jeff! Without you, I would never have known that answer.
*cough*
Except the asker then said "no, I just want the date part, no time" And she's running on SQL2005, so no DATE. Bloody users, changing the requirements halfway through the project...
*cough*
SELECT CONVERT(DATETIME,CONVERT(CHAR(10),GETDATE(),101),101);
We have that happen all the time in our environment. EDIT: 101 is assuming you're using MM/DD/YYYY in your date formatting. Check BOL under CONVERT to get the code you need if that's not true. We used this in SQL 2000, 2005, etc. Still use it because bloody csv files that need dates formatted for other systems and legacy DATETIME columns that cannot be converted to DATE upon pain of being thrown in the lagoon with the alligator.

There's this too:

SELECT DATEADD(DAY,DATEDIFF(DAY,0,GETDATE()),0)

^{“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

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

Brandie Tarvin (8/18/2016)
ThomasRushton (8/18/2016)
Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"
erm... SELECT GETDATE()
Thanks Jeff! Without you, I would never have known that answer.
*cough*
Except the asker then said "no, I just want the date part, no time" And she's running on SQL2005, so no DATE. Bloody users, changing the requirements halfway through the project...
*cough*
SELECT CONVERT(DATETIME,CONVERT(CHAR(10),GETDATE(),101),101);
We have that happen all the time in our environment. EDIT: 101 is assuming you're using MM/DD/YYYY in your date formatting. Check BOL under CONVERT to get the code you need if that's not true. We used this in SQL 2000, 2005, etc. Still use it because bloody csv files that need dates formatted for other systems and legacy DATETIME columns that cannot be converted to DATE upon pain of being thrown in the lagoon with the alligator.

I've found that the alligator is usually the best company when such things happen. 😛

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

Steve Jones - SSC Editor SSC Guru Points: 736183 More actions · Answer 10

jasona.work (8/18/2016)
BLOB_EATER (8/18/2016)
jasona.work (8/17/2016)
Man, take a week and change off from here, and have a lot to catch up on...
Forums being moved to a new back-end, cheap beer pubs with hair in the food...
At least my back-up DBA (who's an Oracle goddess) was able to keep the nitty-gritty caught up so I wasn't inundated when I got back to work today.
what is the new back-end?? MySQL?
You'd have to ask Steve that question...
😀

SQL Server. One of the requirements. There were a lot of BB candidates using MySQL or PostgreSQL or something else. Somewhat said we just wanted to be on MSSQL.

Limited us to just a few items. Discourse doesn't run on SQL Server, so that was out. Disappointing as I wanted to fork that and add some items to it.

I think we'll stick with the upgrade to this forum, which seems to be going well. They applied a patch and then went to work on integration with existing code the other day, just a day or two test to see how many things broke.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 11

We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Phil Parkin SSC Guru Points: 246960 More actions · Answer 12

Luis Cazares (8/18/2016)
We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)

Better brush off those OSQL skills.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

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

Funny for the day:

http://www.rd.com/funny-stuff/work-cartoons/[/url]

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.

Steve Jones - SSC Editor SSC Guru Points: 736183 More actions · Answer 14

Luis Cazares (8/18/2016)
We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)

https://chocolatey.org/packages/NugetPackageExplorer

Luis Cazares SSC Guru Points: 183706 More actions · Answer 15

Steve Jones - SSC Editor (8/18/2016)
Luis Cazares (8/18/2016)
We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)
https://chocolatey.org/packages/NugetPackageExplorer

It's not a problem to find the packages, the problem is that I don't have Admin rights on the new laptop and can't install anything without approval through the company appstore.

At least I could recover my previous laptop and I'll use it for some time.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2