The Heap™ – Consultancy ©® - 2017-06-16 (page 2 of 2)

ooh, one small thing: you talk about the legacy CE, and then in some parts reference 'changing the CE' -- that might confuse people if they think certain code might change the cardinality estimator and not just the estimate

Joe Obbish

I like to think that we moved past the days of the 80 character terminals

good poitn

I'm out, thanks for the feedback

sp_BlitzErik

anytime

hot2use

6:15 AM

arun suor sdei (Cambodian)

Comment Converter

1 1

postgresql

@PaulWhite Nice

Paul White

I'm fed up with having low quality CW answers on my profile hence sock

As soon as it gets 10 rep it will be able to CW its own answers

hot2use

Will you eventually delete the OP's comment?

Paul White

Thanks had forgotten :)

ypercubeᵀᴹ

@PaulWhite perhaps a feature request? "Option to disassociate a CW post completely from my profile"?

Paul White

@ypercubeᵀᴹ Yeah. I did think about that a while ago but didn't do it after searching meta. Can't remember why!

It is possible to disassociate posts already but it's a manual process.

Plus I've always wanted a sock.

The site looks very different from a non-mod 10 rep account.

hot2use

6:47 AM

@PaulWhite Must have been a long time ago?

McNets

Morning

Paul White

@hot2use For my main account? Yes. I don't even remember joining, much less what the site looked like when I did.

morning

Andriy M

Morning

hot2use

@PaulWhite Not that much different

web.archive.org/web/20120103095858/http://dba.stackexchange.com

From 2012-01-03

Paul White

I mean the adverts and different menu options

Oh I see yeah right thanks

hot2use

7:10 AM

@PaulWhite Where you SQL Kiwi back then?

web.archive.org/web/20120103142219/http://dba.stackexchange.com/…

must be a fake account. Only 589 points

Paul White

@hot2use yes!

Andriy M

7:27 AM

I think the change to the real name was shortly before the last mod election

hot2use

Is there a collection/list of blogs that anybody could recommend?

Seeing as @JoeObbish started blogging, I was wondering who else does?

@PaulWhite is on SQLPerformance, @sp_BlitzErik is on Brent's site, ....

Andriy M

SQLPerformance also hosts blog posts by other DBA.SE users.

Master Database

12:06 PM

0

Q: How to follow up on answer with updated code?

I have a question about my Database Administrators Stack Exchange post: Using NEXT clause to set periodic materilized view refresh in oracle and verifying refresh If I want to follow up on my answer with my code, and ask about errors, how do I do that? In comments it doesnt allow to enter m...

support

dezso

1:17 PM

@JackDouglas you around?

Joe Obbish

1:37 PM

@Forrest Paul posted an answer to that CCI question that we discussed last week

3

A: Why can it take up to 30 seconds to create a simple CCI rowgroup?

In many respects, this is expected behaviour. Any set of compression routines will have widely ranging performance depending on input data distribution. We expect to trade data loading speed for storage size and runtime querying performance. There is a definite limit to how detailed an answer yo...

Forrest

@JoeObbish Already upvoted :)

Though now I'm even more convinced I need to learn about debuggers. And Windows Performance Analyzer.

ypercubeᵀᴹ

0

Q: How to convert the ,with table_name of sql in to mysql

I am new in mysql and I am migrating my SQL server databae to mysql. I have written the following store procedure and am getting the error: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '...

mysql sql-server-2008-r2

Vote to close as too localized or unclear or tip of the iceberg?

sp_BlitzErik

@Forrest same. heh.

Joe Obbish

remember, it's not as glamorous as it looks!

sp_BlitzErik

pfft

i don't want glamour

i want that sweet black magic

Jack Douglas

2:37 PM

@dezso yes, what's up?

@McNets I have no idea! Do you get an error message when you try to create one? I'm not sure they make much sense in a disposable database

McNets

@JackDouglas Yes, I have no permission. Thank you, but I finally deleted my answer.

Jack Douglas

which DDL trigger out of curiosity?

McNets

Let me try to recover it

@JackDouglas
CREATE TRIGGER [LogTableChanges]
ON ALL SERVER
FOR CREATE_TABLE, DROP_TABLE, ALTER_TABLE
AS
DECLARE @message_body XML
SET @message_body = EVENTDATA()

INSERT INTO test.dbo.MyChangeLog(vcEventType, dtEventTime, vcServerName, vcLoginName
, vcUserName, vcObjectName, vcObjectType, vcSQL)
VALUES (@message_body.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(128)'),
GETUTCDATE(),
@message_body.value('(/EVENT_INSTANCE/ServerName)[1]','varchar(128)'),
@message_body.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(128)'),

Jack Douglas

2:55 PM

can you create DDL triggers just within the current database rather that ON ALL SERVER?

ie use ON DATABASE?

McNets

@JackDouglas No, I tried before, same error

dezso

4:21 PM

@JackDouglas a flag on this: dba.stackexchange.com/a/176447/6219

sp_BlitzErik

@dezso what do you flag that as?

Jack Douglas

thanks, it's gone

dezso

5:00 PM

@sp_BlitzErik NAA-suspect and the copyright issue

sp_BlitzErik

word

we need more flagging options

dezso

@sp_BlitzErik the custom flag seems enough. There you can also post compliments to mods.

Jack Douglas

never had that

bet Paul has :p

@McNets if you tell me exactly which permission I need to add, I'll tweak the script

Joe Obbish

5:17 PM

just did a presentation on stats

think I nailed it, not sure

Forrest

Another Friday presentation for the devs at your company?

Joe Obbish

now that you mention it I did do another one

but I can't remember anything about it

hmm

oh well

this wasn't quite for devs

Forrest

Not in your memory anymore? You must have restarted since then.

@JoeObbish Who was the target audience?

Joe Obbish

5:33 PM

technical folks in customer-facing roles

Forrest

Ooooh, interesting crowd. What did you want them to know about stats?

Joe Obbish

I can pass along a slightly censored version of the slide deck if you like

just need somewhere to put it

Forrest

Would love to look at it

Joe Obbish

although it's not really worthy of the name "slide deck" :)

how to pass it along?

Forrest

Ok with emailing it?

Joe Obbish

5:39 PM

yeah, got the file size down to 500 KB

I'll convert it to binary and put it on dba se fiddle

Forrest

thank you

Joe Obbish

sent

not sure how useful it will be

I don't like putting text on slides

or decorating them

Forrest

Meh, I still like seeing how other people frame topics

Joe Obbish

let me know what you think

Max Vernon

@Forrest personally I really like a nice dark mahogany frame.

Joe Obbish

5:48 PM

I was baking something the other day

was supposed to take it out of the oven when it was the color of maple wood

?????

I even googled it and it was completely unhelpful

Forrest

lol

Max Vernon

not if you're a maple syrup maker, I guess.

Joe Obbish

says the Canadian

Forrest

Google image search of maple wood shows its light color

Joe Obbish

I got a bunch of different colors

Forrest

5:51 PM

I guess you could say a very light tan

Forrest

6:04 PM

Just finished looking over slides. It's obviously tip-of-the-iceberg info on a big topic, but I think your main points stand out well. Assuming your main points are 1. How stats basically work 2. Why they matter 3. People should actually think about what they do

Thanks for passing them over! I enjoyed reading them.

Max Vernon

7:45 PM

@JoeObbish reading stuff like that really doesn't help my imposter syndrome.

Joe Obbish

8:03 PM

Thanks Forrest, glad you enjoyed them

yep, that's pretty much it

@MaxVernon you have lots of great answers and obviously the community thinks so too

for me it's different in that I enjoy the experience

"that's how far I have to go"

sp_BlitzErik

@JoeObbish what were you baking?

Joe Obbish

9:11 PM

@sp_BlitzErik raspberry crumb bars

McNets

9:59 PM

@JackDouglas To create a DDL trigger with server scope (ON ALL SERVER) or a logon trigger requires CONTROL SERVER permission on the server. To create a DDL trigger with database scope (ON DATABASE) requires ALTER ANY DATABASE DDL TRIGGER permission in the current database.

docs.microsoft.com/en-us/sql/t-sql/statements/…

Max Vernon

10:58 PM

@JoeObbish thanks - Paul seriously takes it to another level though, doesn't he?

Transcript for

The Heap™ – Consultancy ©®