The Heap™ – Consultancy ©®

Phil

10:18

Where's our vertica-in-chief?

0

I've been working long time with Teradata and I've found its Query band feature very useful for audit purposes. Now I just stumped in a project based on HP Vertica and I can't find any similar feature. Do you know if there is something similar or should I give up? As you probably know there is no...

vertica

Jack Douglas

11:32

-2

A: Cant get rid of filesort in simple query

Thank you for this question. Unfortunately I can't help you

Then why post an answer? — Mark Sinkinson 2 hours ago

Phil

Indeedy. I already reviewed that as a delete

Mark Sinkinson

@JackDouglas :)

ypercube

12:20

Yey, my rep in SO can be read upside-down: 66099

Phil

12:41

@ypercube how can you have acquired so much rep without being committed to a lunatic asylum?

ypercube

@Phil I was but escaped.

I rarely answer now - but the rep keeps growing.

ConcernedOfTunbridgeWells

@Phil They let him out from time to time in order to come to Drinkies.

JNK

13:14

mornin all

@ypercube same here I rarely post answers. Once you have a critical mass of answers already you just keep getting periodic upvotes on them

ConcernedOfTunbridgeWells

@JNK Yes. @gbn called it necrorep once. Most days I get one or two upvotes on something I posted months or years ago.

Phil

I only answer something on there if I need more rep for downvotes, to combat the ShitOverflow™

this made me chuckle. the $5000 compression challenge: patrickcraig.co.uk/other/compression.htm

Lamak

13:51

@ypercube Lately I answer like a couple of questions a week

Aaron Bertrand

I don't think an optimization trick will fix this: answers.sqlperformance.com/questions/2615/…

ypercube

14:16

wow. 16 billion spools

Could be an EAV design?

Aaron Bertrand

Full of outer joins, so possibly. I assume some cross joins (maybe unintentional).

swasheck

14:33

9news.com/story/news/local/2015/03/10/arvada-house-fire-message/…

billinkc

I'm gonna go out on a limb and say it was arson

swasheck

but WHO WAS IT??

billinkc

The world may never know

Phil

14:58

Proof you're better off writing answers to SQL Server questions on here: data.stackexchange.com/dba/query/284539

swasheck

doing away with integer math makes it less severe

billinkc

I do not care for your query formatting

swasheck

data.stackexchange.com/dba/query/edit/284573

@billinkc i find it legible

billinkc

Was never a fan of the K&R style for delimiters

swasheck

K&R?

billinkc

15:07

The C Programming Language

The C Programming Language (sometimes referred to as K&R, after its authors' initials) is a well-known computer programming book written by Brian Kernighan and Dennis Ritchie, the latter of whom originally designed and implemented the language, as well as co-designed the Unix operating system with which development of the language was closely intertwined. The book was central to the development and popularization of the C programming language and is still widely read and used today. Because the book was co-authored by the original language designer, and because the first edition of the book served...

Yeah, this is what I don't like to see en.wikipedia.org/wiki/Indent_style#K.26R_style

Not quite awake yet it seems

Phil

@billinkc it's not easy writing queries on an iPhone

ypercube

I get this from sqlfiddle today:

Error 503 Service Unavailable

Service Unavailable
Guru Meditation:

XID: 741288631

Varnish cache server

swasheck

@Phil it's also not easy being green

Phil

At least mysql doesn't get up voted that much data.stackexchange.com/dba/query/edit/284573

Andriy M

@swasheck I pressed many times, it wouldn't go.

Aaron Bertrand

15:15

@swasheck well, I wonder. You'd have to be pretty stupid to just do that - maybe he posted his status on facebook with a video of him lighting the match in a mirror. Then again, maybe the wife did it (or had it done) and made it look like it was him. Often it is the simplest answer but if that's true in this case the guy didn't have enough IQ to be married in the first place.

swasheck

> ARVADA, Colo. - Police have an arson suspect in custody after a burning house was found with 'My wife is a cheater' spray-painted on the outside.

@AaronBertrand true. a suspect is in custody

(ah. original article has been updated as well)

billinkc

poleese only arrest the guilty

Aaron Bertrand

And cops would probably automatically assume that the husband is the only possible suspect. They might be right, but that would be pretty short-sighted IMHO.

swasheck

@billinkc ... shoot the innocent

billinkc

Create enough laws, everyone becomes a criminal

swasheck

15:17

@AaronBertrand yeah. nobody's ever been framed for anything. ever

Aaron Bertrand

Hey shooting the innocent prevents all that paperwork, processing the person, and transporting their dirty self in your pretty police car

billinkc

They might fart or bleed on you and boom, more paperwork

swasheck

collateral damage in the war on crime

Aaron Bertrand

"While not particularly offended", you felt the need to flag for mod attention... why exactly? Maybe leave the flagging to the people who are actually offended - and then have their flags declined because that's the most stupid thing anybody could be offended about. — l4mpi 4 mins ago

bluefeet

@AaronBertrand typical MSO post

you sure you don't want to be a SO mod?

Aaron Bertrand

15:23

Um, yes

bluefeet

we can switch for a day

2

Lamak

ooooh, I like that idea

maybe a proposal for meta.SE. "Can we have a "switch for the day" mods?

billinkc

"Be grateful for that mess you have" day

bluefeet

@Lamak too difficult to implement

Aaron Bertrand

And I think you'd only get volunteers from SO who want a break, and nobody from other sites who want to see stuff from SO they'll never be able to unsee

2

Lamak

15:27

what's difficult about it?, we just paint @AaronBertrand's feet blue and we're done

Phil

@AaronBertrand can you nuke this? It's an exact dupe of his other question

Why have you posted this again? You already have a question with this issue — Phil 41 secs ago

Aaron Bertrand

@Phil Should the original be re-opened?

Phil

You can do -he's finally provided the info needed

Aaron Bertrand

How do such people get a job where they are responsible for even spelling Oracle?

Phil

@AaronBertrand you may as well nuke the comments on it too. Teeth were pulled

Aaron Bertrand

15:37

@Phil I've already nuked all but two (yours with the link may be useful to future readers, and I left the most recent message about panic)

bluefeet

@AaronBertrand we actually don't have many active mods. If we get burned out we just take a break. That's the plus to have 17

Aaron Bertrand

@bluefeet But I bet some people follow along even on days when they're taking a break. This swap could prevent them from doing that by denying access to that panel for the day.

If I'm online I have a hard time staying away for too long.

swasheck

just got a recruiter email from a dude who looks like peewee herman

Mike Fal

@swasheck Dude, welcome to last week.

swasheck

thanks!

Mike Fal

15:49

I'm here to help

swasheck

when news breaks, we fix it

Phil

16:04

@AaronBertrand that user & question is the worst one for a while. Heaven help the world if he's ever in charge of some data that is actually important

bluefeet

@AaronBertrand this is a reason why we need breaks from modding.

beating a dead horse daily

swasheck

@bluefeet i'll stand up for you

@SpencerRuport ... non sequitur meta.stackoverflow.com/questions/287747/… what does bluefeet's modding ability have to do with the downvoting actions of others? — swasheck 28 secs ago

Aaron Bertrand

16:18

@bluefeet yeah that guy is a maroon

Well, the site has gotten busier. The mall is less friendly when there are more people there, too. shrug Just because there are more people likely to down-vote you for writing a crap question does not make those down-votes invalid. — Aaron Bertrand 1 min ago

Cue the revenge down-votes in 3... 2...

Lamak

@AaronBertrand I agree. Why trying to have a discussion if you are set on not accepting anyone else's opinion?

Aaron Bertrand

"Overall it's a good question" - everyone on SO thinks that every question they write is a good question. Guess how many of them are right?

swasheck

Lead Dev: WHY ARE THERE SO MANY TIMEOUTS AND LOCKS ON THE SERVER DURING THIS TIME?
Seth: You threw three queries against the server at the same time. They're bad queries. Like 38GB memory grant bad

Mike Fal

38...GB?

Ouch

swasheck

*3

also ... we're QA-ing this new thing called Unicode in production.

Kris Gruttemeyer

16:22

@AaronBertrand So many people seem to be getting butt-hurt these days. I looked at his question, 3 or 4 links to what he is doing. I'd downvote, too. Why is it everyone assumes when you get downvoted that it's some sort of personal attack?

I've asked crappy questions before and had bad answers. Take your knocks, learn form it and move the hell on.

bluefeet

@KrisGruttemeyer it's because of the unicorn points.

blame the unicorn points

billinkc

Now I want to write a tracker and the next time that person interacts with the site - either a Q or A, I'd post a reference to

@AaronBertrand - No. I came here to say this kind of behavior has driven me away. Like I said, if you don't think that's an issue then there isn't a problem. — Spencer Ruport 1 min ago

Aaron Bertrand

Ok, so you're taking your ball and going home because you did something wrong and refuse to learn from it. Have fun on forums where you get up-voted for everything. — Aaron Bertrand 25 secs ago

billinkc

Something like "driven away" far far away

Aaron Bertrand

I understand. My 2-year old has similar behavior.

billinkc

16:29

You should raise her better

Aaron Bertrand

Working on it. Shock collar user manual says 3+

billinkc

I think that's Volts

Oh Tim Stone, I enjoy your twitter stream

newyorker.com/humor/borowitz-report/…

swasheck

real genius

►

billinkc

Sure, I tell you and you tell someone else and the next thing you know, we're in the middle of the next ice age

swasheck

16:52

i really enjoyed that movie

Phil

It's all kicking off with Top Gear Top Gear's Clarkson suspended by BBC
http://www.bbc.co.uk/news/entertainment-arts-31824040

billinkc

Hopefully it's not like the Jimmy Saville (sp) "fracas"

Zane

It is sooo nice!

@Phil bummer I love that show.

swasheck

frickin' fracases

billinkc

I do hope that mso question doesn't get deleted

Zane

17:06

Something else I found odd.

Phil

17:17

@zane he's on his final warning too. Might get kicked. Though he owns Top Gear along with another of the producers. Rumour has it they've got Chris Evans lined up as a replacement of Jeremy ever does get kicked

@AaronBertrand stop being mean! dba.stackexchange.com/questions/94765/…

Aaron Bertrand

poof

billinkc

No, you're "phil,Aaron Bertrand" not "Aaron Bertrand,phil"

swasheck

phil my face, it's getting fuzzy

Zane

@AaronBertrand awee I never got to see it.

Aaron Bertrand

not worthy of visibility.

ypercube

17:21

@Zane -You did not lose anything.

Zane

Gotcha.

Andriy M

Neither did I, I presume

Max Vernon

@AaronBertrand "it is 100% db related question.If you are not aware ask your forum of members." - it may be database related but it STILL SUCKS!

Phil

All of that users questions have been shyte

Max Vernon

to put it nicely

Phil

17:30

I know you have to start from somewhere, but at least buy a For Dummies or For Complete Dipsh!ts book and work your way through it

bluefeet

cram everything into one

This is really cool solution and seems to be exactly what I need. I don't necessarily like the fact that it takes multiple statements to get the job done but I tend to always try and cram everything into one statement (good or bad)... thanks for your help — sadmicrowave 2 mins ago

Phil

The Oracle Server Concepts document is BRILLIANT, and goes through everything in detail

billinkc

Including your wallet

swasheck

@billinkc like farting in the elevator ... nobody wants to say anything about the present awkwardness

Phil

It's not as expensive as you think. Nobody pays the list prices

billinkc

17:35

-1

Q: Changing Into CamelCase

I often received CSV files to load into the database using SSIS. Most of these CSV files have all uppercase headings (primarily because my Oracle exports only with uppercase column names). COSTCENTERID,REVENUETYPE,ACCTG_MONTH,FLOW_MONTH,ACCOUNTSUBTYPE,ACCOUNTTYPE, OPCOCODE,JURISCODE,STATE,ISO,RE...

c# sql-server oracle ssis notepad++

@Phil Don't go shooting holes in one of my favourite jokes

Shopping list if anyone feels like voting to close

swasheck

WAT!

that's just a dumb question

> To me, a column called FIRSTNAME should actually be FirstName.

To me, you shouldn't be in this job if this is a primary concern.

Andriy M

Or may be he's doing so well that that's become his primary concern

swasheck

@AndriyM that's excellent perspective. thanks

billinkc

Except I know the user

A wild PowerShell comment/answer appears

Andriy M

His column names don't have spaces. He wants a dictionary.

swasheck

17:47

mysql> create table example ( `number` int(11) not null );
Query OK, 0 rows affected (0.08 sec)

mysql> insert into example (number) values (10);
Query OK, 1 row affected (0.08 sec)

mysql> insert into example (number) values ('wat');
Query OK, 1 row affected, 1 warning (0.10 sec)

mysql> insert into example (number) values ('what is this 10 nonsense');
Query OK, 1 row affected, 1 warning (0.14 sec)

mysql> insert into example (number) values ('10 a');
Query OK, 1 row affected, 1 warning (0.09 sec)

ypercube

We should flag you for posting mysql onnsense

Andriy M

What I don't understand (possibly because I know next to nothing about SSIS) is why that is a concern at all. Aren't his tables already created? Or is he importing data into new tables?

billinkc

@swasheck Who are you and what have you done with Seth?

swasheck

just read this

developer.olery.com/blog/goodbye-mongodb-hello-postgresql

ypercube

insert into example (number) values ('1e1f1g1');

billinkc

17:50

@AndriyM You have the ability when you create your package to have it define the table. It's just utter laziness and smacks of not having done any due diligence about whether the types are sound for the data domain, etc

ypercube

@swasheck Related question from yesterday SO: stackoverflow.com/questions/28952960/…

bluefeet

delete
from HeapUsers
where userid = 'swasheck'
  and IsWorkingonMySQL = 1

ypercube

You can remove the = 1 - in mysql ;)

bluefeet

@ypercube stupid MySQL

and its backwards syntax

Andriy M

@ypercube Er, that's assuming the query was for MySQL :)

ypercube

17:56

Well, that's not exactly stupid. Boolean type is missing from SQL-Server

Zane

@swasheck "Schemaless storage engines promise to make your life easier by removing the need to worry about a schema. In reality these systems simply make it your own responsibility to ensure data consistency. In certain cases this might work out, but I’m willing to bet that for most this will only backfire."

Obvious.

ypercube

Not that mysql has a true boolean type anyway

bluefeet

I've got a hypothetical SQL Server question that "yes, I could test" but I'm looking for feedback on, since it's not MySQL related can I ask it? :)

swasheck

yes

Kris Gruttemeyer

Fire away

swasheck

17:59

(imma chargin mah lazor)

Andriy M

@billinkc So, if he is concerned about automatic case conversion of column names, that kind of implies he may not be paying attention to other, more important things (like type mapping or something), correct?

swasheck

@bluefeet well this is some question

bluefeet

We've got a process that runs every 2 hours that processes our billing. In this process we store our final billed data in data warehouse tables, but currently we do a delete from tbl where billingdate = <date>, then insert into tbl for each one of these. We've got about 15-20 tables this happens on.

We don't perform any log shipping in our environments and we'd like to start shipping the logs to a read-only version for reporting. Our concern is the size of the logs with the delete/insert so we want to possibly replace these with merge statements.

swasheck

WHAT HAVE YOU TRIED?

bluefeet

suck it @swasheck

swasheck

18:03

you suck it

bluefeet

nothing, yet. Just doing research on possible solutions to fix this problem

Kris Gruttemeyer

How big are the logs after the delete/insert operation? Might be helpful to see how much of the network pipe will get used

bluefeet

problem is many of these DW tables currently have no unique id for each row - we've gone and used an identity column which worries me when implementing a merge

@KrisGruttemeyer that's one of the tests we have to try. We don't know yet

swasheck

@bluefeet also, psych rocks

@bluefeet i've had lots of luck with MERGE

but it's all been bad

bluefeet

the goal would be to have the logs be small enough that we could ship them via log shipping

Kris Gruttemeyer

18:06

@bluefeet Understood. The data is going to have to flow over the network either way. You could decrease the time between log backups to help with the size

that way your network can eat the elephant one bit at a time

swasheck

@bluefeet tell me more about your log shipping. are you geodispersed or just in a separate AZ DC?

Kris Gruttemeyer

if youll pardon the horrible pun

swasheck

@KrisGruttemeyer so you're suggesting Hadoop?

bluefeet

@swasheck none at this point. DBs are in simple recovery and weekly they take back-ups which are then loaded into dev, qa environments. We've just implemented a BI environment that gets it's data weekly, we will use the log shipping to get more frequent updates

Kris Gruttemeyer

@swasheck Nope, start with the baked in SQL goodies first. Taking the logs at smaller intervals will decrease the size of each of them, less leg work for log shipping.

Just my thoughts, that's where I'd start

There is the catch of every user getting booted when the logs restore to the read only though

Zane

18:11

Ah SharePoint my old nemesis we meet again.

Kris Gruttemeyer

@Zane nope nope nope nope nope

Zane

With you fucked datatypes and other weird issue you will surely give me a headache on this day.

Kris Gruttemeyer

Not to mention case sensitivty

Sorry, that may make the headache worse

billinkc

I should have screenshotted that flagged chat message

bluefeet

missed it

billinkc

18:15

Someone flagged mysql code

crazy kids

swasheck

18:25

Joking about hadoop

Andriy M

Could you please explain exactly how the accepted answer helped you? As far as I can see, it calculates the same results without adding any filter. The MAX(period) column is added to the derived table only (without an alias too) and it isn't used anywhere in the outer query. So far, your having accepted that answer is bound to be very misleading for whoever may later come across your question. — Andriy M 45 secs ago

Shawn Melton

Afternoon folks...anyone here use any particular product/solution for keeping a script repository within their team or company?

ypercube

git

Zane

@ShawnMelton SVN

Shawn Melton

@Zane that is what I am looking at now.

@ypercube GitHub?

Zane

18:34

It has potential but we're using it wrong.

ypercube

@ShawnMelton github or private server.

github has nice tools

(for issues, seeing diffs on a browser, etc.)

Shawn Melton

@Zane Yeah I have looked at but would require a bit of knowledge transfer on using it...

Also considering VS online, have not messed with it in a while though.

Zane

Ours is a total free for all.

ypercube

@ShawnMelton git is a Linux thing. It can run fine in windows but it helps if you have linux/command line experience.

Shawn Melton

I can get into Linux and tool around but not proficient with it all.

ypercube

18:42

But once you pass the first curve, it's awesome

mmarie

@ShawnMelton I'm liking VSO quite a bit these days, but I don't need much for source control. I just finished setting up a new VSO account for my company.

Shawn Melton

@mmarie Yeah, I'm trying to find something that is simple as can be...making it easier to work with I think will cause it to be adopted across teams more at current company.

mmarie

Relevant: slideshare.net/noamkfir/…

bluefeet

@ShawnMelton SVN

mmarie

I feel like VSO is simpler to set up and use than Subversion. I've never used Git.

swasheck

18:49

@bluefeet do you really need it that frequently, though?

bluefeet

@swasheck yes, the BI is for financial reporting. They'd like it more frequent than once a week. Ideally they want as up to the minute as feasibly possible

swasheck

@bluefeet that's absurd

Zane

@mmarie when you google VSO it doesn't give me source control.

Shawn Melton

@Zane VisualStudio.com or Google for Visual Studio Online

swasheck

@bluefeet if that's really a requirement, then i'd look into Tx replication (i know how you love that) or pay for AOAG

Zane

18:54

@ShawnMelton hmmmmm.

bluefeet

@swasheck potentially that might be a later installation. Just not at this point

swasheck

@bluefeet then at this point hopefully youre BI end users are ok with the complications associated with what's available :)

Phil

"Nico Pratama has invited you to join Discussion between Nico Pratama and Phil." -- I wish he'd stop this! Does he think I'm some sort of on-call gimp of his? Damn right rude spamming me with chat requests all the bloody time!

swasheck

Prat

ypercube

19:07

@Phil Could it be automatic, by the long comment threads?

He has only 1 rep, so he can't chat anyway.

billinkc

Monkey with a gun. Everyone back away slowly

Zane

@billinkc Monkey with a gun sound much more appealing that ETL from a SharePoint List.

mmarie

Speaking of SVN, i keep getting a 405 error connecting to my new repository for this client. :-(

billinkc

How are you accessing it? Through Tortoise or hitting the web url?

Given the amount of security, they might have WEBDAV turned off and you can only use ... whatever the other protocol is

mmarie

tortoise

and no i'm not goign to the parent folder

Zane

19:18

Gah!

mmarie

False alarm on the SVN issue. My project lead had a typo. :-)

Phil

I've decided to help anyway, given the likelihood of him completely destroying all of his data is quite high :D

0

Q: ORA-12528 and ORA-12505 error on oracle database 11g

Its been one week since i last try to run my final project that i worked in my last internship at some banking company. Suddenly, my webapps (java project) in eclipse cant start. In the log it says that it failed to make a connection to the oracle database, with some error listener in it. So I t...

oracle instance listener

Mike Fal

Spelling counts

swasheck

@MikeFal good thing you remembered the "o"

Zane

@Phil You read that whole error message?

Phil

19:31

@Zane Nah. Larry Ellison told me to look for ORA whenever there's a problem.

Zane

@MikeFal it does?! Oh no I'm boned!

@Phil Yeah. You and Larry Pretty tight?

The square brackets make this appear to be the actual column name, this would rightfully throw an error. — bluefeet ♦ 2 mins ago

Lol

bluefeet

assumptions people make

0

A: SQL Joining from 2 fields to a concatenated field

Try this: join PROD..CART on CONCAT(Cart.CART_ID,Cart.USERID) = CW_PING.QuoteID

Max Vernon

@bluefeet someone should compile a book of "interesting" items from SO. It would be about 2 miles thick, and everybody who picked up a copy would immediately flip to the back, and add their own page with their own question.

Kris Gruttemeyer

19:46

@bluefeet I love the 'rightfully throw an error'

Zane

20:05

@billinkc am I misunderstanding the question here?

Why don't you just Name you SQL Server columns whatever the heck you want and then just change the mapping? — Zane 23 secs ago

billinkc

That the user is an idiot

Zane

He's definitely an idiot no one is disputing that.

billinkc

They're just going to run into the classic problem of profanity filters

Zane

I like that it's tagged as notepad ++

billinkc

There will be multiple options for words embedded into his column names and what he sees because you know, HE FOOKING KNOWS WHAT IT SHOULD BE, he wants to try and automate it

It's a shopping list question that should go to a watery grave

Kris Gruttemeyer

20:09

0

Q: Follow up on earlier today: Is there any way I can speed up the following insert(s)?

Sorry to bother again but I need an answer to this question since I can't seem to come up with one myself. Here's the previous post: Is there any way I can speed up the following insert(s)?. Consider the following: CREATE TABLE myTable ( random_value1 NUMBER, random_val...

sql oracle plsql

Yes, bother us again when you have an answer with 8 upvotes that is already accepted by you...

Zane

Good lord people are stupid.

Phil

@Zane Yup! I touched one of his boats once

Zane

@Phil My guess is he lights his cigars with torched boats.

ypercube

@KrisGruttemeyer It seems that when he tries to extend that answer for a random string, using v_my_array(DBMS_RANDOM.VALUE(1, 5)), he does not get a random one.

Seems legit question to me.

Zane

@ypercube Why isn't it just an edit of the previous question?

ypercube

20:16

It could be. But the problems look different to me - although related.

I wouldn't like the question to be altered, after they had accepted my answer either.

Phil

Obviously, it depends whether DBMS_RANDOM gets called once or multiple times. In that question, it gets called once when the variable is declared. May as well just stick 42 in there to initialise it and have done with it.

bluefeet

@KrisGruttemeyer well it would, right? :)

Kris Gruttemeyer

Removed my comment

bluefeet

@MaxVernon just think you only see a small percentage of the joy I see as a mod

Kris Gruttemeyer

@bluefeet It certainly would, the use of the word 'rightfully' made me smile, haha

Max Vernon

20:19

@bluefeet anyone who dares moderate SO should be given a giant medal in my book!

ypercube

@Phil I have no idea why. What is that v_my_array() ?

Max Vernon

"Some doubts" - no doubt.

0

Q: Converting MyISAM into InnoDB. Some doubts

I wanna convert my MySQL DB (46 Tables, 2.1 GB) from MyISAM to InnoDB. I have a couple of questions about this process. 1) Since I have a Master/Slave structure, do I need to manage this and change the Slave also? Or any structural changes will directly affect the Slave? 2) Related to n.1, do I...

mysql innodb myisam

Phil

If I could downvote I would -- for suggesting that this 5 lined SELECT is "common sense!" — eze 10 mins ago

Necro-comments

Max Vernon

@Phil have a +1 for common sense.

Phil

Haha

billinkc

20:23

Is it accurate?

Phil

He obviously finds it un-"eze"

billinkc

Aren't you generating the difference in seconds? Need a /60.0 to get it back to minutes?

Phil

Ha, yeah... :D

Clickety

billinkc

Feel free to rollback the edit if you wish

Phil

@billinkc I like your edit <3

billinkc

20:36

You do reference it as primary school, yes?

ypercube

@Phil, I checked the other answer and it seems to work.

Zane

0

Q: What is an index KEY - emphasis on KEY?

What does the 'key' part of the phrase 'index key' mean? Is the key a number? what is it? If I have the table of data containing a column called LastNames, and I have, say, a clustered index on it, is the 'key' for each row simply the last name? Would an example of a 'key value' be something lik...

index

Oh my!

ypercube

I was mistaken at first, thought that the cast to date would remove the time part

Phil

20:54

Nuke away: dba.stackexchange.com/questions/94914/…

billinkc

Mercy

Aaron Bertrand

Nuked as learn to search the f'ing interwebz

Phil

Rolando is winning the internetz at the moment

stackexchange.com/leagues/78/alltime/dba

ypercube

@Phil is this correct?

@ypercube I doubt it. It will probably error out with n3 is unidentified or x.n3 is unidentified. If i remember correctly an array needs a constant/literal as an index. A variable doesn't work. — ruudvan 3 mins ago

Seems like a very narrow restriction, if true.

swasheck

... and stay down

(kidding, natch)

Zane

21:02

Between SharePoint, SVN, and our broke ass UAT submission tool this day has taken ages off of my life.

Luckily a sunny bike ride and a beer will make it all better.

swasheck

scotch will do it for me

Zane

@AaronBertrand I seem to have a glitch with plan explorer.

There is no ability to scroll up farther.

mmarie

@Zane Yes, I'm screwing with Tableau and Impala on Hadoop and SVN. The tools make me miss SSMS and VSO, in addition to needing a beer. Luckily I have a lovely beer dinner to attend tonight

Zane

I plan on hitting a patio and reading with a beer for sure.

Anyway I'm out. Want to bike home in the impossibly nice weather. 65F in Minnesota in early march is not something to be taken for granted.

mmarie

21:31

It's a zonkey!

swasheck

ZOINKS

ypercube

@mmarie Super!

James Lupolt

22:31

hi

ypercube

@JamesLupolt It's mysql day, today ;)

5 hours ago, by swasheck

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/

James Lupolt

A bad day for MongoDB and MySQL

ypercube

5

A: MySQL is giving weird result

Some DBMS are omnipotent and merciless. They give numerous warnings and errors in all kinds of situations when is user is attempting the slightest deviation from the correct behaviour - defined by the standards and the dbms documentation. MySQL is merciful and all-loving. She is trying to help e...

James Lupolt

22:47

@ypercube Upvoted.

ypercube

23:49

Is there a reason for the anonymous downvote? — Gordon Linoff 22 mins ago

No, I just like the responses.

Transcript for

The Heap™ – Consultancy ©®