The Heap™ – Consultancy ©®

Simon Righarts

3:52 AM

Quiet day today. Oh wait I'm the only one at work, right?

Jack Douglas

4:53 AM

@SimonRigharts nah, I'm working. Not as hard as you are by the sound of things though!

Marian

6:46 AM

good morning

gbn

Good Morning

Mikael Eriksson

Good morning

@gbn did I understand your comment correctly the other day that you actually got the Mork and Mindy reference? And you are of course quite right. I was about 10 when it aired in Sweden.

May 23 at 14:11, by gbn

And showing your age

gbn

7:10 AM

@MikaelEriksson Yes, you did. I'm a little older I think. Showing my age too

Mikael Eriksson

@gbn You are showing your age on your profile so no you are not. It was produced 78-82 and I was 10 1978.

Marian

@SimonRigharts have you fixed your problem already? you were off to work quite early, I'd say

ConcernedOfTunbridgeWells

7:58 AM

Good morning

I think we're all old farts here. I suspect that in about 15 or 20 years people will be worrying about all that legacy RDBMS technology and the fact their DBAs are all due to retire in about 5 years.

And there will be a crusty old generation of NoSQL wonks that the devs all hate.

gbn

@ConcernedOfTunbridgeWells that have becomes ACID and ANSI SQL compliant to deal with data integrity. Because thet have to

@ConcernedOfTunbridgeWells Suits me. ALways have something to do

ConcernedOfTunbridgeWells

@gbn I'm sure. At some point there will be a critical mass of MongoDB punters who need transactions in their PHP apps all of a sudden and start pushing the devs for ACID.

Then there will be some people who want to be able to push complex query execution into the database for efficiency, so they will start pushing the MongoDB team for a feature where they can use logic in a query that compares values in two or more different tables and can return data from more than one table at once.

Then they will have problems with data integrity as they have to update multiple tables, and will then start wondering about how they could implent 'Don't Repeat Yourself' in a database. If only there were a mechanism so that all of the attributes of a single object could be grouped together in one place and then associations with other objects materialised in the database in a way that allowed the relationship to be reconstructed at runtime.

Then someone will work out what a PITA that inlining repeating groups on a table are when you want to use this matching feature that lets you query multiple tables at once.

The article might read 'JSON arrays considered harmful.'

Marian

8:15 AM

I think they already feel the pain :-)

rickosborne.org/download/SQL-to-MongoDB.pdf

ConcernedOfTunbridgeWells

Then someone else will have a requirement to support M:M relationships. All the crusty old farts will be sniggering in our horlicks and saying:
'Sonny, we had that technology 40 years ago, back when people still though XML was a really neat idea.'

And they'll say:
'F- up Grandad.'

Marian

@ConcernedOfTunbridgeWells they already said that too :-)

"The SQL Language was originally created for individuals connected to mainframes looking at green-colored-text on their 8 color monitors to work with business data."

ConcernedOfTunbridgeWells

But at least it's web scale.

Nathan Jolly

and zero-administration!

My favourite bit of NoSQL hype is: "Stop fighting the database and get ready to go into a world full of fun ... as a guideline, zero-administration is required"

ravendb.net/features

Marian

@NathanJolly "It just works"? looks more like marketing then tech talk

Nathan Jolly

8:26 AM

indeed

gbn

Duplicate?

0

Q: All users missing after a detach/reattach

After detaching and reattaching a database to do a copy operation, all of the user objects are now missing from the database (I should add that the copy failed; according to the logs, there was an issue with a number of views. I didn't get a chance to really look it over before I discovered my m...

Marian

@gbn yep.

@NathanJolly the funny part being that their own website's links don't work (some inner links). Also they have a "Built-in management studio". Innovation indeed :-).

Marian

8:59 AM

-1

Q: Stored procedure in SQL Server

I have 3 drop-down listd. The 3 drop-down lists map some values. I have displayed a new option on the 3 drop-down lists. I will click new displayed text box and enter the value to store it in the database. I have a combination of: new-value,new-value,new-value, existing-value,new-value,new-val...

sql-server stored-procedures

too localized? I've vtc..anyway.

(maybe move it to SO)

Marian

9:33 AM

And a small reaction for MongoDB:

dbareactions.tumblr.com/post/51425713721/…

gbn

10:25 AM

A question with SQLFiddle set up already. Awesome

3

1

Q: How to get one distinct ListofDate column from two different tables columns SQL server

Their are two tables Leaves, Attendanceatd with data, I need to display distinct ListofDates and employeeid from these two tables having some condition that in Leave table approvalstatus='Approved' and startdate / enddate period duration on both the tables Date column Table schema: SQL FIDDL...

sql-server-2008 tsql datetime

Marian

10:40 AM

@gbn nice!

0

Q: MySql Database Design for Bollywood Movies (India)

I'm trying to get my head round this mind boggling stuff they call Database Design without much success, so I'll try to illustrate my problem with an example. I am using MySQL and here is my question: Say I want to create a database to hold my India Movie collection. I have the following inform...

mysql

this should deserve some vtc (or migrate to SO).

ypercube

@Marian Already voted.

INSERT inside JOIN and window functions inside ON conditions. Nice.

0

Q: Pre-Populate foreign keys in SQL with a new row

I am trying to write a SQL script which will go through a table with a newly created FK and pre-populate the key with a new row in the foreign table. I'm not 100% on how to do this or if its even possible in a single statement but here's my attempt: UPDATE [dbo].[Blogs] set AuthorSecurableId = i...

sql tsql

Marian

@ypercube wow! "ROW_NUMBER() OVER (ORDER BY updating.Id) = inserted.rownum" that's neat.

0

Q: How to use Python and XML for distributed DBMS

I have a project where 3 VMs (say VM1 VM2 and VM3) are given to me. Each with 4 GB ram, and 50 GB space. They have known static IPs. All 3 VMs are installed with ubuntu 10.04 and MySQL. VM2 and VM3 will have data, and VM1 will act as the application engine, extract data from VM2 and VM3, integra...

mysql xml distributed-databases python

this one also needs one more vote

Marian

11:36 AM

@ConcernedOfTunbridgeWells: you have a nice number there on SO!

you need to issue some downvotes for it to be perfect, though :)

stackoverflow.com/users/15401/…

so you have to dv 7 questions

ypercube

@Marian 7 answers.

Marian

@ypercube yep, you're right

You know, given that all our crystal balls have not been delivred yet, it would help to know what technology you use and - what the query plan and indices are. — TomTom 2 hours ago

gbn

Massive parallel write via EF

0

Q: EF 5 usage in a heavily parallel desktop application

I have a desktop application using Entity Framework 5 that processes multiple videos in parallel, where each thread contains multiple child threads to accommodate multiple pass processing. Although multiple passes are normally daisy chained, these run in parallel using a queuing/dequeuing mechani...

c# sql parallel-processing entity-framework-5 video-processing

sigh. EF is way too chatty, too many roundtrips. Easy for code monkeys to use however...

Marian

11:54 AM

what is that "Entity Framework 5 that processes multiple videos in parallel" ?!

EF was supposed to work with db...not videos.

wait, my poor understanding kicked in, sorry.

Yasir Arsanukaev

12:42 PM

0

Q: Data Type that automatically stores the DateTime of the last transaction done

I need to add a new column to an existing table, so that whenever a new row is added, or an existing row is edited, this column will be filled with the exact date and time of the transaction. I tried using TimeStamp but apparently TimeStamp it has nothing to do with Date time It's just a bin...

sql

Marian

@YasirArsanukaev that timestamp data type is still misleading :)

Yasir Arsanukaev

@Marian indeed dude

gbn

SQL injection 25% of website vulnerablities in 2009

coding.smashingmagazine.com/2010/01/14/…

alisamii

1:26 PM

Can anyone help me solve this issue with my local MySQL install

0

Q: MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither through the command line nor through phpmyadmin. I always get the error Error in processing request...

mysql phpmyadmin mac-os-x errors

Yasir Arsanukaev

@gbn Those "Index of /photos" contents are weird

Chris Travers

for those who write any Perl, I hope to have this finished up next week with some additional extensions:

prepan.org/module/nXWJ8Y9sBog

It's an effort to create a bridge between Perl Moo/Moose object systems and PostgreSQL stored procedures, with the possibility of runtime discovery

(so you write your stored procs to an interface and the application classes can discover the call syntax dynamically)

(sort of like web service inspired database stored procedures)

Marian

2:13 PM

Hi Mat,Raj,i need immediately can you help me — arulmozhi 2 hours ago

ROFL... where's a Canadian when we need him?!

ypercube

We have TomTom

Immediately? Doing your work? Hire a consultant, he will come to your office and sit there with you and you pay by the hour. Here you ask questions and people coming by answer them - but only if you are spending enough effort to make them clear (which your question is not). I tried a couple of times, but it still is totally unclear what you try to do there and how that is a dba question. — TomTom 32 mins ago

Lamak

2:58 PM

weird

2

Q: ms sql - why does GO affect my select (Free Text Search)

I am experiencing a very weird behaviour from the management studio GO. I am following the full-Text Search tutorial and I run the following query over adventure works SELECT FT_TBL.ProductDescriptionID, FT_TBL.Description, KEY_TBL.RANK FROM Production.ProductDescription AS FT_TBL INNER JOI...

sql-server full-text-search sql-server-2012 full-text-indexing

gbn

3:16 PM

Very interesting though

bluefeet

I am getting tired of user who like to use u instead of you and ur instead of your or you're

ypercube

@bluefeet I see you've been busy stackoverflow.com/users/426671/bluefeet?tab=activity

bluefeet

@ypercube yes I am irritated with it

jcolebrand

3:37 PM

1

Q: MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither through the command line nor through phpmyadmin. I always get the error Error in processing request...

mysql phpmyadmin mac-os-x errors

Lamak

@gbn yup, I'm very intrigued. Too bad I don't have an instance of SQL Server 2012 to test this on

@gbn should that question be on DBA.SE?. Really strange stuff (at least for me, a person that doesn't really have much knowledge on the internals of SQL Server)

ypercube

@alisamii Have you tried to run mysql_upgrade after the upgrade?

gbn

1

A: ms sql - why does GO affect my select (Free Text Search)

I can reproduce this Assuming a GO..SELECT..GO pattern and some blank lines Before After Rows y n 6 y y 4 n y 4 n n 4 If I change the order of events... Before After Rows y n 6 y y 4...

OK, I have an answer. Dunno why yet

alisamii

@ypercube no, I didn't...but am about to. are there any options I should invoke? the documentation says shell> mysql_upgrade [options] so I am wondering (before reading the whole doc) if there is anything I should consider an important option and should definitely include?

ypercube

This should be run after an upgrade. It probably won't do any harm. But have you taken backup before the upgrade?

Lamak

3:50 PM

@gbn the correct result is the one with 6 rows, right?

gbn

@Lamak Guess so

either way, it;s shit

connect.microsoft.com/SQLServer/feedback/details/788691/…

Lamak

@gbn yes, it is. One of those times where the user can actually blame SQL Server for wrong results

alisamii

@ypercube Great, that seems to have worked. Thank you. :)

Lamak

@gbn already reproduced it via a remote connection to my home computer. (But can't keep testing because I'm at work)

ypercube

@alisamii Great. You can write an answer now, and accept it :)

alisamii

3:54 PM

@ypercube well, partially :)

I can add a user now without a problem at the command prompt and in phpmyadmin

however, I am still getting error 1062 when trying to install an extension in joomla, for example

1062 Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `u5z87_extensions` (`name`,`type`,`element`,`folder`,`client_id`,`enabled`,`access`) VALUES ('plg_system_nnframework','plugin','nnframework','system','0','1','1')

@ypercube so, once I solve those errors, I will write an answer...and then accept ti :)

Marian

@gbn I hope it won't be killed by MS because of the brevity :-).

Aaron Bertrand

groan

-2

Q: How to run a batch file in xp_cmdshell

When I try to run this: exec master..xp_cmdshell 'C:\f\alert.bat' I get the following error message: 'alert.bat' is not recognized as an internal or external command, operable program or batch file. How can I run this batch file using xp_cmdshell? EDIT: The command above is verbatim. I ...

sql sql-server-2008 xp-cmdshell

Lamak

@AaronBertrand that's a new one, I'm used to the shrug and sigh

did you see this Q?

3

Q: ms sql - why does GO affect my select (Free Text Search)

I am experiencing a very weird behaviour from the management studio GO. I am following the full-Text Search tutorial and I run the following query over adventure works SELECT FT_TBL.ProductDescriptionID, FT_TBL.Description, KEY_TBL.RANK FROM Production.ProductDescription AS FT_TBL INNER JOI...

sql-server full-text-search sql-server-2012 full-text-indexing

alisamii

@ypercube any ideas on how I can fix the #1062 error?

ypercube

@alisamii Can you remove the extension and reinstall it?

Aaron Bertrand

4:13 PM

@lamak whoa, that's a new one

As for the one I posted, did you see all the crap I've gotten from this guy about his too localized question?

15

A: What should I do when I feel someone is downvoting/closing out of spite?

Let's recap. You asked this question. Arguably too localized because it can take a lot of work to reverse engineer such queries. I commented that the queries were awful, but also suggested that you, yourself, could both (a) determine whether they were semantically equivalent and (b) determine whe...

Lamak

@AaronBertrand yeah, I was aware of the context :-). Still, we got a groan, hadn't seen it before ;-)

@AaronBertrand yup, and I also reproduced it. Really messed up

Aaron Bertrand

Guess who's been added to my "favorite users" list

Lamak

@AaronBertrand haha, I love your use of the addin

ypercube

4:39 PM

Good for here?

0

Q: IDENT_CURRENT returning value which does not exist in the table

I have a stored procedure which uses IDENT_CURRENT to update last added value in a table. The issue is: IDENT_CURRENT returns a value that does not exist in the table. The number it returns is much higher than Max(ID) of the table. How is it possible and what can be done to fix it. I never want...

sql-server-2008 tsql

ConcernedOfTunbridgeWells

@bluefeet Maybe you could randomly leave out half of the letters in each word of your answer.

jcolebrand

@bluefeet my advice is to start voting to close or delete their answers/questions, and mark everything as spam ... :p

bluefeet

@jcolebrand I have flagged a lot of the answers.

jcolebrand

@bluefeet you do realize you're just supposed to edit them, right? You should only flag one or two, and that to ask the mods to send a PM asking them to adapt to the site.

In other news, link me to an answer that hasn't been edited

bluefeet

@jcolebrand I am editing them.

jcolebrand

4:52 PM

unless this is an epidemic of many users doing the same thing repeatedly

bluefeet

The ones that are total crap answers get flagged. Some are questions and not answers

jcolebrand

in which case, there is a way that can be combatted (regex on the text in the editor/submission) where they are told the post is shite and won't be acceptable (we already to this in certain cases)

bluefeet

1

A: 404 - File or directory not found - with correct URL

If u using hosting webserver, send a ticket to ur hosting company and ask them to add the file extension into MIME, problem solved :)

^^^ crap answer

not yet edited

u and ur....argh

alisamii

5:10 PM

@ypercube tried...and got the same error

Mikael Eriksson

To bad you did not post the actual error message you got. 'C:\f\alert.bat' is not recognized as an internal or external command, operable program or batch file. I actually did some tests to figure out what you saw but I could not recreate the error you posted with the command you posted. — Mikael Eriksson 1 min ago

Lamak

@MikaelEriksson what do you mean?, I thought that that was the actual error message he got

Mikael Eriksson

@Lamak The path `C:\f`is missing in the question. I thought he might be calling another alert.bat from the specified alert.bat or something. But it was much simpler.

Lamak

@MikaelEriksson oh, you are right, didn't notice

Marian

5:29 PM

@MikaelEriksson he's just a troll. And not a smart one..

oh my, this got moved here. Please, please move it back to SO:

0

Q: Data Type that automatically stores the DateTime of the last transaction done, SQL Server 2008

I need to add a new column to an existing table, so that whenever a new row is added, or an existing row is edited, this column will be filled with the exact date and time of the transaction. I tried using TimeStamp but apparently TimeStamp it has nothing to do with Date time It's just a bin...

sql sql-server-2008

Lamak

@Marian wish I could vote to close on DBA, but I have a laughable rep there

ConcernedOfTunbridgeWells

@Marian Track and trace says the goodies have arrived in Romania.

Mikael Eriksson

@Lamak You can flag as off topic (I can at least). It will not count as a close vote but it will alert a moderator. And when they get tired of your flags they will perhaps start upvoting some of your answers so you can vtc directly :)

ypercube

@MikaelEriksson Plus, having many (helpful) flags is good, if you ever run for moderator.

alisamii

@ypercube do you have any ideas on how I can solve the #1062 errors?

ypercube

5:43 PM

@alisamii It could be a Joomla issue (or a conflict of the extention with mysql 5.6). You could ask at the Joomla forums or the extention provider.

Otherwise, the error shows you have duplicate rows. If the table is just created by the extention, I can't understand how the installation script will try to put duplicates.

alisamii

well, I am getting it with multiple Joomla extensions, and the the debs (nonumber.nl for one, akeeba the other) have confirmed that their extensions are 5.6 compatible

if you want, I can send you a join.me link and allow you to connect to my computer remotely

if you think you can help me troubleshoot

Marian

@ConcernedOfTunbridgeWells wow, that was fast! Didn't imagine UK Mail to be that fast. Now I suppose it will arrive my way in 2-3 days :).

Lamak

@MikaelEriksson good advice

Marian

@Lamak No worries, it will get moved some time..eventually.

Mikael Eriksson

@Lamak And it is work to. Two upvotes already :)

Marian

5:51 PM

0

Q: Optimum configuration for 4 SSD drives

I would like to move a SQL Server database from a shared configuration with the web-server to it's own dedicated box. My current budget will allow me to put 4 disks together in an array with a single hot spare. I'd like to stretch to 8+ drives but the costs are a little out of my budget right now...

sql-server performance configuration hardware

that's for @MarkStoreySmith and @ConcernedOfTunbridgeWells, the SSD players :)

Gonsalu

@ConcernedOfTunbridgeWells (eons after) I used to live there, yes

@ConcernedOfTunbridgeWells I've moved to Norway

ypercube

@alisamii Is the SQL script very big? You can copy in a gist so we can check.

ConcernedOfTunbridgeWells

6:08 PM

@Gonsalu Quite a climate change there.

Gonsalu

@ConcernedOfTunbridgeWells haha yes

ConcernedOfTunbridgeWells

@Marian Done

Marian

6:24 PM

@ConcernedOfTunbridgeWells nice.

ConcernedOfTunbridgeWells

@Marian Not sure the question isn't a bit off topic really. I'd be tempted to vtc it as too localised.

However, I suspect it can be answered in a way that's relevant to the user at least.

Interesting - the OP works for an outfit that does a SaaS SMB accounting suite.

Marian

@ConcernedOfTunbridgeWells yes, it looks a bit localized. But for now it's kind of easy to answer (by you or Mark at minimum) so it's clear for the user and a future looker.

ConcernedOfTunbridgeWells

@Marian SSDs aren't rocket science. I just happen to have the dosh to be an (almost) early adopter.

Should put him in touch with @JackDouglas. JD's looking into setting up a lightweight hosting service for some of his clients. Maybe the OP's requirements would be right up his alley.

Plus he's in the right location.

@Gonsalu How's Norway treating you?

Gonsalu

@ConcernedOfTunbridgeWells Pretty good. Especially now that it's getting warmer. Around 26C these last 2 weekends

Marian

@ConcernedOfTunbridgeWells who knows? maybe it will work this way and he won't buy the hardware..

@Gonsalu in what part of Norway are you? Ecuatorial Norway? :)

ConcernedOfTunbridgeWells

6:34 PM

@Gonsalu I wish it was that warm here.

Gonsalu

@Marian Oslo! I wasn't expecting it, to be honest

ConcernedOfTunbridgeWells

@Gonsalu What are you doing now? I guess the workload is a bit more aggressive than whatever you were doing before.

Gonsalu

but seeing the weather charts in weatherspark.com, it seems that it's not that uncommon

(highly recommend that site, btw)

@ConcernedOfTunbridgeWells the workload is not really that more aggressive, but moving into a new place there's a bit more of socializing

also, I'm taking norwegian classes, so that takes a bit of free time, too

ConcernedOfTunbridgeWells

@Gonsalu Oh well, at least you've got a life so you're busy for good reasons.

Gonsalu

@ConcernedOfTunbridgeWells heh, guess so.

I've got a bit addicted with DotA2 too, so there's that haha

@ConcernedOfTunbridgeWells how about you, how have you been doing

BI gigs left and right? :)

ConcernedOfTunbridgeWells

6:44 PM

@Gonsalu I've got a new gig out of town that's a weekly commute but pays quite well. I'm also doing some product design work on an industry model product for another outfit. They think they're close to making a sale.

Gonsalu

@ConcernedOfTunbridgeWells Pretty busy yourself, I see

ConcernedOfTunbridgeWells

@Gonsalu Yes, working this weekend.

Gonsalu

@ConcernedOfTunbridgeWells Remember to take some breaks :P

ConcernedOfTunbridgeWells

@Gonsalu What is this 'Break' you speak of?

Gonsalu

heh

ConcernedOfTunbridgeWells

6:50 PM

No paid holidays as a contractor, although I could really use a 3 month holiday.

Gonsalu

I'd say you can pay yourself some holidays as a contractor :)

ConcernedOfTunbridgeWells

@Gonsalu Maybe when I can save up a few bob after paying for all the ones my other half takes :D

Gonsalu

Had to urbandictionary what bob meant

I could tell from the context, but it was funny to find it there

ConcernedOfTunbridgeWells

@Gonsalu Money - originally a slang term for shillings, I think

Jack Douglas

7:24 PM

@ConcernedOfTunbridgeWells good answer. it'd be helpful to know what he is currently running on though

alisamii

@ypercube It's a plugin/extension for Joomla. Uses Joomla's installation interface to install, using an xml manifest. So, not sure exactly what to put in the gist. the plugin is the free version of NoNumber Extension Manager nonumber.nl/extensions/nonumberextensionmanager

ConcernedOfTunbridgeWells

7:56 PM

@JackDouglas How's your mini-blade server project coming along - perhaps OP might be a potential customer?

Aaron Bertrand

Trolls, trolls, trolls ... welcome to me personal hell @Mikael

Marian

@AaronBertrand how's the cruise?

Aaron Bertrand

Awesome. Best salmon of my life being ingested right this very moment.

jcolebrand

8:11 PM

@AaronBertrand then why the bloody hell are you telling us about it?

Marian

@AaronBertrand enjoy :).

Aaron Bertrand

I'm sitting in a restaurant with a brief period of decent Internet. Who else should I tell?

jcolebrand

Less than 24 hours from finding out who are newest mod will be

@AaronBertrand Facebook, of course </deadpan>

Marian

@jcolebrand wut? we still don't know?

Saladin

hey

can anyone help me with a networking side question?

Aaron Bertrand

8:15 PM

Curious Phil hasn't answered the questionnaire yet. I suspect most who are going to vote have already voted.

Marian

@jcolebrand you need to ping @Phil to answer the questions!

jcolebrand

@Marian I do no so such thing

@Marian somebody convinved a third horse to enter the race

Otherwise we would've had two new mods 9 days ago

Aaron Bertrand

I was already told by one person that I was their 2nd choice.

jcolebrand

@Saladin well, if it's DB related almost certainly

If it's just kind of random network oriented ....

The Comms Room

ServerFault's lobby

5

ConcernedOfTunbridgeWells

@AaronBertrand Sounds perfectly reasonable.

jcolebrand

8:17 PM

@AaronBertrand you do know how the algorithm works right?

ConcernedOfTunbridgeWells

I've been known to blog^H^H^H^Hchat on the heap when I've been at drinkies with various folks.

Marian

@jcolebrand do it, he needs to do it.. Please?! :)

jcolebrand

@ConcernedOfTunbridgeWells I would say blogging mostly fits what I do too ;-)

@Phil get your arse in the chat, pronto

Aaron Bertrand

@Concerned well that depends on their reasons :-)

Marian

@jcolebrand Thanks! :P

ConcernedOfTunbridgeWells

8:18 PM

@jcolebrand That and just talking general bollocks.

jcolebrand

@ConcernedOfTunbridgeWells wait, they aren't the same?

Saladin

no its related to IBM switch

Aaron Bertrand

@jcole no, Maths are hard. I still haven't gone back to figure that out.

Saladin

related to span traffic

ConcernedOfTunbridgeWells

@jcolebrand Close enough.

jcolebrand

8:19 PM

@ConcernedOfTunbridgeWells Next I know you're going to tell me Santa isn't real, and I shouldn't eat the brown eggs I find on Easter.

ConcernedOfTunbridgeWells

@jcolebrand I think Santa has an imaginary component, which makes him complex.

jcolebrand

@Saladin we are gonna need something a lot more resembling a problem domain and a lot less like "permission to ask if I can ask about asking a question"

ConcernedOfTunbridgeWells

For this reason I am also allowed to eat quiche.

Mikael Eriksson

@aaron I knew what what would happen when I first commented. Now I am done with that question and moving on.

Saladin

ibm.com/developerworks/community/forums/html/…

here is the problem domain

jcolebrand

8:20 PM

@AaronBertrand basically it's this: First vote is the main thing that counts, and if your first vote gets eliminated, then the points that were given to that person are distributed over the second ranked, based on how much percentage of the remainder that person should get. It is as you said very maths. Sometimes it makes my head hurt. But I followed the proof enough to see that it was very fair.

Saladin

too complex or verbose to write it all here

ConcernedOfTunbridgeWells

@jcolebrand IIRC Ireland uses STV for elections. It was considered in New Zealand at one point but they went with an MMP system instead.

Aaron Bertrand

@saladin you're asking permission to ask a networking question here, even though it's too complicated to write it here? Am I the only one failing to find the sanity here?

ConcernedOfTunbridgeWells

@Saladin A bit off-topic for this forum or for dba.se. You might be better off asking the question on Serverfault.

Marian

@Saladin not database related. I'd advise you ask on serverfault.com (it's our sister site)

Aaron Bertrand

8:24 PM

All right folks, back to the ship

Marian

@Saladin what @Aaron is saying is that the chat room is only for simple questions (solution comes off somebody's mind easily), the complex ones should be asked on the site - FAQ.

Saladin

ok

Marian

@AaronBertrand enjoy your wales! take care!

jcolebrand

@AaronBertrand haha, no, I asked that same question ;-)

@Marian I did say that fully 7 minutes before you ;-)

Marian

8:45 PM

@jcolebrand well pardon me for ignoring you! I promise I will do it again if you don't ping the missing one! :)

:P

jcolebrand

@Marian lol

I think it's fair to say that the person responding to the asker was not the one who should've paid attention

Marian

@jcolebrand well you redirected the man to the Comms Room, saw that. But they say in the room description that they don't like questions so maybe that's why he continued to ask here :).

jcolebrand

@Marian I can't help it if you can't be arsed to form a good question ;-)

And they do rightly to ask that all questions be stored on the site so it's easier to focus on the Q, and to make it more googlable

Marian

@jcolebrand oh my, you crunky one! still pulling lots of hours?

jcolebrand

@Marian I try.

I also didn't mean you when I said "you" above, I meant the pejorative you of those who ask questions without at least trying

At least my questions ramble on and off for no good purpose

Marian

8:57 PM

@jcolebrand I know, I know :).