Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 61,486 through 61,500 (of 66,712 total)

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

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

Jeff Moden - Sunday, April 29, 2018 1:06 PM
Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't imagine why that might have a Logical Read problem. :D;)

He he, guess both those columns are also VARCHAR:crazy:
😎

So does ORM stand for "Object oriented developer got a Relational database to Mess up"?

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 PM
Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't imagine why that might have a Logical Read problem. :D;)
He he, guess both those columns are also VARCHAR:crazy:
😎
So does ORM stand for "Object oriented developer got a Relational database to Mess up"?

Heh... maybe "Only Relational Mistakes".

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

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

Jeff Moden - Monday, April 30, 2018 8:25 AM
Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 PM
Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't imagine why that might have a Logical Read problem. :D;)
He he, guess both those columns are also VARCHAR:crazy:
😎
So does ORM stand for "Object oriented developer got a Relational database to Mess up"?
Heh... maybe "Only Relational Mistakes".

Ooops, I get those at home all the time😀
😎

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

Eirikur Eiriksson - Monday, April 30, 2018 9:59 AM
Jeff Moden - Monday, April 30, 2018 8:25 AM
Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 PM
Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't imagine why that might have a Logical Read problem. :D;)
He he, guess both those columns are also VARCHAR:crazy:
😎
So does ORM stand for "Object oriented developer got a Relational database to Mess up"?
Heh... maybe "Only Relational Mistakes".
Ooops, I get those at home all the time😀
😎

Cue the MIL jokes 😉

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

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

Lynn Pettis

SSC Guru

Points: 442467

April 30, 2018 at 2:59 pm

#1988709

Well, glad someone decided to reconsider a cursor.

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

ChrisM@Work - Monday, April 30, 2018 10:05 AM
Eirikur Eiriksson - Monday, April 30, 2018 9:59 AM
Jeff Moden - Monday, April 30, 2018 8:25 AM
Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 PM
Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't imagine why that might have a Logical Read problem. :D;)
He he, guess both those columns are also VARCHAR:crazy:
😎
So does ORM stand for "Object oriented developer got a Relational database to Mess up"?
Heh... maybe "Only Relational Mistakes".
Ooops, I get those at home all the time😀
😎
Cue the MIL jokes 😉

Bring them on mate😀
😎

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

Eirikur Eiriksson - Tuesday, May 1, 2018 2:56 AM
ChrisM@Work - Monday, April 30, 2018 10:05 AM
Eirikur Eiriksson - Monday, April 30, 2018 9:59 AM
Jeff Moden - Monday, April 30, 2018 8:25 AM
Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 PM
Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't imagine why that might have a Logical Read problem. :D;)
He he, guess both those columns are also VARCHAR:crazy:
😎
So does ORM stand for "Object oriented developer got a Relational database to Mess up"?
Heh... maybe "Only Relational Mistakes".
Ooops, I get those at home all the time😀
😎
Cue the MIL jokes 😉
Bring them on mate😀
😎

I'll do you one better.... joke that an old MIL would tell...

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

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

Jeff Moden - Tuesday, May 1, 2018 5:39 AM
Eirikur Eiriksson - Tuesday, May 1, 2018 2:56 AM
ChrisM@Work - Monday, April 30, 2018 10:05 AM
Eirikur Eiriksson - Monday, April 30, 2018 9:59 AM
Jeff Moden - Monday, April 30, 2018 8:25 AM
Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 PM
Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't imagine why that might have a Logical Read problem. :D;)
He he, guess both those columns are also VARCHAR:crazy:
😎
So does ORM stand for "Object oriented developer got a Relational database to Mess up"?
Heh... maybe "Only Relational Mistakes".
Ooops, I get those at home all the time😀
😎
Cue the MIL jokes 😉
Bring them on mate😀
😎
I'll do you one better.... joke that an old MIL would tell...

Couch laughter coffee spill
Jeff, now you owe me a keyboard😀
😎
Absolutely brilliant!

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 9

Maybe I should start just changing passwords: https://acawiki.org/Building_successful_online_communities:_Evidence-based_social_design

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

Jeebus Chris, I mean, if it works, it works, but yowza https://www.sqlservercentral.com/Forums/1934310/Upper-Case-Lower-Case?Update=1#bm1934444

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

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

jonathan.crawford - Wednesday, May 2, 2018 6:16 AM
Jeebus Chris, I mean, if it works, it works, but yowza https://www.sqlservercentral.com/Forums/1934310/Upper-Case-Lower-Case?Update=1#bm1934444

If it works, and it's fast, and it's pretty, then it will do for me 😉

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

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

I love my work-from-home days.
Today I came up with a SSIS package to import into a table the SQL Audit files on my servers. I put it together on my home lab (because doing this on our QA or production machines makes me jumpy, if I make a mistake,) tested it on my home lab, then re-created it on my work PC for eventual deployment.
Yeah, it's the sort of thing I could work on, on my own time, but somehow, if it's work-related, I find it easier to apply myself when I'm on my employers time than when it's after work or the weekend...

BrainDonor SSCoach Points: 19254 More actions · Answer 13

jasona.work - Thursday, May 3, 2018 12:44 PM
Yeah, it's the sort of thing I could work on, on my own time, but somehow, if it's work-related, I find it easier to apply myself when I'm on my employers time than when it's after work or the weekend...

Work-related things in work-related time is always a better option.

Steve Hall
Linkedin
Blog Site

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

Work to live, don't live to work.

Definitely need time off, away from work things. Most of our tasks don't need to be done ASAWeSeeThem

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

I can understand some beings like banana flies which life spans around a week to have only limited temporal conception but this one is just too much
😎