The Heap™ – Consultancy ©® - 2013-02-25 (page 2 of 2)

« first day (783 days earlier) ← previous day next day → last day (4382 days later) »

Zane

20:13

@CadeRoux finally got my Ingress Invite.

dezso

@JackDouglas order by 3?

Jack Douglas

@dezso Each expression can be the name or ordinal number of an output column

or, quite possibly, I have done something wrong and I don't understand the Q :)

Zane

@AaronBertrand Cumulative Cost makes me happy

dezso

@JackDouglas of course, but why? :)

I mean I never use ordinals but names

Cade Roux

@Zane Resistance or you're dead to me.

@Zane Where are you?

Zane

20:18

MSP

Resistance.

Jack Douglas

@dezso I'd have to nest again or repeat the expression though :)

I agree it usually gets me into trouble :)

dezso

@JackDouglas sqlfiddle.com/#!12/0af9c/12 ?

Cade Roux

@Zane Looks like MSP is dominated by resistance. Still, you should be able to level up pretty quickly - looks like a ton of portals.

Jack Douglas

@dezso doh. edited and thanks!

Zane

@CadeRoux That's something I wanted to ask you. How do you see that. Like the expanded overall maps

Cade Roux

20:27

@Zane ingress.com/intel

@Zane Plus get this extension which is like completely awesome: github.com/breunigs/ingress-intel-total-conversion#readme

swasheck

20:46

Kim Hathaway: "You have to be careful with query hints."

Zane

@swasheck incredibly careful.

JNK

is @bluefeet around?

I NEED A PIVOT!

bluefeet

@JNK yup

JNK

awesome

let me see if I can figure this out

if not I will bug you

swasheck

@JNK seems you've already accomplished this part

Zane

20:58

@CadeRoux my neighborhood seems pretty active. I have much to get used to atm.

JNK

@swasheck what

@swasheck do

@swasheck you

@swasheck mean?

this is kind of a mess b/c I need dynamic columns

I may be hitting this the wrong way actually

Cade Roux

@JNK Dynamic SQL to build the column list, then make the pivot dynamically.

@JNK stackoverflow.com/questions/159456/…

JNK

@CadeRoux I was gonna do that but too many columns I think

I have rows of SQL Server permissions

It has like permissionName (i.e. execute, select, etc), state (grant/deny), object (stored proc, db, etc)

And I need to put this into a DW

bluefeet

21:14

can I respond with a snarky comment?

@bluefeet i guess if this were a pivot question, u would respond ;) — Артём Царионов 47 secs ago

Cade Roux

@JNK What would too many columns be? Too many columns as a SQL Server limit?

@JNK It's all going to be code-generated, so a hundred columns is as difficult as one.

JNK

@CadeRoux Too many to be usable/readable

I don't know what else to do though, I guess I'll just leave it somewhat normalized

Andriy M

21:33

Hi guys

swasheck

ohai

Andriy M

I wonder if any of you has got a suggestion on the best course of action in this case:

@AndriyM I would delete the question but since it has an answer I cannot. — Blam 19 mins ago

The question was confusing from the beginning, despite the asker's several attempts at elaboration.

And it now appears to have been based on the wrong premise

So I can understand why one could be willing to delete it

It does have an answer, which is likely irrelevant: the answerer misunderstood the question (not his fault)

Roy

What question, anyway?

Andriy M

Q: Using @Local Table Variable With ()

Would like to nest a @Local Table Variable DECLARE @local_variable QueryWa is a User-defined table This throws a compiler error DECLARE @Wa AS QueryWa; ( insert into @Wa ([sID],[wordPos]) select top 10 [sID],[wordPos] from [FTSindex] where [sID] = '2' select * from @Wa delete ...

Zane

@swasheck the room reference?

Michael Fredrickson

21:39

@Roy Clicking the timestamp (19 mins ago) will take you to the comment..

Roy

@MichaelFredrickson Ahh, right. I'm all used to those big nice question summaries :)

Alex Poole

Hello folks. Is this question too open-ended for dba.se? Just wondered if you'd want to pull it pver here, and don't want to suggest the OP re-ask it if'll just be closed here too...

JNK

@AlexPoole NARQ/Unanswerable

is there a "right" answer to that question?

ypercube

@AndriyM You can comment on the answer (and suggest deletion or altering the answer).

You could also just summon @AarolamaBluenk here. He is usually around.

Andriy M

@ypercube That's a good idea. I wasn't sure if I should leave a comment, but asking him in chat would be fine.

@ypercube Would the OP be able to delete the question if the answer was deleted?

ypercube

21:50

I think so. But I don't care much. That user in my favourites list.

JNK

@AlexPoole Really it's a brainstorming question, which is inherently not a good Q.

Alex Poole

@JNK - nope, but wasn't sure if the discussion aspect would be more welcome here. The description on the VTC off-topic options is a bit softer than the FAQ; site for DB enthusiasts, or something like that. 'No' is fine, just wasn't sure *8-)

ypercube

@AlexPoole You have some good ideas on the comments there, like the VM machine.

Oh, you are not the OP. Sorry.

Alex Poole

@ypercube - no, but the VM was my comment *8-) Not pushing for it, was just curious, and the OP's idea is somewhat interesting. Though breaking things is generally not the hard part of course....

Cade Roux

@JNK You mean in the DW? Sometimes you do have to be normalized in the DW. We ended up having to do that for the customer profitability system at the bank where there were a tone of different buckets for measures on an account and some were dynamic and they were always changing.

@JNK Does make things a LOT slower when you can't just say PROFIT = SUM INCOME BUCKETS - SUM EXPENSES BUCKETS when you have to do a whole bunch of pivoting before you can add and subtract things.

Aarolama Bluenk

22:06

@ypercube Just saw the notification; what's up?

Andriy M

@AarolamaBluenk It's about one of your answers

stackoverflow.com/questions/14960482/…

Aarolama Bluenk

@AndriyM Just read through. It's deleted.

Andriy M

@AarolamaBluenk Ah, that's why it doesn't show the summary! :) Thanks

Aarolama Bluenk

@AndriyM No worries :)

swasheck

whew

Zane

22:26

God this place is maddening. They want me to be their full time DBA their full time BI developer and run fix all of their problems with their new transactional database.

They want the Datawarehouse to somehow be 100% real time but they want to use cheap hardware to do it

Aarolama Bluenk

@Zane Ask them to double your salary

Mike Fal

@Zane Document your time. So you can prove that you can only do so much.

Mike Fal

22:41

Hrmmm....this guy looks like a winner. He is, after all, an Ace CTO:

AceCTO

sql-server storage performance san sql

Michael Fredrickson

@MikeFal One of his answers is a little concerning to me...

A: How to organize a single query to several sql servers?

You appear to need linked servers; [Microsoft SQL Server Linked Servers] http://msdn.microsoft.com/en-us/library/ms188279(v=sql.105).aspx You can attach the 2000 instance from the 2008 server to use in your queries, depending on the amount of data and connection speed the performance may not ...

Should you really be establishing linked servers across the open internet?

Mike Fal

@MichaelFredrickson I certainly wouldn't.

Michael Fredrickson

Doesn't sound like an ace answer to me...

Zane

22:56

@MikeFal I do that already.

swasheck

23:13

@Zane linked servers across the wild west?