The Heap™ – Consultancy ©® - 2014-02-18 (page 2 of 2)

« first day (1141 days earlier) ← previous day next day → last day (3728 days later) »

FreshPrinceOfSO

10:00 PM

@MikeFal he came in here once and told me that I couldn't talk about non-dba topics

Phil

This place is 50% DBA talk 50% awesome.

Mike Fal

50% DBA talk, 110% awesome, really

mmarie

@MikeFal Hmmm.. your math is fuzzy. Have you been talking to the marketing people again?

Mike Fal

@mmarie DO NOT QUESTION ME

Marian

@MikeFal how's the Oracle upgrade? :)

mmarie

10:03 PM

@MikeFal Simmer down, old man. No one is on your lawn ;-)

Mike Fal

@Marian Running. The Sr. Oracle DBA here wrote a pretty good doc

Phil

@mmarie he just used mysql to do a GROUP BY when doing his calculation. The numbers are correct*

Mike Fal

@Phil Wrong! I pulled them out of MongoDB. Eventually they'll be right.

Phil

@MikeFal what version are you going from/to?

Mike Fal

@Phil 11.2.0.2 -> 11.2.0.4

Minor upgrade, no big deal

Phil

10:05 PM

Very sensible. I'd have slapped you if the first number was a 12

Mike Fal

Hey man, I'm only doing what I'm told by our Oracle folks.

Phil

11.2.0.4 is rock solid. 11.2.0.1 is terribad. There's a user on here (Kupa? Maybe) that keeps on asking questions that are mostly fixed bugs :/

Mike Fal

Yeah, we're rolling out 11.2.0.4 to fix a bug. Some parallelism mutex thing

What interested me most about hearing about this is that, apparently, in Oracle you have to tell it to parallelize a query, whereas SQL Server will just do it.

Phil

@MikeFal Not true. oracle.com/technetwork/issue-archive/2010/…

You just have to enable parallelism for the table

You can force it with a hint if needs be

Mike Fal

@Phil Ah, ok. Well, still, SQL Server will always attempt to parallelize based on server settings

billinkc

10:16 PM

That's why I always maxdop 1 all the things

mission

Has anyone tried CBT Nuggets or Pluralsight? Is it any good?

Marian

@mission pluralsight has a demo period (I remember a few hours of training).

you should try it.

There are great trainings from Paul Randal and his SQL Skills people.

mission

oh, ok! that's nice :D thanks!

Mike Fal

@billinkc I swear to God I will stab you.

billinkc

@MikeFal As long as those stabs are serialized, I'm ok with this

Mike Fal

10:23 PM

@billinkc Oh, not only serialized, but in a row based cursor

A nested loop of stabs, if you will

billinkc

Careful, the police will easily tie that back to you

FreshPrinceOfSO

@billinkc * the ~~police~~ NSA

Marian

@billinkc it's mandatory on Sharepoint :-).

Phil

This chat room probably already has 2 full time FBI operatives assigned to it. A good splattering of KGB people too

Mike Fal

What, no Mossad? I'm insulted

enderland

10:28 PM

@Phil who's the other one?

Phil

Hides

I bet the regulars in here could do a great deal of damage to the world, given the machines they have access to.

Mike Fal

And then there are the BI Devs.

Phil

@AaronBertrand did the OP comment on this and then delete the comments? dba.stackexchange.com/questions/59150/… I swear I got notifications for it a few hours ago

FreshPrinceOfSO

10:47 PM

@bluefeet here's a pivot question for you

-3

Q: Pivot in SQL 2008 R2

I have table like this; Date PlacementName campaignID Impressions Clicks TotalConversions Activity 01/01/2014 USA 100 5000 500 50 Mobile Book 01/02/2014 U.K 101 7000 250 30 Mobile Bo...

vtc

-1

Q: SQL filter using 2 dates + SAS

I have a dataset that looks like below ctry start end I have a second dataset b that has ctry start end as well as other columns I would like to filter the second dataset based on ctry, start and end dates Thanks so much for your help!