Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 57,001 through 57,015 (of 66,712 total)

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

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

Luis Cazares (12/27/2016)
Carrie Fisher is now one with the force.[/url] :crying:
Can 2016 end already?

Nah, its still got 4 more days to go and it wants to eat the soul of at least one famous person a day...

SQLBill SSC Guru Points: 51440 More actions · Answer 2

jasona.work (12/27/2016)
Luis Cazares (12/27/2016)
Carrie Fisher is now one with the force.[/url] :crying:
Can 2016 end already?
Nah, its still got 4 more days to go and it wants to eat the soul of at least one famous person a day...

and add Richard Adams 'Watership Down' author to the list.

-SQLBill

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

Luis Cazares (12/27/2016)
Carrie Fisher is now one with the force.[/url] :crying:
Can 2016 end already?

I hope it ends soon.

🙁

djj SSCoach Points: 18831 More actions · Answer 4

Okay now Debbie Reynolds. This year has seen more than its fair share of departures.

Gazareth One Orange Chip Points: 27737 More actions · Answer 5

djj (12/29/2016)
Okay now Debbie Reynolds. This year has seen more than its fair share of departures.

Mother and Daughter within a couple of days of each other. Just brutal for the family 🙁

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

What is this, a free consultancy?

http://www.sqlservercentral.com/Forums/Topic1846082-2799-2.aspx

Strewth. Where's my popcorn?

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

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

ThomasRushton (12/30/2016)
What is this, a free consultancy?
http://www.sqlservercentral.com/Forums/Topic1846082-2799-2.aspx
Strewth. Where's my popcorn?

No. It's someone with a very appropriate login handle.

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

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

Man, I hope they get the new system they're working on in place soon. The SPAM has been brutal and I know I'm not the only monitor hiding it. They need to change the signage on the home page. It should read...

[font="Arial Black"]A Microsoft SQL Server community of 76,417 DBAs, developers and SQL Server users and 1,800,000 spammers. [/font]

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

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

Jeff Moden (12/31/2016)
Man, I hope they get the new system they're working on in place soon. The SPAM has been brutal and I know I'm not the only monitor hiding it.

And it's pretty steady, too. It isn't posted all at once, but over time. I've cleared out a bunch of it in two separate sessions just this morning.

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

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

I hope everyone had a safe and happy New Year celebration. Welcome back to work.

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

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

Ed Wagner (1/3/2017)
I hope everyone had a safe and happy New Year celebration. Welcome back to work.

You too, Ed. Best wishes for 2017.

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

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

Ed Wagner (1/3/2017)
I hope everyone had a safe and happy New Year celebration. Welcome back to work.

Back to work for a bit of a rest? 🙂 Have a good 2017, all

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

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

Jeff Moden (12/31/2016)
Man, I hope they get the new system they're working on in place soon. The SPAM has been brutal and I know I'm not the only monitor hiding it. They need to change the signage on the home page. It should read...
[font="Arial Black"]A Microsoft SQL Server community of 76,417 DBAs, developers and SQL Server users and 1,800,000 spammers. [/font]

Many thanks to you, Ed and anyone else bearing this task. I was never approached to help. The real downside is that overall it really seems like the number of questions has significantly decreased over the last 6-12 months. Hopefully this is just a trend and it will turn around in the near future.

_______________________________________________________________

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/

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

Happy New Year, and hope you are ready for another exciting year. Or great year. Or just a year.

Quiet here, managed to finish a 5k Sunday and then take it easy, avoiding work until today.

Michael L John One Orange Chip Points: 27055 More actions · Answer 15

Just putting the finishing touches on a new reporting server.

I run this old legacy ETL process that nobody knows about, and nobody remembers, when this error occurs:

Msg 4121, Level 16, State 1, Procedure ETL_sp_Source_Dimensions_AT, Line 1168 [Batch Start Line 0]

Cannot find either column "Master" or the user-defined function or aggregate "Master.dbo.fn_WorkDays", or the name is ambiguous.

Msg 4121, Level 16, State 1, Procedure ETL_sp_Update_Offline_Data, Line 57 [Batch Start Line 0]

Cannot find either column "Master" or the user-defined function or aggregate "Master.dbo.fn_WorkDays", or the name is ambiguous.

What? Why would they create this function in master? It's probably loops and cursors and lots of other bad stuff.

I open the function, and this appears in the comments:

Revisions:

Rev 00 - 12/12/2004 - Jeff Moden - Initial creation and test.

Rev 01 - 12/12/2004 - Jeff Moden - Load test, cleanup, document, release.

Rev 02 - 12/26/2004 - Jeff Moden - Return NULL if @StartDate is NULL or DEFAULT and

modify to be insensitive to DATEFIRST settings.

*

Well, no loops here!

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/