The Heap™ – Consultancy ©® - 2014-06-17

« first day (1260 days earlier) ← previous day next day → last day (3625 days later) »

12:02 AM

Which news?

That Altidore is likely out for the tourney?

brazilianldsjaguar

Nah, just the results of the USAvGhana game

Ya

brazilianldsjaguar

k. I saw the word "delayed" and didn't want to spoil it for you :P

I love Univision, but the delayed feed is killing me. It messes up the replay timing :)

But honestly ... Portugal beats us by 2 if they play like they did today and we play like we did today

brazilianldsjaguar

sigh sadly so

There is precedent that we bump portugual out of the groups (2002)

But that was different times, different teams :P

12:13 AM

There is also precedent that Beasley wasn't a piece of burnt toast in the backfield too

He got burnt all game

brazilianldsjaguar

lol yes I noticed

11 hours later…

11:16 AM

@swasheck wait, DaMarcus Beasley is still playing football? I would've figured he'd be a fossil by now.

11:26 AM

Kill

-2

A: INSERT INTO without duplicates

E=mc^2 is newtons farmula hahahahaha

12:04 PM

@AndriyM you didn't need to do that. But thnx.

nitesh.kodle123

12:16 PM

hi

I m havin query
i need to know difference between schema and database in oracle

and also difference between schema and tablespace .

@nitesh.kodle123 Did you read the answer to your question? dba.stackexchange.com/questions/68150/…

@nitesh.kodle123 Did you read any of the oracle docs?

nitesh.kodle123

yups

but its not clear in the article

I know collection of datafiles is table space and collection of tablespace is database.

But schema is defined as collection of database object where to fit in schema

I only asked the question

after being frustrated googling the difference

and asked question

but was not satisfied

with the article

can you help?

schema and schema_objects (tables, etc.) are logical structures.

nitesh.kodle123

can you please elaborate

as for database also i can say its a logical structure

12:27 PM

@nitesh.kodle123 What other DBMS call "database", Oracle calls "database schema" or just "schema".

nitesh.kodle123

ok

If you have used to work with SQL-Server or other DBMS, Oracle has different terminology in that part.

nitesh.kodle123

thanks for this

its helpful

thats what happens when we compare more than one technology

12:40 PM

1

A: Understanding execution plans using TVPs

I don't think this query is about TVPs so much as complexity. The plan has an optimizer timeout. You can see it in the F4 properties of the SELECT operator as "Reason for Early Termination of Statement = Time Out" or StatementOptmEarlyAbortReason="TimeOut" in the plan xml. These are not always...

Check out the heroic SQLfiddle on that answer generated entirely from the execution plan. Deserves some upvote love, even if the answer itself is not perfect and the question is an iceberg.

@ypercube Wanted me some new badges, didn't I

I've never heard of a zip join before

0

Q: How to implement a ZIP JOIN in T-SQL?

Let say I have table #Foo: Id Color -- ---- 1 Red 2 Green 3 Blue 4 NULL And table #Bar: Value ----- 1 2.5 I would like to create table Result using simple statement to get: Id Color Value -- ---- ----- 1 Red 1 2 Green 2.5 3 Blue NULL 4 NULL NULL What I have invented s...

sql-server tsql

@AndriyM Did you award a bounty somewhere?

@PaulWhite Only just started, awarding tomorrow.

6

Q: How to select specific rows if a column exists or all rows if a column doesn't

I'm writing a script that gets a count of rows for a few tables, however for some tables I want to only get a count of rows where a flag is set (in this case active=1). Is there a way I can do this in one query? Eg: Table users has a column called active Table clients does not have a column c...

mysql select count

Got too much credit for what's not my idea in the first place

and I know whose it is, that's why

@AndriyM Ah yes. A very interesting answer. I'd already upvoted it sadly. edit: and commented, I just noticed :)

4

Q: What's a zip join? Have you ever heard of that, or a pairwise join?

This section of Slick's documentation page is quite odd. What is this zip join? It says that it means: a pairwise join of two queries but what that means @.@ I don't know I've tried Googling for both "zip join" and "pairwise join"... but no results to do with databases. I do get this f...

sql database scala slick

1 hour later…

1:52 PM

@PaulWhite Learn something new every day.

I'd never heard of it either.

I can't think of any sort of use case for it soooo.

2:13 PM

Makes little sense to me. Of course I also find little sense in expecting rows to be ordered in the same order they were inserted, but a lot of people think that is useful (or want it to work that way without having to add a column that could make that explicit)

2:28 PM

this is a long query

-2

Q: Optimization Required in my Oracle Procedure : For 10,000 records it takes 100-120 seconds to execute the procedure

I have created an Oracle Procedure which takes more than 100 seconds to execute only for the data of around 10k records. After fetching the data from the main query, there are some conditions checked inside for loop after which values are assigned to variables and the same variables are used in t...

performance oracle optimization procedure mysql-slow-query-log

i love the open market where the presence of choice is available to any and all who have the capital to spend. like, for instance, my internet service provider. i have all the choice in the world. wait. i dont? i have to choose between tweedledumb and tweedlefraud? because of "municipality agreements" i can't have an "open" choice in this open market?

also: apparently there's going to be an expendables 3??? didnt realize there was a 2

2:46 PM

never gets old

Glad this presentation pissed Brent off too.

ozar.me/2014/06/…

I went to that session in Chicago and felt lied to.

This is my talk on in memory OLTP in which I will give zero information about what that is or how it works but here's how fast our disk drives are.

@zane want to come work with me? There is a $6000 referral bonus i would split with you if stay 120 days

@mmarie ??

What? We have too many BI projects and not enough people so they are now offering referral bonuses if we find good people.

@mmarie what about middlings?

3:01 PM

huh?

@mmarie he's suggesting he doesn't fall into the category of "good people"

you said "good people"

oh. if you stay for 120 days and you are only average i still get the bonus

3

Zane's marginalness will outshine many of the other team members

3

So ... I kind of wanted to close this question as too-localized or something, but decided I didn't remember if we had a "canonical" version of this question/answer pair. Should we move it to Meta? Any thoughts on my answer and what should be said to improve it, other than "everybody has a different style, get over yourself"? dba.stackexchange.com/questions/68264/…

If we have a canonical version of this, I'll move my answer and we can close it as a dupe ;-)

(I mean, if there's not already a better answer, of course)

3:07 PM

@jcolebrand Why do you mention TSQL - when the question is about Postgres?

@ypercube to draw a distinction on styles and how various sources will use their own experience?

wait, do you mean on the line "there is no formalized" ... I don't remember typing TSQL

gone now

@mmarie tempting but I have much to finish here before I go anywhere else.

Out of curiosity, what number would change your mind and bring you to KC?

It can be expressed as N dollars over my current salary or a percent as I think I have a decent guess of where you're at.

I don't know that would be hard. First of my dog is 14 and moving to another State would not do her well. I just signed a lease. I've got my whole family here. I fucking hate the Royals... :)

why would you do this?

0

Q: maintaining a custom auto increment column

I have a table with ID (identity) and XID (int) which is my custom auto increment column. I am using an instead of insert trigger to maintain XID, but I am getting duplicates. table xtable (ID identity, XID int) trigger - instead of insert insert into [xtable] (XID) select [x].[Nextavaila...

3:18 PM

@Zane everyone hates the royals

@Zane That's ok. We don't like the Royals either

@Zane soo, 2%?

@Zane ... hate to break it to you but ...
a) the dog's going to be gone soon, anyway
b) leases are easy to break
c) your family will still be there and you can visit them
d) see previous comment about the Royals. nobody likes them.

@swasheck the dog is pretty damn spry for her age although she's had a massive drop of this year.

sorry to hear it

3:27 PM

Still want to keep her here for a bit.

ours is 12 and shows no signs of slowing down

(sorry to hear about the massive drop, that is)

If I broke lease the other people in the house would be completely fucked.

@swasheck That was her last year.

@Zane i admire your honor. i forgot about your housing situation

13 going on 5. She could still do 3-5 mile runs every day. Now I've gone from a run to a walk and it's about 1 mile.

@Zane Ok, so Dallas is still an option? :p Sorry to hear about the dog.

Mine is 10 and some change and all you people who talk about dogs being 14 and 15 make me sad and angry because I don't want to put her down even tho it's between 2 and 6 years away ...

3:32 PM

The biggest reason I wouldn't leave now is I have unfinished business here. The people I'm making this large project for have been fucked around for about 8 years. I'm definitely not going anywhere until this project is rolled out. That's a promise I've made to a "customer" and I'm definitely not backing out on it.

If I did go I'd have to do it like today. I technically haven't given my lease back lol.

But to answer your question @billinkc Wells plans on giving me 10K over my current Salary. It would probably take 20/30 to get me out there under different circumstances.

@jcolebrand Hell no they stole the NorthStars!

:)

Oh and cost of Living is lower in KC so I'd have to Factor that in as well I suppose.

@swasheck also I've very close to my family. We have get togethers monthly.

@Zane that's fair

3:49 PM

@mmarie in short I don't know....

@Zane Not trying to help change your mind, but genuinely curious - how much of this project actually has to be done in person?

4:08 PM

@AaronBertrand Technically not much the first rollout is happening in July. We are doing exhaustive testing atm.

0

A: Using the 'Use' command, or equivilant to point to a different server

Since you mentioned readability as a reason to not just simply use fully qualified names, and also mentioned that you aren't familiar with aliasing, I'm left to assume you're query looks like this. select serverA.Database1.dbo.TableName.ColumnExample, serverB.Database2.dbo.TableName.Sec...

@Lamak WOW. brazil must HATE belgium

Anyone want to proofread that to make sure I didn't bone anything in that answer?

hehe, you said bone

@swasheck damn, I'm actually not watching this match

@AaronBertrand however if I took a separate gig I could not stay on here t finish.

4:10 PM

@swasheck why?

not watching

@bluefeet @Lamak thunderous whisling whenever a belgian player touches the ball

@bluefeet It's not a world cup thing he's just racist against Belgians.

@Zane I did this at my last place, it is not worth it

@bluefeet I really like my customer and am in complete control of the solution I give them.

@Lamak @bluefeet i am wrong. just one player. have yet to identify who it is

4:12 PM

There is zero chance of being jerked around by internal politics as a result.

@Zane I get that but sticking around for unfinished business is a bad idea. There will always be unfinished business...ALWAYS

@bluefeet yeah but this is my baby. My flagship product. The thing I've wanted to tackle since I started here.

@Zane you are missing the + in this part of your answer: '@Server1''@Database1'

@Lamak Thank you! I always miss this sort of thing when I can't execute.

Should be '+@Server1+'.'+@Database1+'

4:14 PM

@Zane again, I understand. I was in the exact same situation on both of my previous teams. It is hard to leave when you are in that position but seriously consider if you are staying for the right reason. Most of the time it isn't.

@Lamak Just fixed. Thanks homie!

@Zane yup. Now you are missing the period between server and database: +@Server1+'.'+@Database1+

@bluefeet But I also love my job it's not like when I stayed at Wand for too long out of some misguided sense of loyalty. I am very happy with my employer and hadn't really considered leaving at all until a how much would it take to get you out here offer was made.

@Lamak "I would recommend adding the .prior to the database in the server variable that way you can leave it off if it's a local server"

@Lamak I thought he should add that to the variable that way if he's not using a linked server it will still work.

Oh....didn't read that, then no need to add the '' there: + @Server2 + '' + @Database2 + shoud be + @Server2 + @Database2 +

Algeria scored the first goal

Damn!, no good for my bet

Strike first, strike hard, no mercy sir!

4:26 PM

@Lamak bad bad bad bad bad penalty

without the penalty ... could have been offside

@swasheck but was it the right call?

I mean, from the referee

@Lamak i think so

do you? and i really really really want belg to win

@swasheck sadly I can't watch the game

Swing and a miss = free kick, huh?

With the agony displayed by every player who ever falls in soccer, it's amazing kids ever get interested - these players look like they're dying from a severed foot

in fairness ... the usa didnt really dive that much :)

4:41 PM

Only saw bits of the USA/Ghana match. Right now it's annoying - TV is on behind me, and I keep turning around every time the crowd gets excited. Sadly, they get excited every time someone crosses the center line with the ball

@AaronBertrand hey. so i didnt see you in the "warrior training" picture :)

@swasheck the tjaybelt blanket? SQL Sentry is up near the top. Facebook's tagging accuracy is, erm, primitive

Oh I know what you're talking about now.

Yeah tough for me to get to the gym in Huntersville.

user image

:)

I'm just out of frame. Yeah, that's the ticket.

Well, CYCLE essentially tells SQL Server you are okay with reusing values. I have absolutely no idea why you're having this issue, and don't know that you'll find out why (how much time do you spend investigating why you got a flat tire, before you just replace it?). I still think your best bet is to have a constraint there to prevent duplicates, and to turn off caching in hopes of preventing reuse. — Aaron Bertrand ♦ 1 min ago

5:23 PM

huge algerian save (then a huge takedown)

beautiful header ... 1-1

I think this should be closed as a dup -- dba.stackexchange.com/questions/68423/…

@Lamak Thanks for the proof read!

@AaronBertrand This is why I can't watch world football and basketball. Drawing fouls is waaaaaay to prominent.

@Zane i'm fascinated by the game ... but the obvious corruption that permeates it is just so distasteful. also why i dont like the nba and am increasingly disliking the nfl.

2-1 now

@ypercube booo ... i'm on a delay

it's still 1-1 in my world

5:36 PM

I just listen/read a feed. No TV at work.

I'll probably go and see the Brazil-Mexico game

dont get mad ... get even

it's about 10 mins diff (between the 2 goals). So you don't lose that ;)

i'm at 81:30 on my feed now

What did your feed time say at the first Belgium goal?

70

i had 70' and then 80'

and a near miss at 83'

;)

5:41 PM

OK, I get the same. I thought for a moment the feed had different timings.

@ypercube can you access univision.com over there?

Probably not.

yeesh. belg is dominating play now. it's like they finally woke up

Live feed gives me:

> Univision Deportes is not available in your geographic region.

If @bluefeet says its a dupe of a pivot question, I say VtC.

dba.stackexchange.com/review/close/25984

5:52 PM

0

Q: SSAS 2012 Tabular cube disappears after server restart

Currently I am facing issue with SSAS tabular cube. As soon as server restarts, the SSAS cube disappears. Every time server restarts, I have to restore cube everytime and process it again. Please suggest a solution for this. Please let me know if more information is needed. Thanks, Yogesh Chaud...

Part of me is curious, but I don't think I want to know.

@mmarie seems kinda difficult to answer. Are there enough details to answer that?

No, I would have to ask clarifying questions. I just imagine it is something really dumb. Databases don't magically disappear.

@ypercube bum deal

6:15 PM

awesome

blog.42floors.com/striking-back-recruiter-spam

6:27 PM

since we tend to be a sarcastic bunch in here, take a quiz -- buzzfeed.com/lukebailey/…

buzzfeed is awesome

@swasheck a major time suck

whoosh

@bluefeet I had no idea I was so sarcastic.

@MaxVernon I knew I was

6:42 PM

When they start with:

> This table doesn't really require a primary constraint.

you know they have done something wrong.

yah, I'm ignoring that one too. Since he added "details" that are just more confusing than ever.

@MaxVernon He'll soon going to tell us that he hasn't any FKs either.

@ypercube lol.

I love when guys start trucking out the ORM and class inheritance etc, and then ask about how to design a simple table with 4 fields. Really?

Clearly he must be the best one to answer his question.

I'm irritated with each answer on this question -- stackoverflow.com/questions/24270927/…

+1 for not answering the question? Gordon sinks to a new and desperate low, I see.

+1 . . . But only because I don't think the answer deserves a downvote. It does answer the question. The sample result is inconsistent with the text of the question. — Gordon Linoff 6 mins ago

6:50 PM

@MaxVernon none have answered the question - but I think that is because the question is unclear

@bluefeet The question is rubbish as well. Where that 0 comes from?

@ypercube no idea. I'm tempted to mod close that

@bluefeet, I will wait for OP's response and then if found I am wrong will gracefully delete my answer. — Rahul 17 secs ago

but you haven't asked the OP any questions to clarify

@ypercube I closed it. If the OP clarifies then it can be reopened

@ypercube He's added the Foreign Key clause to the table def. :-(

ugh sour grapes. I mean the edible kind, not the other kind of sour grapes

because your answer doesn't scale

@bluefeet . . . You will get two of the values, which seems quite consistent with the sample results in the question. Would you downvote the answer for this reason? I don't understand the downvotes. — Gordon Linoff 1 min ago

7:15 PM

@MaxVernon He made another edit. Brought more confusion. I'll retire from that q, I think.

@bluefeet "because your answer sucks"

or better: "have a fish"

@ypercube I tried to be nice in my response back to him

I really wanted to say stop answering bad questions

Hey, our DBA.SE site is mature enough to give the Generalist badge :)

@ypercube how did it decide to give all 13 today?

@AaronBertrand I asked some weeks ago - can't remember who.

The site needs to have at least 40 tags with 200 questions on each.

Or > 200 probably.

foreign-key got 201 questions today: dba.stackexchange.com/tags?page=2&tab=popular

@ypercube DBA doesn't yet qualify for the Generalist badge. Your 40th top tag (foreign-key) only has 189 questions. Generalist cannot be awarded on a site until all 40 of the top tags have at least 200 questions. — animuson May 19 at 14:46

7:39 PM

Weird to me that Amazon is trying to get in on the phone market... It seems way late for that.

@bluefeet . . . You will get two of the values, which seems quite consistent with the sample results in the question. Would you downvote the answer for this reason? I don't understand the downvotes. — Gordon Linoff 34 mins ago

^dude you never understand the downvotes....

Are we becoming SO?

0

Q: how to design data base for multiple catagories?

Plztell that how to design a database for the shopping cart. i also want to know how to design table for the category and sub category. tell the whole database design with subcategory specially

database-design

(Don't click. That's it, there is no more in that q)

You may want to elaborate on this my good man. — Zane 21 secs ago

A perfect example of how to not write a question.

I chose my good man as a replacement for "you incompetent turd"

2

Just want to confirm what I read in BOL. Found client's physical server with single 6 core processor. Standard Edition is running on the server, which means it would only support 4 correct?

7:45 PM

@ypercube yes

> Plztell

@ShawnMelton what version?

2008 R2, then found another server with same setup I think was 2012.

I always love when a user thinks their downvotes are some sort of miscarriage of justice. — Zane 1 min ago

@ypercube to answer your question in this comment I DV'd the copy answer because it was just that a copycat posted 10 minutes after the first one

Correction one is 2008 and the other is 2008 R2

7:50 PM

@bluefeet No need to explain. Even if he truly wrote it herself, they should have removed it, after seeing it's a duplicate. And I'm not really wondering about why the answers there have downvotes. I made some of them ;)

tagged sql server 2008 but references sql server 2010?

0

Q: How to create a event in Microsoft Server 2010?

How can I create an event that fires ever 5 minutes in SQL-Server? I have been working with SQL in different forms for a couple of years but have never had to create a trigger. And believe it or not I only have currently mySQL books and that is not working exactly as I thought that it would. I t...

sql-server-2008

@ypercube I made many of them too, I just wanted to fess up to that one. :)

@ShawnMelton I want to say yes, but don't quote me on that.

mmm at the bar eating foodball for the first half

@ShawnMelton I don't deal much with Standard but according to this:

msdn.microsoft.com/en-us/library/ms143760(v=sql.100).aspx

4 processors is only 4 processors if they're single core. Should be able to use 4 * quad-core if you've got 'em

Same here for 2008 R2 (above is 2008):

msdn.microsoft.com/en-us/library/ms143760(v=sql.105).aspx

2014 docs are more explicit - cap is 16 cores

msdn.microsoft.com/en-us/library/ms143760(sql.120).aspx

2012 says the same: msdn.microsoft.com/en-us/library/ms143760(sql.110).aspx

Unless I'm a total idiot and reading anything there incorrectly.

^ always a possibility

this one has single 6-core processor with hyperthreading enabled so I by BOL I guess it does.

8:01 PM

@AaronBertrand I'm personally not waiting around for that possibility. Me thinks it might be a while :-)

So you should be able to use all 12

Oh wait yeah you're right. We had a single proc but it was 8 cores just to work the 2008r2 licensing when we were at wand.

Cool, thanks

Glad @AaronBertrand came by. That was dumb of me. I even have a real world example. It must be me tyring to block Wand out of my mind again :)

8:29 PM

innergeek.us/geek-test.html

<--- 39% geek.

and proud

sigh

@bluefeet . . . I disagree with your "scaling" comment. If a question is explicitly trying to pad things to two elements, that seems like a reasonable upper bound to me. — Gordon Linoff 42 secs ago

@bluefeet Ugh, why does that answer have two upvotes?

8:47 PM

@billinkc cuz Gordon is the man.

holy.

cow.

what a game from ochoa

no kidding

though the result wasn't what I had guessed

my coworker said that brazil wont lose because no ref wants to lose their head over a WC match :)

9:03 PM

well, they didn't lose

9:39 PM

@AaronBertrand are you suggesting to always store a start and end time instead of a single duration field?

just curious

If I store the duration as a datetime, then I get ALL the possible combinations of duration, be it hours, weeks, milliseconds, etc.

2 hours later…

11:48 PM

Awesome. iOS 8 beta 2 is loads better. Not crashy. Must have properly rushed the first one out

Fixed the bugs I reported too

« first day (1260 days earlier) ← previous day next day → last day (3625 days later) »

Transcript for

Jun '1417

The Heap™ – Consultancy ©®

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

site design / logo © 2024 Stack Exchange Inc; legal

mobile