The Heap™ – Consultancy ©® - 2017-02-23 (page 1 of 2)

12:02 AM

@McNets On a different note, you could just use COALESCE. If a.col_1 is null, so will LEFT(a.col_1, LEN(a.col_1) -4) be. Therefore, you could rewrite the CASE as COALESCE(LEFT(a.col_1, LEN(a.col_1) -4), LEFT(b.col_1, LEN(b.col_1) -4)).

Same with the other one.

Of course, your current suggestion makes sense too, as it shows the correct way using the OP's chosen syntax. But it would probably make sense to suggest an improved one. (I mean, I consider it an improvement since it's more concise and doesn't appear too obscure to me.)

McNets

@AndriyM you're right, I'm sorry. I was referring to the comments section.

ypercubeᵀᴹ

I would also add a space between - and 4.

ErikE

@ypercubeᵀᴹ I've been learning how to pronounce llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch.

@AndriyM Just be wary that LEFT() with a negative length parameter will throw an error

Andriy M

12:18 AM

@ErikE Maybe not if the string is null.

ypercubeᵀᴹ

@AndriyM even then

but len(null) would be null

Andriy M

Yes. And null-4 will be null as well.

ypercubeᵀᴹ

so errors would appear only if a value has length 3 or less

Andriy M

@McNets Yes, I understood. I was just commenting on something else in your post.

@ypercubeᵀᴹ Which is an issue with the original code, although it might be worth pointing out in the answer as well.

ErikE

@ypercubeᵀᴹ Right, I just get the willies when I see expressions that rely on data being a certain way, without a corresponding constraint ensuring the error occurs at the right time (say, upon insertion) instead of months down the road at consumption time.

ypercubeᵀᴹ

12:30 AM

"the willies"! nice

I saw "the jimmies" in another SO room today!

McNets

12:40 AM

Good night everybody, If anyone has time, any help will be appreciated. Look at trigger comments. dbfiddle.uk/… So, excuse my grammar.

Evan Carroll

@JackDouglas I don't agree that a question that's 6 years old with 380 views, and 12 upvotes on the leading answer determines any policy.

@JackDouglas in fact, a rival answer, yours, has 5 upvotes.

This problem is largely one of entrenched interests. StackOverflow probably doesn't want questions migrated to DBA.SE automatically. And, they probably don't want DBA.SE pushed on their users. From my perspective those desires come second to the theoretical question about what's best for the users and the community. And, if we have the expertise and a more targeted community to answer those questions: that should be supreme guiding principle.

Aaron Bertrand

1:45 AM

@EvanCarroll Nobody has any idea what you're replying to, because you continue to insist on being the cool guy who can't figure out how to use a mouse when the features require it...

ypercubeᵀᴹ

@AaronBertrand he is replying to a comment on his meta answer.

No idea if he could reply there or not, now that he's banned

Still, the discussion belongs there and not here.

Aaron Bertrand

Agreed

And I believe that view count may have been reset when the meta split happened

ypercubeᵀᴹ

just noticed that Evan's answer, now at -7, has been accepted.

Aaron Bertrand

Of course it was. Evan is the only person in this community who comes even remotely close to agreeing with Matthew's point of view. And tbh I don't even think he agrees, I just think he likes that he's not the lone antagonist

Like, really?

I'm not sure how to better explain this to you, other than what I've already written. 1) This site is not good for effiicency -- when I google things about T-SQL and Microsoft SQL Server I am hoping I get redirected to MSDN, if I don't it means the question doesn't have a clean answer. 2) If I get directed here, even on a question that's exactly what I am looking for, the answer is typically unusable 3) If I'm looking up the answer to a question it means I want to settle on a correct course of action or get some cut-and-pastable SQL code. Accuracy is important, so is conciseness. — Matthew Sontum 56 mins ago

Oh yeah, MSDN answers are so much better. /facepalm

That might be one of the most obtuse things I've ever seen said about any stack community.

ypercubeᵀᴹ

@AaronBertrand I would replace "likes" with "feels threatened" ;)

@AaronBertrand I find MSDN questions and answers, I don't know, I can't describe them really.

There may be valuable answers and code there but the format is so ugly.

Aaron Bertrand

1:55 AM

They're terrible. Disorganized, multiple accepted answers, lots of gamesmanship was possible for a long time (people could mark their own answer as the answer, for example).

Answers marked as answers are copied at the top and later below. There's no threading. Everything is an answer.

ypercubeᵀᴹ

And I wonder how one would get msdn as the first link in search. Perhaps if they use Bing, it ranks MSDN higher .

Aaron Bertrand

But hey, I shouldn't talk too badly about it, I wouldn't want to convince Matthew that the grass is greener here.

I think that is exactly right. I don't remember the last time an MSDN answer came up higher in a search than a stack answer.

ypercubeᵀᴹ

I only add "SQL Server" and "MSDN" in search strings when I want to find the documentation of a statement I can't remember the syntax

@ypercubeᵀᴹ I did not mean to be rude. It was late, I was irritated, and I found what to be some very valid and helpful edits to my post, and some purely subjective edits, against my style. I took too great an offence to the latter and regret the way I went about reacting to the latter. I would very much like to apologize to MDCCL if I can find a more direct means than comment here, or I will at least make one here clearly confined to only stating my regret. — ProfK 2 mins ago

@MDCCL ^^^ in case you haven't noticed.

Aaron Bertrand

I add transact-sql (because that's in the header of just about every BOL doc I want to find)

ypercubeᵀᴹ

2:13 AM

If only all users responded to comments / feedback like that.

ErikE

@AaronBertrand I do rarely get something helpful from MSDN that's not on SO/SE, but my experience is that SE has a much higher level of engagement and knowledge.

@AaronBertrand The last thing we need is another frequent visitor that makes us want to smash our head into the wall all the time.

@ypercubeᵀᴹ I personally wouldn't tolerate someone adding spaces to my code blocks for any reason other than raw readability (like, equal depth code portions weren't aligned at the same indent, or the code was wider than the window). Lining up the data type and NULL constraints like this edit would tick me off.

ypercubeᵀᴹ

@ErikE I understand. I find it a bit more readable but I wouldn't edit another answer for that.

I suggest the space because in LEFT(a, LEN(a) -4), the -4 looks like the integer -4, not like the operator minus

removing the space before the minus would look ok, too

@ErikE Ah, you were talking only about MDCCL's edit, not about my suggestion...

I guess it's time I go to sleep

Aaron Bertrand

@ErikE I'm sure that exists, it is just not frequent enough for me to ever bother starting there.

ErikE

2:36 AM

@ypercubeᵀᴹ Correct. Removing all the square brackets would improve readability more than lining up the pieces (imo).

@AaronBertrand I agree, I just use google search and SO is usually the top 3 answers.

MDCCL

2:54 AM

@ypercubeᵀᴹ Thanks. I still think that, apart from other additions, the database-design tag added value to the post. The best part is that a good and concise answer received more exposure.

@AndriyM Yes, I'm not a native English speaker. And as you rightly commented on the post, my objective was to improve the post for future visitors.

ypercubeᵀᴹ

Thnx. the op now feels pressure to improve it ;)

MDCCL

Glad that things got eventually amicable. Time to focus on more productive concerns. :)

MDCCL

3:12 AM

@ypercubeᵀᴹ Hopefully it will help more seekers from now on :)

ypercubeᵀᴹ

@MDCCL I guess I wasn't clear enough. The "op" in my comment above was referring to the op of the answer, not the q ;)

MDCCL

@ypercubeᵀᴹ Well, let's see if the q gets improved eventually. As it stands, it looks like the asker wants to implement a classic relationship of one-to-zero-or-one cardinality, and your answer provides the best method as far as I'm concerned.

MDCCL

3:35 AM

@ypercubeᵀᴹ Ah, I see now, I didn't understand your comment about the "pressure to improve it" initially. If you add a few points to your answer I'm sure it will help even more people. :)

Be right back

hot2use

7:15 AM

Good morning Heapers

Jack Douglas

7:34 AM

@EvanCarroll I don't disagree at all — but our influence is pretty limited. If you want to persuade the SO community, or the people at SE who actually decide these things, I'd say M.SE is the place to try. Perhaps you have more chance of succeeding there than I did 6 years ago, but I still think it is likely to be futile :S

Tom V

8:24 AM

Good morning

Andriy M

8:40 AM

Good morning

Master Database

9:10 AM

1

Q: Comment of OP fundamental to question

When comments made by OP become a fundamental, substantial or integral part of the question, how should moderators/participants notify the OP that the comments should be added to the original question? Adding a comment seems inappropriate, as the comment does not add anything significant. Editi...

morning all

Morning

morning

Does anyone (know anyone who) have some experience with vitess.io?

except watching videos on youtube

In other news, according to Akamai's State of the Internet document, SQL injection attacks already form most of the half of all web application attacks as of 2016Q4

ypercubeᵀᴹ

9:25 AM

@PaulWhite what's that?

Paul White

@ypercubeᵀᴹ You left it in the middle of your comment on my meta answer.

ypercubeᵀᴹ

oops, sorry

Paul White

So I have the same question :)

ypercubeᵀᴹ

I suppose I pressed Ctrl-V by accident during typing and didn't notice.

Paul White

I figured. Was more fun to play it this way.

ypercubeᵀᴹ

9:28 AM

then -> the 014.... n

Paul White

Yep of course

@AndriyM Thank you.

Andriy M

No worries

Paul White

Amazing how often I miss things like that.

Andriy M

Not as often as you spot them, in my estimation.

Paul White

You'd think that would help me spot my own, but the reverse seems to be true!

ypercubeᵀᴹ

9:35 AM

It's easier to spot mistakes in others' work than your own.

@PaulWhite What kind of statements are valid inside a SQL Server's SP?

I mean besides usual INSERT/UPDATE/DELETE/SELECT ..

Andriy M

DDL is valid

ypercubeᵀᴹ

and transaction handling, right?

Andriy M

Various, if not all, SETs

BEGIN/COMMIT/ROLLBACK TRANSACTION, yes

ypercubeᵀᴹ

I suppose that's the main difference with Postgres functions.

Paul White

@ypercubeᵀᴹ Sure. Pretty much everything. Limitations and Restrictions

ypercubeᵀᴹ

9:41 AM

So backup/restore as well

dezso

@ypercubeᵀᴹ and that the latter is not generally viewed as a source of nightmare, unlike (scalar) UDFs in SQL Server

Tom V

Today's "There must be something wrong with the server" explanation "you designed a Bill of Materials with an endless recursion"

dezso

I know UDF <> SP, but still

Andriy M

@ypercubeᵀᴹ That's what I've used in an SP just recently

dezso

@AndriyM interesting

Paul White

9:48 AM

Ola Hallengren's stored procedures would be rather less useful otherwise.

Andriy M

@dezso The client wants (or rather I think our management have persuaded them that they do) to set up another DB server for a remote location. That naturally raised the issue of data replication between the new server and the main server (currently used by all locations). The management decided we don't use any standard solutions and roll out our own instead. Backing up databases and restoring them is what our solution includes.

ypercubeᵀᴹ

@AndriyM I guess that will scale well ;)

Michael Green

@ypercubeᵀᴹ then again, Seamus Heaney started his translation of Beowulf with "so." And he has a Nobel prize ...

ypercubeᵀᴹ

@MichaelGreen All hope is not lost for me then!

Paul White

So it would seem (!)

ypercubeᵀᴹ

9:55 AM

@MichaelGreen Thnx by the way. I might buy that, haven't read Beowulf.

Andriy M

@ypercubeᵀᴹ I've developed a deep aversion to this remote server project because of the way our company decided to handle it. On the other hand, I don't know if I'd have liked it better if we'd chosen any of the available standard solutions (replication, log shipping, mirroring, what-have-you). I mean, I know nothing about them, so...

ypercubeᵀᴹ

@AndriyM that doesn't count (the so is in the end ;)

2

Paul White

Totally wrong.

ypercubeᵀᴹ

So wrong

Andriy M

Haha, I didn't even think about that :)

So, there you are

dezso

10:03 AM

@AndriyM was there any explanation given? rolling your own solution to such fundamental problems is possibly (not (more often than not a good idea))

Michael Green

@ypercubeᵀᴹ it's been a while for me, too. It must have been something special to recite, back when, gathered around the longhouse fire, with a gale blowing up the fjord and wolves howling in the forest close by.

Andriy M

@dezso If you mean an explanation to the client, no, there wasn't, as far as I'm aware. It was up to us to choose the method to handle the problem. We are a software company, they are our client. Of course, their IT representative might be interested, but I'm not sure if there were any questions on their side "as to the whyness".

dezso

@AndriyM I meant an explanation to your own selves

Andriy M

They told us that because no-one in our small company really had any experience with standard replication methods, on the one hand, and the problem itself didn't look too hard for a custom solution, on the other, there was no reason to waste time on first reading the manuals, then deciding which method to choose, and only then starting to implement it. The custom solution did indeed look simple enough in theory. The problem was that the database wasn't ready for replication of any kind.

dezso

heh

Michael Green

10:35 AM

Gaaaah! Can one of The Anointed please correct that typo. It's beginning to irk me.

Tom V

@MichaelGreen First time I flagged something in the heap

Expect an army of mods to show up to see what's happening, and then only having to fix a typo :)

user61230

Oh no, flags. This means trouble.

terdon

Come on, please don't flag for mod attention to have us edit a typo out! Flags are supposed to be used for things that are important, urgent, offensive, hate speech etc. They are shown to all mods on the network and bring our attention, nay wrath, upon your unsuspecting heads. Do not invoke us in vain, please.

Oh and I dismissed the flag as noise because it was.

ypercubeᵀᴹ

@terdon We should request for a feature of non-network-wide flags then.

terdon

@MichaelGreen can't you still edit it yourself? Has the time limit past?

ypercubeᵀᴹ

10:42 AM

Visible only to mods currently in the room.

terdon

@ypercubeᵀᴹ Yes, we should. And we have, but it's complicated :(

ypercubeᵀᴹ

Or allow room owners to edit past the 2 mins. We have like 6 mods and 7 room owners present - before you 2 arrived due to the flag.

terdon

But for typos, all you have to do is wait until some mod visits and ask them. Don't flag! And yes, I do feel your pain. One of the greatest things about being a mod is being able to fix your typos, but nevertheless please don't use flags for trivialities.

There, fixed. Now you made me invalidate my argument since flagging ended up working but it was bugging me as well. Grrr.

ypercubeᵀᴹ

I see wha tyou mean.

Problem is that many don't know that flags get advertised network wide. Or they forget.

terdon

Yeah, a lot of people (ab)use flags. On the other hand, the chat flag system is deeply flawed so it isn't entirely their fault either.

Just, y'know, don't flag unless there's a good reason to. And that does not include "Argh! Terrible Typo!" :P

Paul White

10:47 AM

So tempted to edit it back to loghouse.

And I typed that just to start a sentence with "so". And fat-fingered it. Sigh.

@terdon Sue flags? ;)

Andriy M

Some of them are that offensive

terdon

@PaulWhite Isn't this Law?

ypercubeᵀᴹ

@PaulWhite isn't she allowed to?

Paul White

@terdon Heh!

@ypercubeᵀᴹ Well we'd certainly know who to blame if she did.

@AndriyM You're getting closer, but that sentence still doesn't really start with 'so'.

Michael Green

@terdon yes, I tried; too late.

terdon

10:55 AM

@MichaelGreen Ugh, that's annoying.

ypercubeᵀᴹ

@terdon On the bright side, you got to visit the Heap™ and enjoy our hospitality ;)

terdon

Actually, one fo the first things I did when I became a mod was go and correct some typos in old comments. So I really do feel your pain and realize it's kinda hypocritical of me since I get to do it and you don't. Feel free to ping me, if I'[m around, and I'll happily fix typos, by the way.

@ypercubeᵀᴹ Heh, I have to admit that what little I've seen of Database Administrators suggests you're one of the more welcoming and friendly SE communities.

3

Paul White

:-D

terdon

I guess you were all kicked out of sysadmin school for being too nice/human and had to find a new job huh?

@PaulWhite :P

Your mods now, they're a handful. . .

Paul White

So true.

Michael Green

11:03 AM

Thanks for your help. Apologies for the hassle. On that note I'm off to sleep.

Paul White

@MichaelGreen In the world's most sleepable city :)

Michael Green

(It was meant to be "longhouse", though) <ducks>

Andriy M

@PaulWhite I seem to be getting the hang of it. I probably just need a bit more practice.

Paul White

@MichaelGreen The funny thing is two mods edited it - one to longhouse, then the second to loghouse. It's now longhouse again.

ypercubeᵀᴹ

Oh will you stop please with the edits and the pings? Some of us trying to work...

Or pretend to ;)

Paul White

11:09 AM

Oh yeah ha sorry about that. @ypercubeᵀᴹ

terdon

@MichaelGreen Argh! Sorry! I'd never heard of a longhouse before (is that a beached longboat used for sleeping? :P) and hadn't realized it'd already been fixed. That's another thing about flags: be specific ;)

Ah. Thank you Duck Duck Go.

Andriy M

longhouse

Noun: longhouse (plural longhouses)

A long communal housing of the Iroquois and some other American Indians, the Malays, the Indonesians the Vikings and many other peoples.
1751, C. Gist, Journals, p. 51:
They marched in under French Colours and were conducted into the Long House.
1753, George Washington, Diary, Vol. I, p. 50:
We met in Council at the Long House.

(13 more not shown…)

Paul White

The main advantage of a loghouse is if you don't like the way it looks you can roll it back.

2

Tom V

@PaulWhite nice

Paul White

I'm here all week.

dezso

11:20 AM

@terdon now that you've been here, a simple @terdon will work, until the end of times (unless you don't fix the typos)

terdon

@dezso Hah! That's what you think!

Chat pings only work for the next few (2? 3?) weeks unless I come back again.

dezso

@terdon this is what I meant, yes

Paul White

So the new official process for handling typos is: (1) ping a room mod; (2) we super ping terdon...

dezso

if you keep your promise, it automatically restarts the counter

and we do have typos, right, @ypercubeᵀᴹ?

Paul White

Ooo you'll make him grumpycube if you ping him while he's working

Andriy M

11:23 AM

@PaulWhite Sounds like a good plan. Why don't we share it with the other rooms?

dezso

@PaulWhite I thought he was only pretending

Paul White

@AndriyM To meta!

dezso

@PaulWhite feature-request

Paul White

@dezso Like we'd take any notice anyway

ypercubeᵀᴹ

@PaulWhite sorry. I was joking above.

Paul White

11:25 AM

And I can't even ask you to explain :(

Andriy M

I wonder... why is there no meta.chat.stackexchange.com?

dezso

@AndriyM because all the discussions were moved to chat?

Paul White

@AndriyM To Area 51!

Tom V

@terdon my flag was meant as a joke, which would have previously been explained but unfortunately no longer will be

Paul White

2 days ago, by Paul White

We no longer explain jokes.

ypercubeᵀᴹ

11:26 AM

@AndriyM and a chat.meta.stackexchange.com?

and meta.chat.meta.stackexchange.com and chat.meta.chat.stackexchange.com?

Paul White

I think I'm starting to see a potential flaw...

Anyone else find it ironic that jeagl was lost because someone failed to explain it?

6

2 days ago, by Jack Douglas

I only removed the tag because I didn't understand it

Tom V

@PaulWhite If even mods don't use the search box there is a flaw in the UI design

:p

Andriy M

Well, I thought we were very serious about adding it.

Paul White

@TomV Or a flaw in the mods :)

Andriy M

So, we didn't even know ourselves it was a joke? What an irony!

(^^^ Does that count?)

Paul White

11:30 AM

We mods have more flaws than the Burj Khalifa.

3

Tom V

@PaulWhite I'm under NDA on that subject :)

Paul White

@AndriyM Yeah, but not very creative I'm afraid.

dezso

@PaulWhite one should have post a question with that tag and describe it (at length)

Paul White

@TomV ha ha ha ha

Andriy M

@PaulWhite Back to the drawing board.

Tom V

11:31 AM

Nah, but a customer of ours built the Burj

Paul White

@dezso Post it on meta.chat.dba.stackexchange.com

Tom V

Belgian companies should stick to brewing beer, not build skyscrapers

Paul White

@TomV Really? Just the one dude? Impressive.

Tom V

@PaulWhite Would "client" have been a better term? I can always ping a mod to have it changed

Paul White

Dammit all I'm going to explain that flaws = floors joke a bit.

@TomV I hesitate to suggest a course of action for fear it would be taken seriously and I'd get into trouble.

Andriy M

11:35 AM

@PaulWhite That was too subtle for me.

Tom V

@PaulWhite Building that singlehandedly may have been a lot of work, but then again now he never has to work again, seeing that it cost 876 million USD

Paul White

@TomV Yeah I can imagine.

ConcernedOfTunbridgeWells

11:54 AM

@PaulWhite Dubai Dubai doo ...

hot2use

That was fun.

-7

Q: Is there any way to fix reputation mechanics here?

I have only tried answering questions here for a few days. But I am troubled by the mechanics of the site. So far I've answered 36 questions. Of those 2 were accepted as the correct answer, 7 have received up-votes but were not accepted as the correct answer, 23 have received no votes and 4 have ...

discussion

Andriy M

1:10 PM

That is good, I have accepted the best answer that isn't mine. — Matthew Sontum 1 hour ago

That's just... Honestly, what would it mean for him to say, "I have accepted the best answer here"? No, he had to stipulate.

dezso

@AndriyM which happens to be heavily downvoted

Tom V

> that I, as a developer with 17 years experience (11 as a SQL DBA), who started coding when he was 4, could not answer.

lol

dezso

@TomV where?

Andriy M

@dezso His own answer (which he didn't accept)

dezso

@AndriyM ah, that

SQL DBA

that tells a lot

Tom V

1:40 PM

He graduated in 2010 but has 17 years of experience

Either he and I have a different opinion on experience, or he fails at counting

I once did a mail merge using an access database for my uncle back when I was in my teens, I guess I have 25 years of experience now :)

Aaron Bertrand

He has probably trained himself to overstate his experience because recruiters and job adverts expect it. "We need someone with 10 years' experience on SQL Server 2016!" Um, ok

17 years ago must have been when he played his first video game or something.

Matt

Hey guys. I just started a DBA job where I will be supporting SQL Server 2008 and Oracle 11g. I mostly got the job because of the Peter Principle. I have very little DB experience short of what I learned in college years ago (which is next to nothing applicable now.). I have a grasp of SQL Server 2008 and made a testing DB on a VM for screwing around with. There is a lot to learn but I have a level of comfort-ability with it now. ...

I have nothing for Oracle 11g. Reading a book is not a way for me to learn nor having someone read it to me (that is an example of paid training that sucks). There are some courses online I could take which look promising to give me that same level of comfort however no one teaches 11g anymore. Is 12c training comparable enough that I could take it and apply that knowledge to 11g? Sorry for the length.

Aaron Bertrand

I bet it would be, have you reviewed anything that goes through the changes between 11g and 12c? Have you looked at PluralSight, they have excellent course material that is very well vetted in the SQL Server space, I expect the quality bar for Oracle is high as well.

Matt

My friend mentioned PluralSight. The courses available there actually prompted my joining the stack here just to ask the question.

Aaron Bertrand

1:56 PM

PluralSight is probably pretty close to as good as you're going to get short of hiring a trainer to come in 1-on-1. IMHO.

Tom V

@Matt I can highly recommend them

get a visual studio essentials account and there is a trial included

Aaron Bertrand

And I think you get 6 months free with visual studio essentials?

So there is nothing to lose to give it a try.

Tom V

it used to be 6 in the beginning and they reduced it to 3 @AaronBertrand

which is still pretty good of course

Matt

2:15 PM

Sounds good guys. It comes in at 300us a year which is not bad either. Even 30 a month if good for short stints. Thanks for the help. 3 months should get me started just fine.

dezso

2:33 PM

@Matt don't forget to ask good questions on the site ;)

Joe Obbish

@Matt I would expect it to be the same. you might cover some new features only available in 12c but I doubt there will be that many

Matt

@dezso That will happen.... but I need to have good ones to ask first. Not "What does select * mean? Why didnt I get a star back?"

3

Jack Douglas

@Matt yes, just ignore anything about pluggable databases

McNets

2:51 PM

I'm sorry, but, comes my V. Studio Prof. licence with 6 free month on PluralSight?

@JackDouglas Can I ask sth about sdfiddle?

db

Jack Douglas

@McNets sure, fire away

McNets

Does it save the text, I mean generates a new id, every time you press run?

It seems it save a new version on every execution.

Joe Obbish

I like this headline: "FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct"

Jack Douglas

@McNets yes it saves the text every time

McNets

3:06 PM

@JackDouglas isn't it a waste of disc space? And, will be Ctrl-Z (undo) available?

Jack Douglas

@McNets you can use the browser back button for undo - that's the benefit

Ctrl-Z works inside a textarea as usual of course

McNets

@JackDouglas ah, ok. Thanks!!!

Jack Douglas

it will waste disk space but that's my least scarce resource :)

McNets

@JackDouglas and it allows to enable triggers, it was great for my last test.

Jack Douglas

on SQL Server?

McNets

3:14 PM

Yes

It should not? dbfiddle.uk/…

Tom V

@McNets No with a dev essentials account

visualstudio.com/dev-essentials

McNets

I was looking at MyVisualStudio, still haven't activate any benefit...

Jack Douglas

@McNets yes it should — the grants are different on each RDBMS. I want them to be as permissive as possible without making it stupidly easy to bring down (or hack) the servers.

McNets

3:32 PM

@JackDouglas it's really a good job.

Jack Douglas

Thanks for the encouragement, it's still early days :)

I'm getting closer to having SQL Server 2016 working…

McNets

I'm sorry I don't know nothing about Azure prices. What can I do with this:

Paul White

@McNets Microsoft Azure Pricing calculator

Tom V

@McNets Run one instance of their slowest VM part time

McNets

As far as I understand I have $50 every month, for the rest of my VStudio subscription...

Tom V

3:44 PM

JK, it's ok to spin something up for a couple of tests and turn it off again, so it can be useful

ify ou get into the basic pricing model you could run some dev vm's

Just don't forget to shut them down when you are not using them

wBob

@McNets Always shut down VMs from the portal, not from within the VM itself. Otherwise it's not properly deallocated and you still get charged.

Paul White

Azure SQL Database is cheaper than a Windows SQL Server VM as well. Per unit time.

$50 isn't much, but it's genuinely $50 more than $0.

Matt

@PaulWhite That math looks sound

McNets

Ok, thank you. I'll try.

Paul White

@Matt Appreciate the sanity check :)

Matt

3:58 PM

I didn't even need to bring out the calculator for that one.

Got my 3 month sub for PluralSight running. Feel less stressed now that I have something to learn a little from.

McNets

4:16 PM

First benefit I'll from early days

Registered user: 1306

Max Vernon

4:45 PM

@McNets nice! That logo goes back a long time, too!

McNets

I think it has more than 25 yr. When I buy my first Quick-C ediion

@MaxVernon this is it.

QuickC

Microsoft QuickC was a commercial integrated development environment (IDE) product engineered by Microsoft for the C programming language, superseded by Visual C++ Standard Edition. Its main competitor was Borland Turbo C. QuickC was one of three Microsoft programming languages with IDEs of this type marketed in the same period, the other two being QuickBasic and QuickPascal. QuickBasic later gave rise to Visual Basic as well as being included without a linker as QBasic in later versions of MS-DOS, replacing GW Basic. QuickC is a lineal ancestor of Visual C++. The three Quick language implementations...

Max Vernon

@McNets I remember using QuickBasic; but don't remember QuickC. Very interesting! I do still have a copy of Visual C++ provided to me by Microsoft for writing a review way back around 1993. That brings back memories!

Andriy M

I remember reading somewhere they also had QuickPascal.

Andriy M

5:16 PM

Only just noticed it's mentioned in the linked wiki page as well. Good job paying attention on my part.

Max Vernon

5:39 PM

@MatthewSontum - I get it; you're mad that expertsexchange.com got bested by Stack Overflow — Max Vernon 1 min ago

McNets

6:10 PM

@MaxVernon I barely remember, but I think QuickBasic didn't allow to deal with RS-232. And using C you could merge _asm code in your apps. I don't remember where, there wasn't internet, I had an assembler routine that allowed me to save the contents of the screen, and retrieve it during the vertical refresh interval to avoid flickering.

La descripción en mi perfil es clara en este sentido.

I'm sorry, The description in my profile is clear in this regard.

Max Vernon

6:32 PM

@McNets no worries! My memory is just the same way.

Evan Carroll

6:49 PM

IT IS I, THE GREAT, EVAN "THE GREAT" CARROLL

I never understood why bans didn't work in chat. Such a weird system.

Max Vernon

If you were chat-banned, how would we get to see your greatness?

Evan Carroll

I'm not saying a chat ban would be bad for the community. Jesus Christ, I feel horrible for what the admins have brought down upon dba.stackexchange.com.

Ignoring that no one is answering these questions, the whole community must be going through collective withdrawal.

Joe Obbish

anyone willing to offer an opinion on if this should be closed?

1

A: Complex query optimization

It looks like you have a bit of a kitchen sink query going on there. It can be difficult for SQL Server to create a good query plan when you have so many filters that may not be relevant to the query. As a test try running your query with the OPTION (RECOMPILE) hint. Note that adding that hint me...

I've tried to help the guy

Evan Carroll

I imagine Pg users everywhere are convulsing. And, Microsoft users are rejoicing in their new found safe-space. Mods also get to relax having their reign totally unchallenged. All is well though, I'm still running in the next election.

McNets

@EvanCarroll are you banned in dba.se????

Evan Carroll

7:01 PM

Yepppp

Joe Obbish

but when I get answers to questions like "there are more indexes on tables." what hope is there?

MDCCL

@JoeObbish Yes, I think it should be closed because, as it stands, it's not clear what the OP is asking, and he/she has not provided enough information to clarify the Q.

I'm not sure if it should be closed as unclear what you are asking or too broad, though.

Evan Carroll

This query is wack.

and Microsoft just has an especially poor query analyzer.

@FirstName = '' OR (@FirstName <> '' AND what does that even mean?

Joe Obbish

@MDCCL Does tip of the iceberg fit?

Evan Carroll

Let's analyze just this little turtlehead. ( @FirstName = '' OR (@FirstName <> '' AND (c.FirstName LIKE @FirstName + '%')))

Same as this ( @FirstName = '' OR (c.FirstName LIKE @FirstName + '%'))

And what does this mean... LEFT OUTER JOIN Address ON address.accountid = c.accountid and Address.Addressid = c.AddressID Why are you repeating the condition?

MDCCL

7:09 PM

@JoeObbish I don't think so. In my opinion, if the OP provides table definitions including indexes, etc. and other relevant aspects it may get more clear. I voted to close it as unclear what you are asking, let's see what happens. You've done more than enough helping with the information available.

Joe Obbish

@MDCCL makes sense, thanks

MDCCL

@JoeObbish My pleasure

Max Vernon

8:39 PM

did someone just kick-mute poor old Evan?

I was contemplating it.

Andriy M

@MaxVernon The thought flashed across my mind too while I was struggling to keep myself from replying to him.

Tom V

@MaxVernon Did you hear a doink?

I was just getting online

Max Vernon

no

although I wasn't really paying attention all that much

Andriy M

I wasn't wearing my headphones, so I wouldn't hear if there was a doink.

Tom V

@MaxVernon did you get a phone call from microsoft regarding the vNext on linux program yet?

Max Vernon

8:46 PM

@TomV no, I haven't. But I probably don't rate.

you?

Lamak

why was he banned from dba?, I mean, in this particular ban

Andriy M

Poor Evan. Everyone was ignoring him while he was here. Now that he's gone he's the centre of our attention.

Tom V

@MaxVernon Yeah I got a call from a london number I thought were headhunters

Max Vernon

@Lamak he was flagged and some mod other than @AaronBertrand banned him. I'm unsure why.

Tom V

After turning down a number of calls I picked up anyway and it was some girl from microsoft inquiring about vNext on linux

Max Vernon

8:48 PM

from Oracle? ;-)

Tom V

@MaxVernon I flagged a comment but I doubt that was what got him banned, he seemed to think so but I'm not convinced that single flag did it

Lamak

@MaxVernon I see

McNets

@la The in(famous) accepted answer with 8 down votes.

Max Vernon

@TomV as far as I can tell, none of our mods would ban someone for a single comment.

McNets

@Lamak sorry

Tom V

8:49 PM

@MaxVernon Nah, a sincere question about the probability of us running it in prod over the next x months and if we needed access to some extra inside info/resources

When I replied "We'll run it in production if you migrate azure to it" she was a bit confused

Max Vernon

@TomV oh I see.

Lamak

@McNets I missed it

Tom V

No need to repost that crap for the third time :)

Max Vernon

no doubt

Andriy M

@TomV Just bringing Lamak up to speed :)

Lamak