The Heap™ – Consultancy ©®

McNets

6:49 AM

morning

Andriy M

7:06 AM

morning

Philᵀᴹ

7:57 AM

Heh, 166mpg

McNets

Nice car

Paul White

8:45 AM

Morning

Tom V

I made the correct decision by going to pinal's session

Pure comedy

2

Marian

@TomV details please :)

Tom V

On mobile so it's hard to type a lot of stories

Andriy M

Is there a video recording, perhaps?

Tom V

"I don't like people who say it depends. It's something scared people use to hide"

4

"just run it in production. You won't see performance problems in Dev anyway so how else will you know if it helps"

7

Marian

9:01 AM

oh my :D

@Philᵀᴹ nice car, I've a 335i (E93)

the consumption though.. is on the opposite end :D

Tom V

"don't think too much I will give you a script" -- my favourite so far

5

Andriy M

The first two seem to me consistent with each other. Both are about not being scared.

Don't be a chicken. Don't say "It depends" and don't be afraid to run things in production.

dezso

@AndriyM haha, I am currently planning a talk about the exact opposite (aka the Database Destroyer) - the very first question to the public planned has only one good answer and it's 'it depends'

Philᵀᴹ

9:29 AM

@Marian Nice

ypercubeᵀᴹ

9:49 AM

@dezso It might be funny to have 10 questions in the end - all with the same answer ;)

Momo Tontang

10:11 AM

In DBMS, does entity refer to a row? Because one row contains all the attributes of a specific object. So is a table an entity type as it is the set of all the entities that have the same attributes?

Marian

10:34 AM

@TomV wut? yeah, who needs to think

@Philᵀᴹ a bit old, but really spectacular when full throttle :) me loves it

dezso

@Marian our perception of old seems rather different :D

Marian

@dezso why? :D

how old's yours?

dezso

@Marian I don't own a BMW, haha

otherwise, it used to be 15 years old until it stopped cooperating

and that car was not so old according to me

a BMW 507, that's old

Marian

ha, I see :)

was thinking that compared to Phil's, which is a new breed of electricals, mine is an old style gas guzzler

@dezso that's gorgeous

dezso

@Marian one thing I like in Berlin (well, Germany in general) that you have the chance of running into random classic cars here and there

(and, in reality, a BMW NN02 is also old)

Tom V

12:10 PM

@Marian he's just catering to an audience. Avoiding technical details a few trying to keep the explanation simple

I'm sure there's a big market for that

ypercubeᵀᴹ

@TomV apparently, as the attendance in his presentations shows ;)

Tom V

I just want his autograph for Paul

3

dezso

1:12 PM

@ypercubeᵀᴹ good catch on that UPDATE

and they are lazy to read the docs

Joe Obbish

@TomV What's the overall event?

Tom V

Techorama

My manager thought I should attend but I didn't find an interesting session today

techorama.be

Joe Obbish

today is full day sessions?

"This session will be a demo heavy session with a pop quiz at every hour to keep attendees attentive"

Make us proud!

Paul White

1:37 PM

@TomV Shush

McNets

In which DB are DDL triggers 'ON ALL SERVER' created?

Andriy M

@McNets SQL Server?

sp_BlitzErik

None, they're a server level object

McNets

@AndriyM YES

sp_BlitzErik

Server Objects > Triggers in SSMS

Andriy M

1:42 PM

Was that a quiz? :)

McNets

2

Q: Trigger to change Database collation on creation

I'm trying to create a Trigger, to alter collation of a database on its creation, but how can I catch the database name to use inside the trigger? USE master GO CREATE TRIGGER trg_DDL_ChangeCOllationDatabase ON ALL SERVER FOR CREATE_DATABASE AS declare @databasename varchar(200) set @databasenam...

sql-server-2008-r2

sp_BlitzErik

question related: dba.stackexchange.com/questions/174219/…

bluefeet

morning heapers

Andriy M

morning

McNets

I remembered read something about EVENTDATA, but @sp_BlitzErik has shot first.

morning

Joe Obbish

1:46 PM

I'm glad it's not a "it depends" answer

can't trust people who say things like that

you really can't make this stuff up

Andriy M

@McNets I misunderstood the question, sorry. Read that as "What DBMS...", so I answered with "SQL Server".

sp_BlitzErik

hahaha, i only had it that quickly because i have db level functions to prevent my from creating blitz* procs in user databases

er triggers rather

McNets

@AndriyM no worries

Lamak

@bluefeet morning

McNets

Basically I learnt that to DROP a DDL trigger created with ON ALL SERVER you must use the same syntax. DROP TRIGGER <trigger_name> ON ALL SERVER;

sp_BlitzErik

1:59 PM

yeah, otherwise (guessing) it gets looked for in the context of whatever database you're in

McNets

@sp_BlitzErik thank you

Tom V

Ooh he saved de best Joke for the end

sp_BlitzErik

was it about crossfit?

Tom V

"I show my customer his list of slow queries but I can't tune them I don't know their business logic'

sp_BlitzErik

iktf

Andriy M

2:16 PM

@TomV Wait, are you in his session right now? That is, still in his session? I thought you were talking about a past experience (yesterday or something).

Tom V

@AndriyM yes I'm still here

I had to force myself to sit it out but I'm still here

@JoeObbish I won a prize!

5

I can't figure out how to upload a picture but it's one of his books

Forrest

2:32 PM

@TomV You can get it autographed! Preferably with a quote. "To Paul..."

Tom V

@Forrest I was about to try but he was surrounded by people asking questions and I chickened out

Sorry @Lamak but you already knew I was a failure, right?

Lamak

@TomV what?

no, I mean...not yet

Tom V

I failed to get Paul's present

Lamak

@TomV oh no

Joe Obbish

2:51 PM

@TomV A literal gold star for you!

ypercubeᵀᴹ

@TomV did you get your prize?

Tom V

Yeah a Joe's to pros book.

For SQL 2012

sp_BlitzErik

-_-

ypercubeᵀᴹ

@TomV ok then. You can still find him in the hall. I mean the event is not finished yet, is it?

Tom V

No I left. Confused people were asking questions

I guess I can carry it around the next 2 days

But I don't think I'll attend another of his sessions

Tom V

6:19 PM

0

Q: Help me tune the long-running query

I have a problem with the following query executing from the application: DECLARE @p1 INT; SET @p1 = NULL; DECLARE @p2 INT; SET @p2 = 0; DECLARE @p5 INT; SET @p5 = 2 + 4096; DECLARE @p6 INT; SET @p6 = 8193; DECLARE @p7 INT; SET @p7 = 0; EXEC sp_cursorprepexec @p1 OUTPUT, @p2 OUTPUT, ...

sql-server sql sql-server-2008-r2 performance

The query keeps running for almost 3 hours

Tom V

6:54 PM

Hi @MDCCL Haven't seen you in a while

MDCCL

@TomV I've been quite busy lately, but I've been upvoting a few good posts here and there some times. How are you?

Tom V

@MDCCL Have been quite busy too, have been a lot less active on the site since a few months, but I'm fine otherwise

BradC

This user has edited the post to include the underlying platform, I've nominated to reopen:

-2

Q: Accidentally removed privileges from root user and can't access database

New to databases and accidently removed privileges from root user; only privileges I currently have are USAGE and PROXY. This is a MySQL database that I access through HeidiSQL. Currenty cannot access my data tables; is there a way to get these privileges restored? Did not create any other user a...

mysql permissions

(Was originally closed because they specified only the "HeidiSQL" interface, and not the underlying RDBMS)

Tom V

@MDCCL I was thinking about you this afternoon when I saw the question you answered bumped to the homepage, another very good answer btw

22

A: Why the term "relation(al)"?

First of all, I highly recommend the paper in which Dr. Edgar Frank Codd published the definition of the relational framework in 1970, i.e., “A Relational Model of Data for Large Shared Data Banks” (a milestone in computer science). There, in section entitled 1.1 Introduction, it is stated that:...

2

MDCCL

@TomV Thank you very much. The question was very interesting and quite well contextualized, so I wanted to share my perspective and provide links to some relevant resources. It's good to know you are fine :)

sp_BlitzErik

10:59 PM

is anyone here going to pass this year?

Joe Obbish

11:23 PM

@sp_BlitzErik I am

sp_BlitzErik

@JoeObbish cool! was thinking

that it might be fun to get dba.se people together for drinks

Joe Obbish

I'm not a social butterfly but I'm not against the idea of meeting up

I did run into a guy from here at sql saturday in chicago by accident