The Heap™ – Consultancy ©®

Mark Sinkinson

08:09

Ah Fridays....Query plan estimating 80 billion rows, actually returns 786....

Andriy M

08:37

Curious Reopen queue item: dba.stackexchange.com/review/reopen/70434

SQLPRODDBA

08:49

Good Morning everyone!

Mark Sinkinson

09:09

@AndriyM Why has that appeared after 2 years?

Andriy M

@MarkSinkinson That what puzzled me and, to be honest, why I posted that here.

ypercubeᵀᴹ

@AndriyM I didn't notice, thought the edit was recent.

Andriy M

My guess now is the first reopen vote made it appear in the queue

ypercubeᵀᴹ

or some glitch in the matrix

Andriy M

I mean, someone came across the question and voted to reopen it – and that put the question in the queue, not the almost 2-year-old edit.

Paul White

10:06

@MarkSinkinson @AndriyM @ypercubeᵀᴹ The author cast a reopen vote 6 hours ago that started a reopen review.

ypercubeᵀᴹ

@PaulWhite Can an author do that? Cast a reopen vote? Didn't know that

Paul White

10:27

@ypercubeᵀᴹ Yes. At 250 rep.

A curious aspect to the "view close votes" privilege :)

@swasheck You asked about WITH ENCRYPTION the other day, so I wrote something.

3

ConcernedOfTunbridgeWells

11:37

Should pop across to London for a few pints.
oh, wait ...

ypercubeᵀᴹ

11:56

Anyone understands this?

0

Q: Is there a grammar equivalent of [0-9] and [a-z]

Is there a grammar equivalent of [0-9] and [a-z] that will let me pull fields that contain grammar?

Shaneis

@ypercubeᵀᴹ Does he mean full-stops (.), commas, hyphens, etc?

ConcernedOfTunbridgeWells

12:13

@ypercubeᵀᴹ I wonder if he's thinking of something like yacc where you can lex to tokens and combine tokens into a statement of some sort.

ypercubeᵀᴹ

Could be either. Or what Martin asked

I presume you are asking how to combine these two ranges in the pattern syntax to match a character that is either a-z or 0-9? If so please edit your question to clarify this. — Martin Smith 12 mins ago

3 people, 3 different assumptions about what is being asked.

A perfect example of "not clear what is being asked".

Shaneis

12:43

@ypercubeᵀᴹ SELECT * FROM #Test WHERE value LIKE '%[I before E except after C]%'?

Darth_Wardy

13:01

@ypercubeᵀᴹ I had a go and suggested an edit ... i probably got it completely wrong though

ypercubeᵀᴹ

it shows that an "anonymous user" made the suggestion. I suppose you weren't logged in the DBA site when you did it.

Darth_Wardy

oh wow

it didn't occur to me it was on a site i was not a member of

Ok, I signed up

does that update the edit to put my name on it?

ypercubeᵀᴹ

I think no.

Darth_Wardy

oh well nvm ... its either worthy of approval or it aint (freebie) lol

but uh ... hi guys ... first time i've actually said anything in here :)

ypercubeᵀᴹ

hi

Shaneis

13:09

@Darth_Wardy hey

Darth_Wardy

hello there :)

ypercubeᵀᴹ

edit approved, after some changes, considering the author's comments

Tom V

interesting what a FORCESEEK does on a query on a single table with a huge number of or's and otherwise a nasty where clause

it looks as if SQL splits up the predicates, does several seeks in parallel and then joins the results together

ConcernedOfTunbridgeWells

@ypercubeᵀᴹ Well, to be fair, my first assumption on reading the question was that the OP had no idea what he was talking about.

ypercubeᵀᴹ

@ConcernedOfTunbridgeWells haha right!

It's weird how so many people has so much trouble expressing themselves

ConcernedOfTunbridgeWells

13:27

I suspect that English might not be their first language. They had confused grammar with punctuation.

Shaneis

It is for me but that didn't help me one bit...

ypercubeᵀᴹ

@ConcernedOfTunbridgeWells I confused office with desk once.

I used "office" instead of "desk" and people at the office were laughing / couldn't understand what I was talking about.

It doesn't help that we use the same word for both meanings in Greek.

Andriy M

14:01

There are many borrowings from Greek in English (as well as other languages). I wouldn't be surprised if the Greek were sometimes laughing as well at what their words ended up meaning in another language.

ConcernedOfTunbridgeWells

Where I come from people often confuse 'Idiot' with 'Middle Manager', but that's not really a linguistic problem ...

4

Andriy M

Do they say "complete middle manager" or "total middle manager"?

2

Paul White

14:26

@Darth_Wardy Welcome.

Darth_Wardy

14:47

@ypercubeᵀᴹ neat thx :)

@PaulWhite hello :) ... I got here from a random link drop in the C# chat by someone ... figured its always nice to mingle right ... lol

anyone here any good with OData ?

Lamak

@Darth_Wardy not that I know of

but it's not as if I know much

Darth_Wardy

lol fair enough .... i got some wierd behaviour ... getting a 404 when I could swear this has been working fine for months and I just wanted to bounce this function off someone to verify im not totally nuts

Paul White

15:12

So everything seems broken except chat.

ypercubeᵀᴹ

yeah, I just got an error

Paul White

It's not just us. How exciting.

We are aware of some users experiencing a Stack Overflow outage. We are investigating now.

Tweeted by StackStatus on May 20, 2016 at 3:13 PM

Lamak

I blame @billinkc

3

billinkc

I wasn't the one optimizing code....

Lamak

I mean, that's obvious, I don't think you've ever optimized anything

billinkc

15:17

I've optimized the pants replacement cycle.

I started with regular trousers, then I learned about elastic waisted garments

Now I'm just sitting in a burlap sack

Paul White

Ha ha ha ha

Lamak

@billinkc I thought you only used skirts

ypercubeᵀᴹ

@Lamak for selfies

Paul White

We see the issues and are disabling CloudFlare for all StackExchange properties now.

Tweeted by Nick_Craver on May 20, 2016 at 3:17 PM

ypercubeᵀᴹ

and the site is up again

Lamak

15:20

@ypercubeᵀᴹ my eyeees!

billinkc

sack/skirt are virtually indistinguishable unless one closely exams the pleats but Chile has enacted a fairly strict restraining order about me coming closer than 5368 miles so no opportunity for you to get an eyeful

Lamak

@billinkc it had been a long time since I'm thankful to my goverment

billinkc

@Lamak I might be in violation by the way, 5368 is the center point according to google maps which is Yerbas Buenas in the Maule Region. If you're north of that, you might as well get the eye bleach ready

Lamak

thanks for the warning

billinkc

I'm just looking to pump and dump the Clorox stock

ypercubeᵀᴹ

15:26

The site is still very slow. As it was in the morning, a few hours ago.

swasheck

@ypercubeᵀᴹ it's because they disabled cloudflare

they wouldnt have this problem if they just used mongo

billinkc

They should get out of the hardware business and move it all to the cloud

swasheck

agreed. there is no hardware in the cloud

and there are no cats in america

billinkc

swasheck

medium.com/@magdoub/…

ypercubeᵀᴹ

15:36

@swasheck I noticed similar lag a few hours ago. (I assume the cloudflare was on then.)

Paul White

Seems pretty nippy from here.

swasheck

yeah. must be that british internet connection

@PaulWhite thanks for the blog post. you always take things to the next level

Paul White

@swasheck It actually bugged for me for a while in the background. You asking about it just spurred me into action I wanted to take anyway. So thanks for that.

The issue earlier was caused by a routing problem, which has been resolved, so all sites should be back to normal.

Tweeted by StackStatus on May 20, 2016 at 3:52 PM

For local values of "normal".

bluefeet

16:01

normal is subjective, like everything else

ypercubeᵀᴹ

@swasheck it's the british nsa, intercepting all traffic. The router changes from SO must have triggered a "re-intercept everything from SE"

swasheck

probably for the best.

mikeTheLiar

16:40

Nevermind I just can't read this morning.

swasheck

16:59

> There is insufficient system memory in resource pool 'default' to run this query

XTP only ...

much buckets

Paul White

17:11

Install 2TB RAM and try again.

swasheck

yeah

my 16gb isnt going to cut it

just for fun ... i made one hash with 10million buckets

Phrancis

18:12

Hey folks

I'm updating my SO careers profile as I am currently back on the job market, would really like to land a SQL related job, and was wondering if you could suggest some blogs I should follow

I'm already familiar with Aaron Bertrand's on SQL Sentry, as well as Pinal Dave on SQL Authority

ypercubeᵀᴹ

18:43

@Phrancis the 2nd is on our To-Avoid list ;)

Phrancis

@ypercubeᵀᴹ is it? why, if I may ask?

ypercubeᵀᴹ

Others I like: brentozar.com/blog

Kimberly Trip

Paul White

@Phrancis Because it is awful and often wrong.

ypercubeᵀᴹ

and of course "our" Paul White, see the links from his profile

Paul White

I felt a disturbance in the force.

Phrancis

18:47

@PaulWhite Okay, good to know

Paul White

SQLblog.com for the old stuff. SQLperformance.com for the new.

Phrancis

Is it primarily T-SQL?

Paul White

@Phrancis Mostly deep internals stuff that no one ever needs.

Phrancis

Okay

Paul White

People seem to read it anyway.

swasheck

18:49

@Phrancis @PaulWhite tells the optimizer how to interpret t-sql. depending on your interest, he may be deep for you.

4

i love reading @PaulWhite because the deep internals appeal to me ... but maybe you'd rather be an expert dev

Paul White

I do not compete with Pinal I think it is fair to say.

6

Phrancis

Is @PaulWhite like the Chuck Norris of T-SQL?

swasheck

he's still good for devs, but i've not yet met a dev who has the stomach for the internals

@Phrancis @PaulWhite is like the zeus of internals

Paul White

DOINK DOINK DOINK DOINK DOINK

swasheck

chuck norris asks @PaulWhite for advice on being awesome

Phrancis

18:51

I have a friend who's into internals a good bit, I guess I'm more interested in dev, though I've never done DBA stuff so I don't know whether or not I would get into deep internals

There's a dirty joke in there somewhere

swasheck

@PaulWhite more than fair

ypercubeᵀᴹ

There are probably many other good blogs, Paul and others here know which are good.

swasheck

(just adding to the doinks)

Paul White

Yep.

ypercubeᵀᴹ

Rob Farley for example, who is a user at the site, too.

Paul White

18:54

I'm still mourning the loss of Google Reader.

swasheck

@Phrancis i like the sqlskills stuff too ... depending on perspective ... Paul Randal, Kimberly Tripp are good ... Glenn appeals to a smaller audience and Jonathan as well. I like them both but they seem to appeal to niches a bit more. That could be my bias.

@PaulWhite i use feedly

this is a fun blog

exadat.co.uk

Paul White

@swasheck I've never tried an alternative. Still stuck in the early stages of mournng.

swasheck

@PaulWhite i honestly dont use it often. my blog consumption has gone WAY down since google reader died

Paul White

@swasheck Yes. I read less frequently than I used to as well.

swasheck

@Phrancis and then there's the CSS SQL Server Engineers' Blog blogs.msdn.microsoft.com/psssql ... some good stuff ... some "meh" stuff

Phrancis

18:56

I'm curious if I would actually enjoy DBA work, I suppose it is very different from SQL dev/technician work

Paul White

I tend to read stuff as I find it. If something turns out to be regularly useful, I might bookmark it.

@Phrancis It's a broad area, and the distinction between db dev and dba varies between countries.

swasheck

@PaulWhite s/countries/days

Paul White

Personally, I've always thought of dba as a rather junior role. The person that does the routine low-skill stuff.

swasheck

@PaulWhite everyone's jr. to you, though

Paul White

I know that is different in different places, but still, the impression has stuck

@swasheck Not true. I have a very narrow specialization.

swasheck

18:58

@PaulWhite meaning backups and security?

Paul White

@swasheck Pretty much. Backups, checking jobs have run successfully, monitoring the day-to-day stuff, granting permissions maybe. Monkey without a gun type scenario.

Adam Machanic describes himself as a DB Dev for example.

swasheck

@PaulWhite that's day-to-day stuff. in most shops that have a dev team and application support teams, it can turn into "TELL ME WHY SQL SERVER DID THIS TO MY QUERY/APP!!! IT RAN FINE YESTERDAY"

"AND I WONT TAKE 'YOU WRITE CRAP CODE' AS AN ANSWER!!! ALL BLAME MUST BE ON THE SERVER OR THE DBA!!!"

Paul White

The world is a complicated place.

Phrancis

Ahh, crap code

Seen a good deal of it, some of it was horrible tangled mess of dynamic queries

Max Vernon

19:28

@PaulWhite - so a DBD! Sweet, a new acronym.

Paul White

@MaxVernon Is "database developer" not common?

Or just my abbreviation of it?

Or yours :)

Max Vernon

@PaulWhite sure, but I've just never heard it referred to as a DBD

its like a DBA but just a tiny bit disarming since no-one will know what it is.

Paul White

@MaxVernon Oh I see! You invented it. Could work.

Max Vernon

it's a bit close to DVD though

Paul White

We do have a strict policy of separation of acronyms.

Max Vernon

19:40

@PaulWhite if you worked here, you'd definitely agree with that. And not because I work here, lol.

@PaulWhite writing DDL that was deprecated in 1972.

Paul White

Ha!

Max Vernon

I shouldn't be so harsh I guess.

we all come from somewhere

ypercubeᵀᴹ

@MaxVernon it's like a DBA, but lower, level D. I'd prefer the DBA+ title.

Max Vernon

@ypercubeᵀᴹ ooooh nice!

Paul White

@Darth_Wardy We were mentioned in the room of drama?!

We could all be super heroes, like the DBAvenger or something.

ypercubeᵀᴹ

19:47

@PaulWhite nice title for blog

Paul White

@ypercubeᵀᴹ Oh that's true. Who is that again?

ypercubeᵀᴹ

Paul White

All the cool DBxxx handles have been taken.

Max Vernon

0

Q: How is raid implemented at the *disk* level?

If disks have 512-byte physical sectors, and you have 10 disks using RAID 50 with a 1MB stripe-size how does that work at the disk level? Correct me if I'm wrong, but conceptually, there would be 2 spans each consisting of a RAID-5 array of 5 disks, one mirrored to the other. Therefore, a "st...

raid

ypercubeᵀᴹ

pix1985, England, United Kingdom

30 7

sql-server sql-server-2012 trigger t-sql duplication regular-expression sql

I don't think they have a blog with the DBAvenger title

swasheck

19:50

@MaxVernon TBD

ypercubeᵀᴹ

All the villains would of course be ... developers ;)

Max Vernon

@swasheck yup

Paul White

@ypercubeᵀᴹ I could have sworn I came across a blog named DB Avenger recently.

swasheck

> The Database Avenger
My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transnational replication.

Paul White

Ha yes I just found it myself.

Our own (@)JamesAnderson.

swasheck

19:53

St. Jimmy

ypercubeᵀᴹ

I found this one

sqlavenger.wordpress.com/about

swasheck

"I began my career as a Novell Administrator." can't be trusted

Paul White

@ypercubeᵀᴹ Never seen that before. James' was the one I was thinking of.

James Anderson, Southampton, United Kingdom

3.6k 1 11 34

sql-server sql-server-2012 sql sql-server-2008-r2 database-design sql-server-2008 t-sql

swasheck

blogs.msdn.microsoft.com/psssql/2016/05/03/…

Paul White

Nothing new in 2016.

swasheck

19:56

@PaulWhite eh? was that sarcasm?

Paul White

@swasheck Yes. Very much.

swasheck

was hoping so, for my own sanity. i thought i was misinterpreting things

Paul White

It's like they just went nuts and decided to do everything in one release.

swasheck

we're currently being bitten by AOAG log send issues. HADR_SYNC* waits are not innocuous

@PaulWhite RELEASE ALL THE THINGS!

Paul White

(and some extra things)

Jeffrey

20:16

Hiya

I'm a bit of a novice when it comes to coding and other databases than SQL and I was wondering something. I want to create an app to find duplicate directories. Duplicate directories as in, with the same content. So I thought of creating hashes of directories and directories with the same hashes are the same.

swasheck

why not use a tool that already does that?

oh ... nevermind. just read

Jeffrey

Say that I want to save the results, what would the be best system to save the results? SQL is the obvious choice for me as I'm not a novice with SQL. But would a NoSQL DB be a better choice? Or even maybe not a database but XML or something like that?

I couldn't find any tool that does really compare contents of the directory

So seems like a nice learning project. Starting off in Python, checking the directories. Step 2 would be to save the results, step 3 to get everything in a neat webinterface.

Paul White

You might be better off asking that in a programmer-oriented chat room.

Not to appear unhelpful, it's just we're all database people here.

Jeffrey

A question about database choice? This is more about administrating a DB and not using it in any application?

swasheck

no. i still think it's a programming question at its core. ultimately the answer to your current question would be, "it depends"

Paul White

20:23

It seems the results you need to store might depend heavily on the programming-level implementation.

Jeffrey

Ok, thanks for your input. I'll try it in the Stack Overflow chat.

Paul White

Once you've decided on that, we might have move to say about the storage.

Jeffrey

Not sure what you mean by that. I want to have Python loop through directories, calculate hashes and save them. Link directories to hashes.

bluefeet

ugh I'm taking an online class and the first lecture this week is about reading from MySQL. In it, it says data are structured in 1) databases, 2) tables, 3) fields in the tables

2

plus, it's MySQL

and a row is a called a record

Paul White

@bluefeet Oh my goodness. Condolences. Who would put you through such a thing?

swasheck

20:27

@PaulWhite some a-hole company

bluefeet

@PaulWhite coursera

Paul White

@bluefeet I assume that's the provider. But who is making you do it?

bluefeet

@PaulWhite me.

I'm not being forced

Paul White

@bluefeet Apologise to yourself immediately.

5

bluefeet

I have, many times

Paul White

20:29

Go, but be careful not to learn anything in the first lecture. Have a nap or something.

swasheck

i thought "nap of something" was another britishism that was going to be lost on us yankees

Paul White

@swasheck Not British.

bluefeet

@PaulWhite It's online, so I can fast forward through the video

Paul White

Bloody Americans.

swasheck

you're practically british ... what with your love of vegemite

or marmite

or thermite

or whatever

Paul White

20:31

@bluefeet Oh well that's OK then!

Jeffrey

Thanks for your input guys. Have a nice day.

Paul White

@swasheck You insulted at least three countries in that one sentence. Well done!

ypercubeᵀᴹ

@Jeffrey looking into how git is implemented might help, too. (or any other VCS)

swasheck

@PaulWhite go big or go home. its the 'merican way

Paul White

@swasheck Gotta respect that.

swasheck

20:39

not really

mmarie

Yesterday I learned that @swasheck and I drive the same model car

And that he is lame and has to go home early instead of hang out afterward.

swasheck

@mmarie you didnt learn that yesterday

mmarie

ok, I re-learned the second part

swasheck

you were reminded of my lameness

lamitude

lamination

mmarie

Today I learned that Azure Data Factory is horribly unintuitive and poorly documented.

swasheck

20:45

sooooo .... it's a microsoft product

why do people insist on a fixed-width flat-file data dump??? it makes imports super cumbersome

@mmarie can biml automatically do a fixed-with import for me?

mmarie

@swasheck Yes (depends on what you mean by automatically, but generally yes). @billinkc has demos for something like that

I think there was maybe also a feature in BIDS Helper that could help with that. I don't remember anymore. I try to stay away from such things. Bill can correct me.

swasheck

@bluefeet did you ever finish your algorithm for post deadness or quality or whatever you were doing?

Paul White

@mmarie Isn't all of Azure that way?

mmarie

Probably. I have less of a problem with Azure SQL Database and Azure ML and Azure AD.

bluefeet

@swasheck sort of, but I had to move on to other things

so I pushed it to the bottom of my long list of things to do

mmarie

20:56

Even Power BI is more intuitive than ADF. Although they had a big upset this week along those lines powerbi.microsoft.com/en-us/blog/where-did-drill-down-go

swasheck

where have all the cowboys gone

bluefeet

I'll come back to it eventually, but with a slight twist on it

mmarie

@swasheck dba.stackexchange.com/questions/118290/…

swasheck

@mmarie it pains me to upvote a @billinkc post

mmarie

heh

bluefeet

21:04

@swasheck i can DV it to counteract your pain

Paul White

21:22

+10/-2 the cowboy in KFC still comes out ahead :(

Transcript for

The Heap™ – Consultancy ©®