Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 60,076 through 60,090 (of 66,710 total)

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

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

ZZartin - Thursday, October 5, 2017 7:51 AM
guh.... I just had a senior DBA type person ask, after breaking a file extract in prod.

What difference does the order of the fields make?
:crying::crying:

So I'm guessing that you don't build import routines which can accept any number of columns, with any datatypes, in any order? Amateur! 🙂

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

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

Phil Parkin - Thursday, October 5, 2017 8:00 AM
ZZartin - Thursday, October 5, 2017 7:51 AM
guh.... I just had a senior DBA type person ask, after breaking a file extract in prod.

What difference does the order of the fields make?
:crying::crying:
So I'm guessing that you don't build import routines which can accept any number of columns, with any datatypes, in any order? Amateur! 🙂

To be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have 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)

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

p.s. Kick the slats off that DBA. (S)he should bloody well know better not to develop in production and that code should be thoroughly tested prior to deployment to production.

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

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

ZZartin - Thursday, October 5, 2017 7:51 AM
guh.... I just had a senior DBA type person ask, after breaking a file extract in prod.

What difference does the order of the fields make?
:crying::crying:

<singing>As someday it may happen that a victim must be found...</singing>

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

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 5

Jeff Moden - Thursday, October 5, 2017 2:28 PM
To be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have happen.

Dun and Bradstreet comes to mind. We'd send out info for matches, and what we got back was rarely formatted the same way.
I would have thought with the line of business they are in, they would have been better.

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 6

Greg Edwards-268690 - Friday, October 6, 2017 10:30 AM
Jeff Moden - Thursday, October 5, 2017 2:28 PM
To be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have happen.
Dun and Bradstreet comes to mind. We'd send out info for matches, and what we got back was rarely formatted the same way.
I would have thought with the line of business they are in, they would have been better.

When you get paid more for each custom file you build than for just reusing the standard extract, conformity and standardization are not your priority😛

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

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

Greg Edwards-268690 - Friday, October 6, 2017 10:30 AM
Jeff Moden - Thursday, October 5, 2017 2:28 PM
To be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have happen.
Dun and Bradstreet comes to mind. We'd send out info for matches, and what we got back was rarely formatted the same way.
I would have thought with the line of business they are in, they would have been better.

Oh, don't mention D&B. I get flashbacks to the various times I spent working on projects there... And I'm not surprised.

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

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

So came across an article on a new programming language someone's working on. I wonder if it'd be possible to get a "wrapper" for TSQL so we could use it for coding?
http://www.theregister.co.uk/2017/10/09/fetlang_erotic_programming_language/
Imagine the fun of code reviews?
:hehe:

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

jasona.work - Tuesday, October 10, 2017 6:11 AM
So came across an article on a new programming language someone's working on. I wonder if it'd be possible to get a "wrapper" for TSQL so we could use it for coding?
http://www.theregister.co.uk/2017/10/09/fetlang_erotic_programming_language/
Imagine the fun of code reviews?
:hehe:

For some reason, that link isn't working. http://www.theregister.co.uk/2017/10/09/fetlang_erotic_programming_language

And yes, it could be quite interesting (I see another quirk of SSC today is that all my text is now a hyperlink... Good!). I dred to think what an "INSERT" statement woudl be. O.o

Thom~

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

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

This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html

ZZartin SSC-Dedicated Points: 30920 More actions · Answer 11

Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AM
This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html

So..... excel is even more terrible than we already knew?

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 12

Perhaps. I think Excel is great in many ways. More, I think the idea of programming as a part of basic applications is a bad idea.

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 13

Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AM
This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html

Wow! Just ... WOW! Thanks for posting that.

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

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

Jeff Moden - Tuesday, October 10, 2017 11:14 AM
Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AM
This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
Wow! Just ... WOW! Thanks for posting that.

I had a go at this with the calc injection. Excel did warn me, which is good, and I therefore had the option. For it not to happen. I wonder, however, what might happen in different environments. I can imagine Excel 2007 not being as clever.

Thom~

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

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

Thom A - Tuesday, October 10, 2017 11:45 AM
Jeff Moden - Tuesday, October 10, 2017 11:14 AM
Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AM
This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
Wow! Just ... WOW! Thanks for posting that.
I had a go at this with the calc injection. Excel did warn me, which is good, and I therefore had the option. For it not to happen. I wonder, however, what might happen in different environments. I can imagine Excel 2007 not being as clever.

Are people still using Office 2007?

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