Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 64,621 through 64,635 (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

MVDBA (Mike Vessey) wrote:

but empty aircraft - that's a lot of fuel dumped into the atmosphere - maybe regulators might look at that idea and pay operators to not fly unnecessary flights

My understanding as to what drives the empty flights is, it's not just the departure times as others mentioned, it's also that the airlines schedules expect that plane to be at another airport and ready to pick up more passengers at a certain time.

So aircraft A departs airport A at 8am, arrives at airport B, unloads, and needs to be back in the air with a new load of passengers who unloaded from aircraft C 30 minutes before.

It's why a broke down plane causes such a ripple effect in delayed flights...

So even if people weren't cancelling because of Covid, if a flight is empty it'll still depart on time...

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

Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server? Also, any idea if they support 2019 yet?

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

frederico_fonseca SSCoach Points: 16155 More actions · Answer 3

Jeff Moden wrote:

Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server? Also, any idea if they support 2019 yet?

According to licensing terms Developer only on a dedicated host https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Concepts.General.Licensing.html

and it looks like 2017 only

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

Jeff Moden wrote:

Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server? Also, any idea if they support 2019 yet?

Last time I worked on it, it was 2017

😎

Jeff Moden SSC Guru Points: 1004360 More actions · Answer 5

Thanks folks. Still looking to find out if AWS RDS will support the Developers Edition or not. I'd look for myself but I don't yet have access.

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

frederico_fonseca SSCoach Points: 16155 More actions · Answer 6

Jeff Moden wrote:

Thanks folks. Still looking to find out if AWS RDS will support the Developers Edition or not. I'd look for myself but I don't yet have access.

I think it is clear from the link I gave

Because of licensing requirements, we can't offer SQL Server Developer edition on Amazon RDS.

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

Ah... thanks. I totally missed the link.

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

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 8

as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

Phil Parkin ducked out way too early on that request.

MVDBA

Thom A SSC Guru Points: 99130 More actions · Answer 9

MVDBA (Mike Vessey) wrote:

as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.

Not sure if that beats the conversation I just had on the phone, where they asked me to spell someone's email address, because they "couldn't open more than one email at a time in Outlook" to copy and paste the email I'd sent them with said email address in it. >_<

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

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

MVDBA (Mike Vessey) wrote:

as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
...

Really depends on the RDBMS being used. At one point in my past when working with Oracle, it treated the empty string as null which is different from how MS SQL Server treats it. This initially caused me some issues as I was used to how SQL Server did things. Also, I believe there are setting that can change this behavior.

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 11

Thom A wrote:

MVDBA (Mike Vessey) wrote:
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.
Not sure if that beats the conversation I just had on the phone, where they asked me to spell someone's email address, because they "couldn't open more than one email at a time in Outlook" to copy and paste the email I'd sent them with said email address in it. >_<

seriously Thom - you are just plain lazy - you should have hand delivered it in triplicate with a braille copy in case they were blind (as well as stupid) - none of this fancy copy/paste stuff for our users

MVDBA

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 12

Lynn Pettis wrote:

MVDBA (Mike Vessey) wrote:
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
...
Really depends on the RDBMS being used. At one point in my past when working with Oracle, it treated the empty string as null which is different from how MS SQL Server treats it. This initially caused me some issues as I was used to how SQL Server did things. Also, I believe there are setting that can change this behavior.

it was SQL server - 2017, turns out the issue was he was coding in VB and passing the VB version of NULL (emptystring) and not DBNULL

hence set firstname=isnull(@firstname,firstname)

didn't work how he expected.

MVDBA

Thom A SSC Guru Points: 99130 More actions · Answer 13

MVDBA (Mike Vessey) wrote:

seriously Thom - you are just plain lazy - you should have hand delivered it in triplicate with a braille copy in case they were blind (as well as stupid) - none of this fancy copy/paste stuff for our users

I would rather they were blind... Instead they're in charge of Payroll and expenses. :'(

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Phil Parkin SSC Guru Points: 246962 More actions · Answer 14

MVDBA (Mike Vessey) wrote:

as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.

Hahaha, had to 'duck out' of the office for a couple of hours and missed all the fun ...

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

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 15

Phil Parkin wrote:

MVDBA (Mike Vessey) wrote:
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.
Hahaha, had to 'duck out' of the office for a couple of hours and missed all the fun ...

took your time to wade in at the end 🙂

MVDBA