The Heap™ – Consultancy ©® - 2017-07-31 (page 2 of 2)

ypercubeᵀᴹ

1:13 PM

How to flag this? (it's not in dba, it's in SO Discussion!)

stackoverflow.com/documentation/s/td/g/184/324

Paul White

@ypercubeᵀᴹ Flag the comment?

That's just a guess. I have no idea about Documentation and didn't even know Discussion existed.

I wonder if we'll get Discussion tabs for Q & A pages one day (replace chatty comments and/or associated chat rooms)

Lamak

@PaulWhite I tried to get into it when it started...hadn't come back since

Paul White

There's a reason good documentation is written by people with specific experience and skills

i.e. proper Technical Writers

I suppose an infinite number of monkeys would produce good documentation eventually

Philᵀᴹ

1:30 PM

I just want the SE toolbar to be at the top of chat, as I was promised several years ago :P

sp_BlitzErik

seriously

i hate having to open other tabs to see if i've gotten any points >;(

Philᵀᴹ

22

Q: Chat and the SE toolbar

I quite often spend plenty of time in chat without ever navigating back to DBA.se. Is there any way of making the Stack Exchange toolbar (as it appears on DBA.se) appear at the top of the chat page so that I can see notifications, rep changes etc? I'll just give this a little edit in the vague ...

I'm sure I was told at the time that it was in development

Oct 7 '15 at 13:15, by Phil

Oh, and I still want the SE toolbar at the top of chat that I was promised 2 years ago!

Haha, history repeating itself

sp_BlitzErik

better call sol: dba.stackexchange.com/questions/182242/…

Paul White

Consistency is important to DBAs

sp_BlitzErik

i'm curious! does anyone active in this room have "dba" in their title?

i haven't been a dba in 2.5 years

Marian

1:36 PM

me, though the active bit is done through lurking lately :)

sp_BlitzErik

and even when i was it was iffy

Paul White

That debate was fought and lost many many years ago

I liked "Database Professionals" but ... looks around

3

sp_BlitzErik

looooooool

Paul White

@Philᵀᴹ Should be implemented soon. They're making great progress on the outstanding requests:

33

A: What features did the Community Team discuss, have implemented, or have denied last month?

Features in the "built" lists marked with a "‡" were in the QA phase at the moment the post was edited. They'll appear on subsequent months' "built" list if further work was warranted, or won't if they just cleared QA successfully. June '17 Update! Welp, turns out our prediction from April's up...

Philᵀᴹ

@sp_BlitzErik Nope I'm a mere peon

sp_BlitzErik

1:38 PM

@Philᵀᴹ i'd say you're mayor peon, don't sell yourself short

is there a way to see notifications after you've cleared them?

without going to the inbox in a new tab

(phil wins another prize for that idea)

Paul White

@sp_BlitzErik Chat notifications?

sp_BlitzErik

those very ones

Paul White

@sp_BlitzErik chat.stackexchange.com/users/208889/sp-blitzerik?tab=replies

sp_BlitzErik

wow, that's a hunt

thanks though

ypercubeᵀᴹ

@PaulWhite yes, I meant Documentation, sorry

Paul White

1:46 PM

@sp_BlitzErik The link is, but just go to your chat profile.

e.g. Click your own name in the side bar here

sp_BlitzErik

Paul White

He's daft but we like him

2

Don't Americans (mis)pronounce that Boo-E?

sp_BlitzErik

yeah, but that just about matches the way musical sensation flava flav would say "yeah boy"

everything i talk about will be on your future visa applications, so pay close attention

Paul White

Prodigy

Philᵀᴹ

I pronounce it buoy

Paul White

1:52 PM

#NotHelpful

Tom V

sp_BlitzErik

@TomV but how would cagots say it?

Tom V

If you follow the middle dutch etymology it's boo-e

sp_BlitzErik

heckuva lot of dutch named stuff in nyc

staten island is lousy with kills

Tom V

Not sure if you cared though

Paul White

1:54 PM

Buoy: One of the few words I would say has an unnecessary 'u'

@TomV What's with all the intellectual contributions recently?

You're really raising the average, which is a concern

Tom V

@PaulWhite I was merely trying to maintain the average after Erik's appearance

4

sp_BlitzErik

@TomV i'm gonna live blog about how much that hurt my feelings

Paul White

@TomV Nicely done

sp_BlitzErik

@PaulWhite i know dislike extended events but

new for 2017

ypercubeᵀᴹ

@sp_BlitzErik because it was first a Dutch colony?

Paul White

2:06 PM

@sp_BlitzErik sys.dm_exec_query_optimizer_info is so last year

sp_BlitzErik

@ypercubeᵀᴹ ja vriendelijke eilandman

@PaulWhite there's just no pleasing you

Tom V

@sp_BlitzErik What was the original sentence you let google translate?

sp_BlitzErik

"yes friendly island man"

ypercubeᵀᴹ

who's the island man?

Paul White

@sp_BlitzErik On the contrary I have an extremely low threshold. I come here.

Can we add Extended Events to the PowersHell and Git category?

sp_BlitzErik

2:10 PM

@ypercubeᵀᴹ all of us, i suppose~

@PaulWhite yes, but i've solved problems with xe, so i'm a little less harsh on it

ypercubeᵀᴹ

@sp_BlitzErik I'm more confused now! I thought you meant Manhattan. Or Staten or some other one from NY state

Paul White

@sp_BlitzErik Problems like being in too good a mood? Too much spare time? Lack of XQuery in your life?

hot2use

I just broke my local master trying to PULL upstream/master (SQL-Server-First-Responder-Kit) into local master and then PUSH back up to origin/master. Had it all synced and running.

Paul White

A problem we've all faced

hot2use

:-/

sp_BlitzErik

2:14 PM

@ypercubeᵀᴹ a long time an old coworker someone told me that you live in greece (totally unrelated, and maybe wrong)

Paul White

Sorry, that wasn't very empathetic was it

sp_BlitzErik

helpful and empathetic®

ypercubeᵀᴹ

Yeah, I did. But Greece isn't an island unless you consider the whole Europe+Asia a big one ;)
I grew up 150 km from the nearest sea.

Shog9

@Philᵀᴹ in the meantime, try: stackapps.com/questions/7404/top-bar-for-chat-rooms

6

Philᵀᴹ

@Shog9 Cheers, darling

sp_BlitzErik

2:16 PM

@ypercubeᵀᴹ yeah, like i said, unrelated.

Philᵀᴹ

<3

hot2use

@PaulWhite It was helpful. Karma.

bluefeet

Woah a Shog appeared

Paul White

Still trying to work out what invoked it

And which room owner kicked him out

sp_BlitzErik

2:33 PM

someone who really hates authority, apparently

Lamak

@sp_BlitzErik sql authority?

I know a few

sp_BlitzErik

@Lamak such shade

Paul White

How to make a million dollars from your blog

Lamak

@PaulWhite did you ever get that signature that @TomV was supposed to get you?

sp_BlitzErik

i just hit 200 blog posts, which is roughly 10% of the blog content on BO

i'm waiting for the gigantic check

Paul White

2:40 PM

@Lamak Still waiting. Every day I check the mailbox with an excited look on my face, but no.

Lamak

@sp_BlitzErik you do realize what we are talking about, right?...or do you need jeagl?

Tom V

May 22 at 14:45, by Tom V

I failed to get Paul's present

Lamak

@TomV ah, damn

Paul White

😓

Tom V

@sp_BlitzErik I liveblogged that Pre-Con in here though :)

sp_BlitzErik

2:41 PM

@Lamak yes i know, but i've spent time with the person this jeagl is at the expense of, and i like him quite a bit (even if his blog is a bit BOLlywood)

Tom V

@sp_BlitzErik Yeah, we're mostly kidding because of his blog. He seemed like an OK guy

Lamak

@sp_BlitzErik just making sure

Tom V

He's catering to a certain crowd and is really good at that

sp_BlitzErik

i really thought BOLlywood would have done better in here

Paul White

Meh you've done better

Lamak

2:44 PM

@sp_BlitzErik it just shows that @TomV's comment about maintaining the average of the room was spot on

sp_BlitzErik

@Lamak man, i'm getting beat up in here today

Paul White

@sp_BlitzErik Lack of Obbish

Lamak

@sp_BlitzErik sorry, sorry

sp_BlitzErik

next time i'll wear both helmets

Philᵀᴹ

Oooh, need to take my drone with me and hike to see this jarrelook.co.uk/Urbex/B29%20crash%20site/B29%20site.htm AWESOME

Paul White

2:57 PM

@Philᵀᴹ Did you try that top bar for chat script?

sp_BlitzErik

was there a readme for how to install?

Tom V

@sp_BlitzErik stackapps.com/tags/script/info

sp_BlitzErik

@TomV you're just too helpful for this room

Tom V

I must add the script works fine for me on FireFox

It shows 0 reputation change, as expected

sp_BlitzErik

3:13 PM

what about now?

Tom V

Are you sure you wanted to up-vote that one? :)

sp_BlitzErik

i picked it specifically because it was stuck at 9

Tom V

The top bar showed the rep change and the nice answer badge, so it's working

Paul White

3

A: Chat and the SE toolbar

As suggested in chat by Shog9: In the meantime, try Top Bar for Chat Rooms (stackapps) Provides a fully functional top bar, including realtime notifications, easy chat server switching, and fast room list searching, at the top of all chat rooms. Keep tabs on your inbox and site acti...

sp_BlitzErik

@TomV nice

oh my god it worked

McNets

3:21 PM

Tampermonker doesn't detect git.hub script

Tom V

@McNets did you click the "raw" link?

McNets

nope

Tom V

the "github raw" link was detected by greasemonkey

McNets

@TomV should I now reload chat room?

sp_BlitzErik

yeah, that's how i did it

McNets

3:23 PM

oh did it

Philᵀᴹ

4:06 PM

The script works well in Safari using TamperMonkey

Paul White

Good

Joe Obbish

4:22 PM

so much talking!

@sp_BlitzErik Do you remember when we talked about looping over CCIs a while back?

sp_BlitzErik

@JoeObbish yessir

Joe Obbish

4:41 PM

@sp_BlitzErik You can add an IDENTITY column

it's like magic

sp_BlitzErik

that'll break parallel inserts

but you usually maxdop 1 those anyway, i suppose

Joe Obbish

well it would only be on the source table temporarily

I don't think it'll end up helping in my particular case, but could be a useful trick one day

sp_BlitzErik

how big is this table?

Joe Obbish

10 billion rows

sp_BlitzErik

so your big plan is to add and drop an identity column to a 10 billion row table?

Joe Obbish

4:46 PM

it sounds really bad

but COLUMNSTORE

it's less than an hour on my desktop and ~30 GB of log

sp_BlitzErik

hour long outages are frequently acceptable in production

dezso

@JoeObbish borrow TomTom's phone

3

Joe Obbish

it would be during a downtime, yes

it's not my plan at the moment, but it's an alternative

@dezso I'm too young to understand the reference

sp_BlitzErik

@JoeObbish borrow boss baby's phone

Joe Obbish

you think I've seen that movie?

oh yeah

how'd you like the emoji movie

sp_BlitzErik

4:53 PM

it was awful

Joe Obbish

any redeeming qualities?

sp_BlitzErik

tj miller tried

tried and died

there was one part where the high five emoji ate a lot of candy in candy crush and made a bunch of cocaine references (like "i can't feel my face"), and i think it just made all the parents uncomfortable

"stop making coke jokes in front of my kid"

Joe Obbish

hey man, spoilers

sp_BlitzErik

then you won't want to know that there's a happy ending

Joe Obbish

the movie ends and you can leave?

sp_BlitzErik

4:56 PM

yeah, usually rose will want to listen to songs in movie credits, but she ran out as soon as they rolled

Joe Obbish

Why'd you go anyway? Kid wanted to see it?

sp_BlitzErik

yeah

Joe Obbish

maybe I'm out there on this issue

but I feel like advertising to kids is one of the scummiest things

sp_BlitzErik

some of it is pretty bad

Joe Obbish

how old is the kid?

sp_BlitzErik

5:00 PM

4 and about a half

Joe Obbish

wonder how people designing ads feel

sp_BlitzErik

probably the same way oracle sales reps feel

Joe Obbish

I've heard some interesting stories

though nothing that sounded as bad as the socket -> core switch

sp_BlitzErik

5:28 PM

is this overly rude?

I'd suggest you improve your attendance to the class this homework is for, first ;) — sp_BlitzErik 28 secs ago

Joe Obbish

it's deserved but I would consider it to be "nonconstructive"

sp_BlitzErik

i can live with that

ypercubeᵀᴹ

5:50 PM

@EvanCarroll the info on the (rather useless) tag says "For questions about recording the last time a row was modified. ". The question is about when only a specific column is modified. — ypercubeᵀᴹ 27 secs ago

Incoming edit war ;)

For those interested, see the revision history and the tag suggestion at meta:

5

A: Tag suggestion: mtime-row

As I mentioned in chat, ideally you would have asked the community for feedback on this new tag before creating it, and new tags should come with usage guidance at a minimum: @EvanCarroll What the heck does mtime-row mean? If you're going to create a tag, at least add some usage guidance and ...

Michael Green

6:09 PM

@PaulWhite I mentioned it here a while back. It went well, thank you. Very introductory level stuff, but then this is new theory to most people and new implementation to everyone. As there is so little in SQL Server yet I also demo'd another, mature, product (Neo4j). It was interesting seeing reactions change from "why would I bother" to "ohhhh".

sp_BlitzErik

so graph in sql server is uh... a bit incomplete?

Michael Green

6:45 PM

@sp_BlitzErik Yes, that's a nice way of putting it. They've dipped their toes in the water. Or at least have their socks off and are standing on the damp sand.

I don't want to be disparaging, though. When it lands, it will be a "how did we ever live without this" thing. I imagine Linux is soaking up a great deal of time and brainpower just now.

Lamak

6:59 PM

@sp_BlitzErik but seems promising

@sp_BlitzErik did your daughter want to see it too?

sp_BlitzErik

@MichaelGreen yeah, would imagine so (re:linux). wonder why they include such incomplete stuff. should have all hands on linux if that's the focal point of the release. sheesh.

Joe Obbish

" I do have 5 indexes (1 CI, 1 NON-CI)."

sp_BlitzErik

@Lamak she would have been fine seeing captain underpants for the 4th time

Joe Obbish

what

sp_BlitzErik

"what it feels like to chew five indexes"

Joe Obbish

7:02 PM

3 disabled indexes?

Lamak

@sp_BlitzErik I still don't know if your reply was sarcastic or not...

Joe Obbish

can't figure that one out

sp_BlitzErik

@Lamak no, she likes that movie. she really wanted to see emoji movie though. i think she's been cured of that.

Lamak

@sp_BlitzErik ah, ok. I'm tempted to jeagl, but it was so unfunny that it's better this way

@JoeObbish where?

Joe Obbish

that's the problem

I don't know where the three missing indexes are!

sp_BlitzErik

7:05 PM

in the missing indexes dmv

duh

Lamak

@JoeObbish no, the comment, where did it come from?

Joe Obbish

This is to minimize the future disk space required at its current growth. Yes, we are an ERP software company so, we have Licensed EE. This table is only for archive when some checks are performed and all the data resides in this table. I do have 5 indexes (1 CI, 1 NON-CI). None of the columns are VARCHAR (MAX), they are either NVARCHAR(), int or date type. — Sid 1 hour ago

I'm going to attempt to talk about recovery models

this won't go well

Lamak

@JoeObbish talk about mathematics too

we should ask @ypercubeᵀᴹ to intervene

Joe Obbish

I majored in that

Lamak

@JoeObbish but I trust @ypercubeᵀᴹ

Joe Obbish

7:09 PM

oh, I finally get what this guy is talking about

man, some people make it so difficult

Lamak

@JoeObbish how?

Joe Obbish

how indeed

"ALTER INDEX cannot be used to repartition an index or move it to a different filegroup."

but why

Lamak

why indeed

sp_BlitzErik

15 hours ago, by Joe Obbish

I'd ask but that's probably a long discussion

Joe Obbish

but say I'm doing a REBUILD

is that so unreasonable?

Lamak

7:18 PM

yes

Joe Obbish

Are you in helpful mode or unhelpful mode?

ypercubeᵀᴹ

@Lamak I'd ask but that's probably a long discussion.

2

Lamak

@JoeObbish I'm in the "I slept 5 hours total since friday" mode

Joe Obbish

that's a bad mode to be in

sp_BlitzErik

@Lamak up partying?

Lamak

7:29 PM

I wish

but no

sp_BlitzErik

7:40 PM

AGs are such a pain sometimes

DUUUUUUUUUUUUUDE

-1

Q: Split hyphenated nvarchar value

I have a table with 6 columns one of which is a NVARCHAR (65) datatype. All of the entries in this table have the format XXXXX-nnnnnn. I want to be able to use the '-' as a delimiter and construct a query that pulls out the value after the '-' into a temporary table so I can run another query a...

sql-server t-sql temp-tables splitting

Joe Obbish

it's not even a difficult splitting question

use substring

congrats, you did it

Tom V

'it all seems hard and difficult'

Please find a new line of work

Is this correct?

0

A: Can a database's files be copied while a database is online?

Can a database's files be copied while a database is online? Yes. All you have to do is set the database to read-only: Run: USE [master] GO ALTER DATABASE [Database] SET READ_ONLY WITH NO_WAIT GO Copy the database files - MDF,LDF, etc. to their new destination Once copy is done, you can...

ypercubeᵀᴹ

8:03 PM

@TomV I think so but not sure.

sp_BlitzErik

well. it's pretty f wording r worded even if it's doable.

Joe Obbish

just use tempdb for everything

Transcript for

The Heap™ – Consultancy ©®