The Heap™ – Consultancy ©® - 2014-10-03 (page 2 of 2)

« first day (1368 days earlier) ← previous day next day → last day (3483 days later) »

Lamak

7:00 PM

@billinkc a damn shame indeed

Zane

@swasheck so... Taco Salad!

swasheck

@Zane indeed

Lamak

@ypercube any answer in particular?

bluefeet

@Zane I agree, I love taco salad

ypercube

@Lamak All I guess and none in particular. It's not that they are wrong. But look like teachers who do not understand their subject fully.

Lamak

7:07 PM

@ypercube yeah, I see what you mean

ypercube

@Lamak i.e. "the from operator", "the join clause". The deviations on the outer joins which (I think) irrelevant.

Lamak

right. Damn people who doesn't know that it's "the from thing" and "the conditioning of the join"

ypercube

And the magic button/solution for every deadlock:

...from transactions with nolock where... — paqogomez 2 mins ago

bluefeet

Is it just me but that is not a temp table?

A: How to create temp table from a dynamic query?

SET @SQL='SELECT ROW_NUMBER() OVER (ORDER BY ' + @SortColumn+ ' ' + @SortDirection + ') RowNum, ' + @PrimaryKey + ', ' + @Columns + ' INTO tempTableName FROM ' + @TableName + ' Where 1 = 1 ' + @WhereCondition

calling is temp at the beginning doesn't make it temporary

Anyone have a good reason why someone would use exec('drop procedure etc') instead of just drop procedure etc...?

why execute a sql string?

Lamak

@bluefeet I can think on a very stupid case for it

Zane

7:22 PM

@bluefeet derp derp.

swasheck

@MartinSmith hey. can you educate me? the CTE thing - is it intermediate materialization?

ypercube

@swasheck In general?

Lamak

@swasheck I'm assuming you read his answer about CTEs in dba

swasheck

@ypercube well i guess starting with in general and then stackoverflow.com/questions/26184670/process-stalls-on-tiny-cte

@Lamak no

Lamak

go to DBA.se

and order answers on votes

and then choose the most upvoted one

swasheck

7:24 PM

oh. the temp table one?

ypercube

@swasheck No, it isn't materializing necessarily in SQL-Server.

Lamak

@swasheck ah, you are right

it was table variable, not a CTE

sorry

swasheck

@ypercube i didnt think so. but that's only verified in the query plan, right?

ypercube

Yes, I think so.

Zane

Wow you really drew the wrong conclusion from the accepted answer that you posted. — Zane 7 secs ago

ypercube

7:28 PM

@swasheck, you meant this comment?

This isn't the case as a general statement. Sometimes intermediate materialization helps. Other times it would hinder. — Martin Smith 12 mins ago

swasheck

@ypercube yeah

ypercube

I think Martin means the temp tables when he says that.

Zane

I just can't believe he used such false statement and then posted a link affirming his own wrongness.

bluefeet

@Zane well he linked to something with the word "performant" in the title. That should have been the biggest clue

Zane

@bluefeet My issue with the word performant is it makes the speaker sound like a jackass.

Andriy M

7:38 PM

@ypercube language:none doesn't work (but language: none does).

ypercube

thnx

Max Vernon

@kaptan - please do not think we are "bashing" your question by voting-to-close it. Prior to the question being closed, we provided several answers; all where turned down with "that doesn't work", with no reason why they wouldn't work. Since you have added a fair explanation of why those answers won't work, I will vote-to-reopen your question, in the hopes you may find an answer that will work. — Max Vernon 14 secs ago

Good luck to him.

ypercube

@MaxVernon "I want to to sail the Atlantic on a boat with no sails, no oars and no engine."

Max Vernon

@ypercube and to that, I say "good luck" also!

billinkc

My security mumbo jumbo accurate?

A: Permission to view execution report in SSIS Catalog

With the caveat that I'm not a security person... There is no predefined database role other than ssis_admin that is special to the SSISDB. That allows one to do all the SSIS things but that's clearly more power than a support person should have. There are two schemas, internal and catalog. Cat...

Zane

8:03 PM

@MaxVernon from where i am looking at the question, i believe the question is clear enough. the question is well stated along with the limitations and conditions. the reasons why such limitations and conditions exist are irrelevant to any potential answer. — kaptan 2 hours ago

How suprising that you understand your dumb question quite clearly.

Max Vernon

Can we have one more re-open vote for this one?

-4

Q: How to query from a linked server via a linked server in sql server?

I have the following set-up: SQL-Server 1 --linked--> SQL-Server 2 --linked-> SQL-Server 3 The question is can I query SQL Server 3 from SQL Server 1 via SQL Server 2? I have unfortunately several restrictions: cannot use openquery cannot use views on Server 2 (there would be many of th...

bluefeet

done

Max Vernon

@bluefeet thanks!

swasheck

now downvote into oblivion

Max Vernon

A: How to query from a linked server via a linked server in sql server?

Unfortunately, with the conditions you've placed on your question, there is no way to accomplish what you want. SQL Server would need to support 5 part naming such as: SELECT * FROM server1.server2.database.schema.table; Which is clearly not going to work.

bluefeet

8:09 PM

@MaxVernon why'd you CW your other answer?

swasheck

shamless play for more unicorn points. — swasheck 11 secs ago

Zane

I'm out. See you guys.

Max Vernon

@bluefeet 'cuz I was ashamed of it.

swasheck

Ebola in DC :)

bluefeet

wtf is the point of this self-answered question

Lamak

8:24 PM

@bluefeet the poor guy wanted to releive some stress from your shoulder

(already dv and vtc)

bluefeet

The question makes no sense

if he had some data, maybe it'd be clearer

ypercube

Why did you delete that?

swasheck

flamewar material

ypercube

An absurd comment? I don't think there will be many to agree with that.

swasheck

dont think that there would be many to agree with me that it's absurd? or dont think that there would be many to agree with the comment itself?

Max Vernon

8:35 PM

@swasheck much less out of the mouth of someone that high in society.

@swasheck hopefully not many would think your comment was wrong.

ypercube

Just read the huffington post article. I enjoyed when he compares himself to Frodo.

@swasheck the second of course.

swasheck

@ypercube ah. ok.

@ypercube does that make Clarence Thomas Sam Gamgee?

ypercube

If you say so. (Who is Clarnce Thomas? Have to google)

swasheck

referenced in the article

> “It’s a long, uphill fight to get back to original orthodoxy. We have two ‘originalists’ on the Supreme Court,” Scalia said, referring to Thomas. “That’s something. But I feel like Frodo … We’ll get clobbered in the end, but it’s worth it.”

billinkc

and ultimately you fail at the task you set out to do and the only reason your task gets completed is some nut job bites your finger off and falls into lava

ypercube

8:54 PM

@swasheck Ah, thnx.

bluefeet

9:34 PM

select distinct top 1 * with no order by... I don't understand why

swasheck

@bluefeet to listen to the query processor's laments

bluefeet

the data is being returned via a stored proc - why the distinct if we obviously don't care about what row is being returned

swasheck

@bluefeet you can never bee too sure, i guess