The Heap™ – Consultancy ©® - 2017-09-27 (page 1 of 2)

« first day (2458 days earlier) ← previous day next day → last day (2412 days later) »

6:27 AM

morning

3rd day w/o smoke

6:46 AM

morning

7:11 AM

Good morning.

7:21 AM

Morning

7:45 AM

Howdy

@McNets almost a non-smoker now

8:04 AM

morning

@gbn as in 'I have a very strong self-control. Already came off smoking three times.'?

8:34 AM

@dezso I stopped smoking twice (for 1 year and then again for 1 1/2 years) before I quit the last time (5 years ago). As soon as you want to smoke again you will. But nicotine loses its grasp on you the longer you stay clean.

whyquit.com/whyquit/A_Symptoms.html

The social aspects (rituals?) of it are maybe harder to fight. Beer and a ciggy. Post-meal ciggy. Tea break ciggy.

8:50 AM

What I never understood where my friends "wake-up ciggy" ritual. Yuck!

9:44 AM

Vaping is the way forward

10:13 AM

@hot2use Kinda related.. when I first came to Switzerland, I assumed the traditional Swiss breakfast was an energy drink and cigarette while waiting for the bus or train.

@hot2use It's the second time I stop smoking, first time for 6 years...

@PaulWhite do you vape?

@McNets damn dude, what made you start after 6 years quit?

@sp_BlitzErik obviously my own stupidity

10:31 AM

Ah, I quit back in March of 2009. Smoked one a handful of times since but the prospect of having to quit again is horrifying enough to keep me away.

10:52 AM

A friend of mine vaped and is now back on cigarettes.

Vaping in N.Z. is probably better than cigarettes, what with a box costing 28 NZ$.

how many real dollars is that?

they're about $13-15 a pack in nyc

11:13 AM

NZ$ 28 <=> US$ 20.18

(20 cigarettes / pack)

no wonder paul vapes

:D

And they cost US$ 8.20 in Switzerland

11:25 AM

@sp_BlitzErik Yes it was the only way I could give up.

Also it's much cleaner and cheaper. Much.

10ml of juice costs less than $5. That would last me best part of a week.

any plan to quit vaping?

i keep hearing people talking about popcorn lung from inhaling the... whatever

juice cloud

Not really. I enjoy it. I have cut down the nicotine content to the minimum and the next stage will be to go zero.

I have no desire to upgrade to the higher power units that produce a huge amount of cloud. I like the little ones.

@hot2use Amazingly cheap compared to salaries. A bit odd TBH

@gbn lobbying be the word

Like eye watering expensive paracetamol

11:38 AM

@PaulWhite Which one do you use?

@TomV I have three that I've acquired over the past year or two. The two main ones are eGo-T.

Yes. A friend once bought a bottle with 30 Zyrtec for around US$ 16 in America. A pack of 10 tablets in Switzerland costs SFr. 12.90 (US 13.20)

It is eye-watering

@PaulWhite I stick with the eGo AIO

It's a nice little device

I once bought it as a "starter kit" and then tried some things that people call "upgrades" but I always came back to the simple device

Yeah me too (as a starter kit). I much prefer the basic ones as well.

@TomV When the -Ts need replacing I'll probably get an AIO.

@PaulWhite (or any mod): Could you possibly link the tag [sql-server-2016-express] to the [sql-server-2016] tag as a synonym? I used it in this question:

0

Q: Pos Performance Issue Ax2012R3

I have slowness. Can anyone review this plan (PasteThePlan) and tell me what I need to optimize? SQL Server 2016 - Express Edition

sql-server query-performance sql-server-2016

11:53 AM

@hot2use Sure.

@PaulWhite Thanks

@hot2use Done.

12:07 PM

@hot2use /ducks

dear lord

0

A: How to fully recreate database in MS SQL server 2016 from exported data

Try following steps... Shrink data file - DBCC SHRINKFILE Run DBCC CHECKDB w/Repair Allow Data Loss Backup Database Restore Database Manually grow database file to accommodate anticipated future growth.

I once went to a seminar with Itzik Ben-Gan as the host. Then I bumped into him again later at Heathrow. He must clear 2 or 2 packs of fags a day (if he still smokes)

maybe i need nicotine back in my life

@sp_BlitzErik I find cakes a good replacement

i'm fat enough

12:13 PM

"cuddly"

"great personality"

mmm cake

that ax question is a POS

maybe they should use some of their dynamics consulting bucks ;)

whistles

select * from view -- slow, plz help

well, they're not wrong

12:20 PM

@TomV I know. But being a good saint, I formatted the question and added a tag even though it might be closed.

12

Q: Why shouldn't I delete wrong answers?

The FAQ says that wrong answers should be downvoted, not deleted: For answers, any post that is not an answer (should be a comment, doesn't answer the question, etc.) should be deleted. Answers that are wrong or that dispense poor advice should be downvoted, not deleted. The FAQ doesn't exp...

discussion vote-to-delete

@sp_BlitzErik Wanted to down-vote. Anybody with me?

I think his issue is with the logisticselectronicsadress table, but they messed with it

@hot2use i'm gonna mess with him in the comments first

@sp_BlitzErik LOL

@PaulWhite Thanks

12:24 PM

@sp_BlitzErik @hot2use if it's that Jared Hunt he used to be a PFE

@PaulWhite i think you've shown me that before, but my flags for people who say to run dbcc checkdb with allow data loss don't necessarily fall into any of those.

that's someone potentially losing data and getting fired

not just "not a best practice"

@sp_BlitzErik I have some sympathy, but the question mentions checkdb with data loss.

@TomV @---@

> ...Of course I use dbcc checkdb, even with REPAIR_ALLOW_DATA_LOSS (when it asks)

I edited in a warning (in bold)

12:26 PM

Also:

> Recently I get many consistemcy errors

The errors seem to have spread outside the database :)

If I keep getting corruption, I move the database off to a different new drive. Then start tinkering.

@PaulWhite you've gone soft since you became sullen origami

@sp_BlitzErik Soft clone on duty today :)

But seriously some general advice: we (mods) generally only delete content that is egregiously harmful or completely useless to the site.

High rep users can vote to delete.

The best way to start a delete review is to flag as NAA or VLQ, as appropriate to the case at hand.

Custom mod flags do not enter the user review queues.

interesting fact

the vlq flag doesn't always come up

And finally, "this is terrible" flags stand a better chance of being accepted if the post was already downvoted (and maybe commented on). Edit to improve is another option, as is provide a competing, and much better answer.

@sp_BlitzErik Yes it is only available for the first 7 days and until an upvote is cast IIRC.

12:31 PM

on that answer it didn't. i had everything but vlq.

that's why i did custom.

Ok then I'm going to mark it as helpful but not delete.

you're a true pal, soft paul clone

I was going to leave it to another mod since declining flags is mean, but you've given me a way out now that won't hurt our flag handling time stats :)

@sp_BlitzErik Is VLQ still not available to you?

it showed up after the first downvote

should i switch?

I see it as a flag option on that answer, but I'm not sure what I see is representative.

@sp_BlitzErik You have no active flags on that answer. Up to you if you VLQ it.

70

A: Is the Very Low Quality flag too ambiguous?

VLQ means the flagger thinks this post is beyond saving -- no amount of editing or polishing will turn this particular turd into gold. It is a call for a pooper-scooper. To clarify this, we are making the language a bit stronger: very low quality This question/answer has severe formattin...

12:36 PM

might as well

> VLQ means the flagger thinks this post is beyond saving -- no amount of editing or polishing will turn this particular turd into gold.

One of my favourite meta quotes.

oh, here's a question

how come we don't have the link-only answer flag over here?

@sp_BlitzErik No such flag

i swear i've seen it on SO

Oh maybe. SO is special

12:38 PM

i thought it was a good flag, since link-only answers are blah blah because links can expire etc and so forth

They miff me a bit when it would only take a few seconds longer than flagging to edit some useful info from the link into the answer.

Of course there's an army of bored mods who enjoy that sort of menial task so.

I think @JackDouglas taught me that.

I flagged something as link-only once, and he declined it while making the edit I should have.

He's so wise.

I guess SO has scale problems we will never experience.

you may be miffed all you want, but you should understand that proper editing isn't always possible or easily accessible when mobile :)

Thanks!

Leave it to someone else who isn't on mobile?

2

always happy to hold a candle to your darkness, soft paul

they may not have my keen editorial eye

I'm very much still learning.

12:42 PM

these unwashed masses

Oiks the lot of them

@sp_BlitzErik is anything easy on mobile? :p

@JackDouglas swiping

or so i'm told

that means stealing where I come from

@JackDouglas the 50s?

12:45 PM

the tills in Sainsburys keep asking me if I've swiped my clubcard

@sp_BlitzErik I think you can tell by comparing our beards that I'm younger than you :P

my beard is pretty tidy for a guy who works from home

perhaps the fact that you're an oracle user who is taken seriously made me think you're older. that crowd seems to all be 40-50+

@sp_BlitzErik "works"

I'm 42

@JackDouglas I manage to vote using the app sometimes. If I'm persistent.

@PaulWhite swipe to vote does make some sort of sense

12:49 PM

Well it's supposed to be a tap but it resists me mightily on occasion.

@JackDouglas i'm only 36, at least until november

Typically when I'm abusing HNQ.

HNQ?

Hot Network Questions

aka the clickbait Q & A

does 'abusing HNQ' just mean browsing them?

12:51 PM

@JackDouglas Yes and "joining communities" just to vote up.

I think that is HNQ abusing you

4

That may well be true!

ha ha

i've joined several communities by accident

I feel a punchline coming

i've joined several communities by accident

thanks for the edits here, @PaulWhite

12:53 PM

@JackDouglas Partitioning, logical replication, parallel plans. Hard to choose. But I won't go to the meeting today :(

@sp_BlitzErik No worries.

Kris Gruttemeyer

Hey everyone, are schema changes logged in the transaction log (FULL recovery)? Had an issue yesterday, software vendor says there was a schema change that broke their stuff but we can't find anything that changed. I'm also looking through the default traces

i already tried the built in SSMS 'Schema Changes History' report and it came up with nothing

what sort of schema changes?

Kris Gruttemeyer

isolation level

not sure that's a schema change

Kris Gruttemeyer

12:57 PM

the error they got:

Snapshot isolation transaction failed in database 'DBName' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.

This db has RCSI enabled on it

Ooo yeah those can be tricky.

I think TRUNCATE TABLE counts for that, for example.

@KrisGruttemeyer And SI too? That's an SI error, not RCSI.

"are schema changes logged in the transaction log" -> yes. They can be rolled back, they can be replicated etc

Kris Gruttemeyer

Yeah, this is a third party replication provider. @PaulWhite just saying RCSI so we have the whole picture since there's isolation level sorcery involved

@gbn so theoretically, they can be read from log backups?

@KrisGruttemeyer It basically means a metadata version was bumped, but that can happen for things people wouldn't necessarily regard as being DDL or a "schema change". Rather technical.

@gbn aren't some schema changes metadata only? i'd be interested if renaming a table or index is logged.

1:01 PM

Yeah rebuilding an index will do it too IIRC.

i've genuinely never looked or really thought about it

CAN OF WORMS

Kris Gruttemeyer

@PaulWhite any further information on that or whitepaper (or hell, a book that I can buy) that can elaborate?

@KrisGruttemeyer On what? The can of worms?

Kris Gruttemeyer

The 'rather technical' part

so yes

haha

1:02 PM

There's some mention of it in the white papers on SI/RCSI and possibly the stats one. Honestly I forget, and it's not well documented at all.

Trial and error is fun, if time-consuming.

Start an SI transaction, do various things to referenced objects, see what breaks.

Also open a Connect item asking for it to be better documented :)

At the risk of drying up the consultancy dollars.

Hey @sp_BlitzErik @JoeObbish blog challenge ^

@KrisGruttemeyer "a schema change broke their stuff" = "a transaction failed" ;)

@KrisGruttemeyer If you hover over a message you want to reply to, there's a little arrow on the far right. Helps with context, if you haven't noticed it before.

Kris Gruttemeyer

@PaulWhite Gotcha

@ypercubeᵀᴹ And they're lacking retry logic/error handling.

Optimistic concurrency comes with pessimism about errors.

Kris Gruttemeyer

@ypercubeᵀᴹ That's what I'm leaning towards. They query the object metadata often to check for any schema changes. Is it possible to throw this error and not, in fact, have any real DDL performed?

1:08 PM

Someone would have to provide a rigorous definition of "real DDL".

Kris Gruttemeyer

@PaulWhite Metadata, I think someone mention index renaming?

Something not structural.

16

A: TRANSACTION ISOLATION LEVEL SNAPSHOT vs. TRUNCATE?

The list of 'DDL' operations listed is not comprehensive (and TRUNCATE TABLE is not the only omission from that list). Whether TRUNCATE TABLE is DML or DDL is a fraught question in SQL Server, with persuasive examples on both sides of the debate, and entries both ways in Books Online. From the p...

Kris Gruttemeyer

(Waits for the request to provide a definition of 'structural') :)

So is truncate structural? Rebuilding an index?

Do read the Q & A above. I found that while searching Google LOL

At some point I'm going to have to face the fact I have already written everything I know.

4

Kris Gruttemeyer

@PaulWhite Looking through it now

Also gotta start trudging through the log backups and default traces

1:14 PM

It's not to late to change career.

A general observation, not a directed suggestion!

I was thinking of maybe starting a sandwich shop.

@PaulWhite would your sandwiches have cheeky names?

Ideally

@PaulWhite There is a sandwich shop close to where I live, the guy running it asked me at some point what I did for a living. I was thinking about how I would explain that to him and started out easy "euhm, things with computers" to which he replied "like what?" So I hesitated to say "Its a thing they call ERP". His immediate reponse was "SAP or Dynamics?" which obviously surprised me

turns out he was an IT manager for years and got tired of it and opened a sandwich shop with his wife

Ah so it's a common career path

That's encouraging

important question: will you deliver to nyc?

1:22 PM

And my condolences on your SAP/Dynamics

@sp_BlitzErik There would be a not-insignificant delivery charge

what if it was like, a lot of sandwiches?

Geez I could murder a sandwich and a coffee right now

@PaulWhite I don't think a kiwi meat sandwich sounds very tasty

@sp_BlitzErik That might be different. I confess I haven't fully thought this through yet.

remember what happened the last time you had a carb

computer: boom

1:24 PM

true

@Lamak I can't think of a family-friendly way to respond to that

are we family-friendly now?

Search chat for the phrase

You'll find 10% of everything Joe has ever said in here

@Lamak I assume you meant meat from the kiwi bird, rather than meat from NZ in general

Meat from the fruit would make no sense

let's just assume lamak didn't mean dicks

@PaulWhite of course I did (seriously)

@sp_BlitzErik I suppose someone had to say it

Footlong sub is the norm here

1:29 PM

i hear you order them by the yard

It's an interesting exception to the metric system

To be expected from the American Imperialist sandwich chain perhaps

Hence the urgent need for a local alternative

yeah the 30 centimeter sub doesn't quite ahem

roll off the tongue

if you will

LOL

30 cm sandwich would be "half a baguette" here, you can get 3/4 of a baguette too

That sounds much better than 30 centimeter sub

That has a nice ring to it

1:33 PM

so "baguette" is a standard unit of measure

SI unit of sandwiches

Royale With Cheese

you would be surprised

Baguette (pain)

Une baguette de pain ou simplement baguette, aussi appelée baguette de Paris, ou encore pain français (canadianisme et belgicisme), mais aussi pain baguette est une variété de pain, reconnaissable à sa forme allongée. Même si cette forme de pain est emblématique de la France, la baguette est également consommée dans différents pays comme le Maroc, l'Algérie, la Tunisie ou le Vietnam, ce qui s'explique par le passé colonial français de ces régions. == Présentation == Une baguette standard est large d'environ 5 à 6 cm, haute d'environ 3 à 4 cm et longue d'environ 65 cm. Elle pèse environ 250 g....

Actually I could totally go for a brie/salad baguette right now

> Une baguette standard est large d'environ 5 à 6 cm, haute d'environ 3 à 4 cm et longue d'environ 65 cm. Elle pèse environ 250 g.

Pretty standardized then.

1:41 PM

i bet there's a hotline to report sub-standard baguettes

sub-standard subs

that can be the name of paul's 5cm sandwich shop

Accept no substitutes!

"sub standard"

©

1:43 PM

You can get bigger baguettes but they are called "flutes" and smaller ones but they should be called "demi baguette"

same with regular bread, there is a minimum weight to a bread for example

I always thought flutes were smaller than baguettes

just call it a loaf and be done

Thanks to the EU we even have minimum and maximum sizes for cucumbers, also stating that they have to be straight

because they've solved every other problem

time to focus on the cucumbers

> Commission Regulation (EEC) No 1677/88 of 15 June 1988 laying down quality standards for cucumbers

1:45 PM

Isn't that more about the number that will fit in a standard box though?

i would sp_blitzexit too

That may underestimate the ability of the poms to come up with daft regulations of their own

Why on earth do I think I know things about cucumber regulations

because you're going to need them when you open a sandwich shop

Especially if you ship internationally

Goodness me you're right

1:49 PM

if you ever need a dedicated sandwich artist, i've been told my meat stacking finesse is inspired and unparalleled

Like I could afford your services

@TomV Interesting story. Is the sandwich shop performant enough?

i'd mostly work for free sandwiches

phones Brent

yesterday i learned that you have to go 238 pages into jon skeet's answer history to find one with <10 votes

1:58 PM

@PaulWhite I'm not smart enough to blog about isolation levels

@JoeObbish what about approving comments?

don't you hate it when people leave comments that are difficult to respond to?

are you talking about the comments on my blog post from yesterday?

negative

also, why does pass sell T-shirts for $32?

is there some guy making them by hand in his basement?

there's a big hole in the budget to fill from BACon

2:02 PM

haven't heard of that

ed zachary

@sp_BlitzErik so, your finesse is serializable?

@sp_BlitzErik people actually go to that?

@Lamak i'm like a sandwich mutex

@JoeObbish no, that's the problem...

why don't they just stop doing it

hey tables can be locked? who knew!

2:09 PM

@JoeObbish i believe they have

@JoeObbish yeah, go figure.

don't tell him what to do

chile out bro

this locking thing sounds like it could be bad for query performance. can I not do locking? TIA

@JoeObbish avoid locks at all costs

the more i know about trivial plans the less i like them

what's your latest observation?

2:23 PM

user image

does disabling parameterization change anything?

haven't tried

I can't repro that

though I'm not using the same database

with the same query pattern I get a parallel plan

no tricks

no parameterization for me

wonder if we have a different db setting somewhere

maybe different data distros?

one year query: 281098 rows, hundred year query: 29499660 rows

different ctfp setting?

5, table is much bigger than that

gut feeling is it has to do with parameterization

2:31 PM

the plan reuse is certainly part of that

let me look up how to force it

> Commission Regulation (EC) No. 2257/94 of 16 September 1994 laying down quality standards for bananas, sometimes referred to in the media as the bendy banana law, is a European Union regulation specifying classification standards for bananas, which took effect on 1 January 1995.

> It was replaced by Commission Implementing Regulation (EU) No 1333/2011 of 19 December 2011 laying down marketing standards for bananas, rules on the verification of compliance with those marketing standards and requirements for notifications in the banana sector with effect as of 9 January 2012.

they should have laws for rape and murder, too

I thought this would be easier

oh well

user image

intellisense!

2:55 PM

well, now we know what kris' sock puppet account is

0

Q: MSSQL Sys Trace

I trying to get some change records in SQL server for tables view and stored procedure. I have tried right click on the server->Reports->standard reports->schema changes history. But it doesn't show all the history from the beginning. How far can I do sys trace as currently, I am getting the la...

sql-server sql sysdba

Kris Gruttemeyer

@PaulWhite would changing permissions on a login to the DB be considered DDL. Specifically adding it to a default role like )db_datareader)

Kris Gruttemeyer

3:14 PM

It sure is

And now I know what happened. We added a user to that DB.

I should get better at staying out of hospitals

Tweeted by Zanebrunette on September 27, 2017 at 3:12 PM

Whoa, megaman has megalarge tweet

he say what happened?

@billinkc magalarge?

Nothing yet and more like magalargo

hopefully he's alright

3:26 PM

yeah, no scotch in the hospital.

that's a silly place to be.

3:59 PM

2017-09-21: PostgreSQL 10 RC1 Released

2

If he's there for a while we should send flowers again

Although credit goes to bill for being thoughtful last time

4:54 PM

@ypercubeᵀᴹ pertinent question: can it send flowers to zane?

5:08 PM

@sp_BlitzErik If you started a company "Flowers to Zane", it'd run it for free, never think about crashing, and wouldn't bother to ask for a Windows License.

@EvanCarroll good to know you work for free

Sad to know, we all do. =(

The joys of SE: ONE DAY I WILL OBTAIN THE COVETED GOLD BADGE.

after taxes, yeah

Is there a coveted tag?

Tag synonym for postgresql

I just joined the 15k club.

Huzzah.

UNSTOPPABLE! Quake 3 Arena Sound Effect

5:40 PM

I believe gbn worked at an online flower shop at the time but we didn't know. So bill ordered elsewhere and the service was crap

We did get to have some fun SQL injecting the site that almost screwed us over

@TomV typical @billinkc

though it was a good gesture

Worst of all the site ran on MySQL

5:55 PM

this probably isn't the most secure channel to talk about exploiting a commercial website

@sp_BlitzErik are you saying we are snitches?

evan is clearly an nsa stooge

"check me out i love open source software and i totally protest stuff that sucks"

« first day (2458 days earlier) ← previous day next day → last day (2412 days later) »

Transcript for

Sep '1727

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile