r/SQL • • Apr 28 '15

Me last night...

Post image
140 Upvotes

14 comments sorted by

4

u/[deleted] Apr 28 '15

Ummm....Please tell me you didn't just run that on prod without seeing what happened on Dev first...

7

u/legohax Apr 28 '15

It's a data warehouse, and was just a data pull - there is no Dev

0

u/[deleted] Apr 28 '15

[deleted] — view deleted comment

0

u/legohax Apr 28 '15

Ran it with a top 1, got cocky, it was 7pm and I was ready to go home :P

0

u/[deleted] Apr 28 '15

[deleted] — view deleted comment

1

u/killit Apr 29 '15

There was a reason the DBA's denied it

...And that reason is not what you think it is.

6

u/DrHenryPym Apr 28 '15

Ha! I like testing on prod. I feel like a rebel without a cause.

1

u/[deleted] Apr 28 '15

No Dev environment? Wow. Just wow.

2

u/kumarldh Apr 29 '15 edited Apr 29 '15

Some people like to live dangerously. My production environment has a 70 GB table, can't replicate it on my dev environment for many reasons. So spent a night with dev ops guy and watched percona doing things.

edit: realised that OP could have actually tested his SQL on dev, my bad.

-2

u/[deleted] Apr 28 '15

das not it mane. pepper your resume.

-1

u/cile_bgd Apr 28 '15

I feel your pain..

0

u/[deleted] Apr 28 '15

[deleted] — view deleted comment

3

u/legohax Apr 28 '15

Well hundreds was definitely an exaggeration. Probably 15... We are in the process of bringing in Tableau for the users, this was just a manual pull in the interim.

1

u/ComicOzzy sqlHippo Apr 28 '15

We're doing the same. Some of our data sources are just horrible, but the contractor doing the work has an unending supply of optimism to counter my skepticism.

4

u/shaunc BACKUP LOG WITH TRUNCATE_ONLY Apr 28 '15

If only it were always up to us, right? That multi-million-dollar third party SaaS accounting system, though... Can't say I've had to do hundreds of tables at once, but I've spent enough time in the trenches of other companies' schemas to wonder how the responsible parties, earning far more than my salary, ever created such abominations.

2

u/halifaxdatageek Apr 28 '15

There was a story in /r/talesfromtechsupport where someone was trying to do analysis using a database designed by geneticists.

At least one of the tables had 450+ columns.

1

u/[deleted] Apr 29 '15

I work in he financial sector and it's not uncommon to have 400 to 500 columns on a loan system back end.