The Heap™ – Consultancy ©®

« first day (1911 days earlier) ← previous day next day → last day (3254 days later) »

Michael Green

01:34

@Zane Is the file to be loaded already in key sequence? SQL Server for one has optimisations for this. bcp and BULK INSERT have the ORDER(column [,...n]) directive.

Michael Green

02:02

If the news rows are spread throughout the key range the page splits may become expensive. If there are many non-clustered indexes the DROP could, itself, be expensive.

If the table's empty to start with I would imagine a post-load CREATE would be better than the on-going checks and maintenance during load. Same sort of expense as a REBUILD I'd guess.

POTTERS WHEEL BBC Interlude Film 1950-60s

►

3 hours later…

Andriy M

05:24

@MichaelGreen Fascinating! A little disappointing too, because I actually expected a voice at the end to say, "Back to your normal programming" :)

4 hours later…

James Lupolt

09:53

Erland is presenting at SQLBits this year: sqlbits.com/Sessions/Event15/Dynamic_Search_Conditions

Andriy M

Silver and Bronze sponsors seem difficult to find these days.

Mark Sinkinson

There's a new one in June in London now insidesql.co.uk/schedule

James Anderson

10:13

@JamesLupolt That's a must

dezso

10:24

@AndriyM heh, you persuaded both of them to delete their answers

nice job :)

Andriy M

10:50

@dezso Well, what can I say... They should have known better :D

Seriously, though, the problem is rather interesting, although not very useful in itself

But then exercises rarely are

Shame the OP didn't choose to invest more effort.

Tom V

11:49

@PaulWhite Not sure if that question is a great fit for dba any more now that I've answered. Might be better suited for serverfault or stackoverflow

Paul White

@TomV Seems happy enough here to me.

Tom V

12:06

Since I always lose my headphones or forget them somewhere I ordered 25 for 20€. I'm truly surprised with the quality they are

dezso

12:24

@TomV headphones or earphones?

Tom V

@dezso the in-ear kind

ypercubeᵀᴹ

@TomV could share a link?

Tom V

@ypercubeᵀᴹ aliexpress.com/item/…

ypercubeᵀᴹ

thnx!

Mark Sinkinson

12:42

Anyone in London going to the SQL Supper event tonight?

ypercubeᵀᴹ

@MarkSinkinson not me

Tom V

From their sessions

> Peter Moore was an SQL Server developer of several years' experience prior to accepting a three-month assignment working on a financial system for the Iraqi government. He returned home two and a half years later, having been held hostage by an Iraqi militia for 946 days.

I guess that wasn't in the job description

Mark Sinkinson

@TomV Yeah, that's the one tonight.

Sounds interesting

Tom V

Yes I would love to hear that story

Mark Sinkinson

@TomV Although maths is clearly not someone's strong point...

James Lupolt

13:13

@MarkSinkinson Thought about it, but I think there's a video of his talk online that I've seen somewhere.

I was under the impression that he was an Oracle developer

A acquaintance turned down a contract as a DBA for the new central bank in Libya shortly after Gaddafi was overthrown. Probably a good decision in retrospect

Mark Sinkinson

@JamesLupolt Yeah, The Register has one on Youtube

Crazy people going to work in those areas. I imagine the pay must be astronomical

Andriy M

13:31

Hasn't this been asked recently?

Q: Galera won`t start

MariaDB 10.1. I have 3 nodes: KVM-1 wsrep_on=ON binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 query_cache_size=0 query_cache_type=0 innodb_log_file_size=100M innodb_file_per_table innodb_flush_log_at_trx_commit=2 wsrep_provider=/usr...

Can't find it, may have been deleted. But the list of KVM-1, -2 etc. looks familiar

2 hours later…

Max Vernon

15:21

@TomV for that price who cares if you lose a couple a week!

Mark Sinkinson

15:46

@TomV You can have a different colour for each day of the week!

Nick Chammas

We've carved out an area in a Vertica database for our analysts to play around in, and one thing I'd like to empower them to do on their own is import files as tables and do other very basic data import/export and updates.

I'm looking for a GUI tool that's accessible to the non-expert database user. Does anyone have any recommendations? I see that [DbVis](http://www.dbvis.com/doc/vertica-database-features/) offers the basic table import/export I'm looking for. I wonder if anyone here has used it or similar tools.

Andriy M

16:26

@NickChammas @Kermit might be the only regular (who's been somewhat irregular recently) to have something to suggest.

swasheck

17:03

how does one strikethrough in chat?

bluefeet

---text---

will become ~~text~~

swasheck

thanks

MongoDB ~~replication~~ seems to be abnormal

ypercubeᵀᴹ

@swasheck what bluefeet said. But doens't work if you have Ctl-Enters, as all markup.

Erik

is it even possible to use SSIS with Oracle? dba.stackexchange.com/q/133699/72091

I always assumed it was a SQL Server specific tool

Nick Chammas

@AndriyM I think any tool that can connect via JDBC should be usable. Doesn't have to be made specifically for Vertica.

@Erik SSIS has connectors to all kinds of data sources and sinks, I believe.

Max Vernon

17:18

@NickChammas yep, for instance you could use it to connect to Outlook.

Nick Chammas

@MaxVernon Wow.

SSIS, the IFTTT of the Enterprise™.

swasheck

> IFTTT connects the apps you love

i hate outlook so i guess not

Erik

17:43

@NickChammas @MaxVernon Interesting thanks

billinkc

@Erik There are two sets of connectors for Oracle, the slow ones and the fast ones (attunity). Beyond that, I can't say much about it as I have dodged the Oracle bullet for all of my SSIS work

Erik

@billinkc Well so far I've managed to dodge the SSIS bullet. :)

That is great that they've created a tool that is powerful, and flexible enough to be used with so many different data sources. One day I'm sure I'll end up biting the bullet and learn it.

Andriy M

18:08

People are voting to migrate this to SO. It's off-topic here but I think it's also rubbish in terms of quality:

-1

Q: wamp server/ mysql

I Have a problem of Undefined index: UserId in C:\wamp\www\Ribe\edit_teacher.php on line 74. And my code is: if (isset($_POST['update'])){ $FName = $_POST['FName']; $LName = $_POST['LName']; $Id = $_POST['Id']; $Add = $_POST['Add']; $Bus = $_POST['Bus']; $Phon = $_POST[...

mysql-5.5

Erik

@AndriyM I agree on both accounts.

swasheck

WTF????? a @gbn sighting???

gbn

he he

Evening all

Paul White

sneaky

Nick Chammas

Hi @gbn!

gbn

18:13

I've lost COTW's email. Will SMS him

I've been, er, busy

Lordy, still number 3

Andriy M

@gbn What did you expect?

swasheck

better than being number 2

gbn

@AndriyM Number 35?

Lamak

@gbn your reputation precedes you

or something like that

swasheck

@Lamak not sure the us has much of a shot this evening

Lamak

18:19

@swasheck is it against guatemala?

swasheck

yeah. and they just humiliated us.

i think klinsmann has lost the team

Lamak

@swasheck ah, yeah, friday?

swasheck

yep

Lamak

yup, I remember reading about it and it surprised me

swasheck

we have friends from guate who like to cheer for their national team but never really have much hope and just cheer for the us ... they were beside themselves on friday

Lamak

18:23

I can imagine

we had a bitter night too

swasheck

yeah. sorry. my son's a HUGE messi fan so he was thrilled to see the result

Lamak

@swasheck I'll never forgive you!!

I mean....it doesn't matter at all

swasheck

@Lamak i'm sure you will. at some point.

@Lamak at least it wasn't brazil ;)

Lamak

yeah, we have that going on for us

swasheck

but you're already qualified, right?

Lamak

18:29

nope

not at all

swasheck

i thought you won conmebol which was an automatic bid

Lamak

not to the world cup

swasheck

<---- ignorant yankee

Tom V

19:11

@Erik Honestly you should. I see people roll their own whatever for stuff that could easily (and less error-prone/more log-friendly) be done using SSIS

@swasheck Yeah you guys even call a game where you run with the ball in your hands "football"

swasheck

@TomV we're getting more nuanced now. football vs. futbol

Tom V

Not only that, the ball isn't even round

Andriy M

@swasheck Shouldn't it be Fußball?

swasheck

@AndriyM depends on whom you ask. our region would say no

Tom V

@swasheck Nuanced, you??!?

swasheck

19:24

as nuanced as a sledgehammer

our calendar table/date dimension has 95 columns. hoh leee carp

Lamak

@swasheck I mean, they could make it 100 for f**'s sake

swasheck

srsly

lazy underachieving nincompoops

Lamak

still, quite some columns

Erik

@TomV I'll check it out sooner then. In my mind that was mostly a bulk loader tool, but I'm probably wrong.

Tom V

@Erik It has it's quirks, but as a workflow like driven data manipulation thing it's OK

Erik

19:33

@TomV alright I'll give it a chance.

swasheck

19:46

what if i ride? what if you walk?

Tom V

Maybe you're crazy in the head, baby :)

swasheck

nobody puts baby in the corner

Tom V

Nobody tells you what to do, baby

I suppose you were referring to the REM song

swasheck

i was ... but then you said the thing about baby so then i went dirty dancing

2 hours later…

Kermit

21:26

@NickChammas You can build a dynamic process to do this

« first day (1911 days earlier) ← previous day next day → last day (3254 days later) »

all rooms

Transcript for

Mar28

Mar '1629

Mar30

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC