The Heap™ – Consultancy ©® - 2016-10-28

« first day (2124 days earlier) ← previous day next day → last day (2731 days later) »

12:40 AM

Anyone else getting "This server could not prove that it is i.stack.imgur.com; its security certificate expired yesterday"? Not sure if it's the wireless at the conference

Also, I have yet to be accosted by a Chilean. I am mightily disappointed

12:58 AM

I lost two unicorns, woe is me!

This is a quick-fix, not a real solution. People shouldn't just be running stuff as administrator. These security walls are in place for a reason. — siride 8 hours ago

3 hours later…

4:06 AM

@JamesLupolt No, but then I haven't looked for any.

1 hour later…

5:14 AM

@billinkc Some other people are, yes. Not me so far.

12

Q: i.stack.imgur.com has an expired SSL certificate

Let me say first off that I'm not sure if this is on-topic. It is the Imgur host made specially for StackExchange, but it's also Imgur who's managing it. I apologize if this isn't topical, but I'm not sure where else to raise this issue. I'm hoping that an SE employee might have some way to fix t...

discussion bug status-completed

And it is fixed.

3 hours later…

8:21 AM

So you copied another answer (dba.stackexchange.com/a/86804/6219) with even not caring to remove the upvote-downvote garbage. — dezso 10 secs ago

8:35 AM

@dezso Many shit answers to that question ;/

I'm voting to close this question as off-topic because is has nothing to do with databases or the administration thereof — Philᵀᴹ 6 secs ago

@Philᵀᴹ How do people even find their way to DBA SE when asking questions like that?

@Philᵀᴹ And asking for a pirated key, noice

8:53 AM

Sorry I posted and later saw it has nothing to do with, probably I made a mistake when choosing the title so please pardon me. — user7083133 2 mins ago

a polite pirate ;)

1

Q: Trying to understand how to create snapshots for account summary table

In this post @jackdouglas gives a solution to the poster's question on how to maintain account balance. http://dba.stackexchange.com/a/5647/109157 I had a few questions in regards to the posted answer: Could someone elaborate on the update or insert? 1) Does that mean: for each month there wi...

sql-server mysql database-design aggregate

@JackDouglas this may interest you ^^^

9:13 AM

@ypercubeᵀᴹ He also commented under Jack's answer 10 hours ago. Jack probably didn't respond and he must be in a hurry...

I don't like the fact that in order to understand that question one must first read and understand not only Jack's answer but also Nick's question, neither of which is likely to take a couple of seconds. And you'll probably have to jump between the new question and the linked thread multiple times in order to follow all the points.

I also don't like that it's got so many questions in one post. So, in addition to jumping back and forth to understand the question, one might also have to jump back and forth while preparing a probably not very concise answer.

It's not ideal

0

Q: Return 2 lines from a table if one line contains a column > 0 and the other is NULL

How to return 2 lines even if one line is null but the other > 0 item_id | location | quantity ------------------------------------- 14 | 1 | 10 14 | 2 | <null> 21 | 1 | <null> 21 | 2 | <null> The result shoul...

Dear lord

(the answers)

This cannot be serious:

-4

A: Return 2 lines from a table if one line contains a column > 0 and the other is NULL

select item_id, location, quantity from [tablename] where item_id=14;

Someone decided to help someone else (or themselves) to a little rep?

I've voted to delete it. Not sure what the score is with deleting accepted answers though

10:10 AM

@Philᵀᴹ Nothing special. The only restriction is that the author of the answer cannot delete it if it is accepted.

7

A: 20k users can vote to delete negatively voted accepted answers

As Michael mentioned, moderators are not restricted from deleting accepted answers... And neither are 20K users. The restriction applies only to the author of the answer itself. A debatable restriction that has nevertheless probably prevented some amount of abuse over the years. (Posting this an...

By design.

10:55 AM

@ypercubeᵀᴹ thanks, I've commented on it but also closed it

don't often do that with upvoted questions but it really isn't a good fit as it stands, as @AndriyM rightly pointed out.

11:44 AM

-1

Q: Having multiple foreign keys on a table

I was asked to reference multiple foreign keys to a table and the message says too many foreign keys on that table,any idea to do so please?

a homework question that hits the limit of foreign keys. Isn't it 255?

Close. 253

@ypercubeᵀᴹ Must be a very diligent student.

@AndriyM his first question, at SO: stackoverflow.com/questions/40296442/…

managed to get -5 and get closed in a few hours

12:03 PM

It's as is they are trolling.

I have done all I need to do except this part — user7083133 11 hours ago

No, you haven't.

12:26 PM

Oh boy. It has an answer now. (the dba question).

Equally good as the question.

Which shouldn't have happened

@ypercubeᵀᴹ I'm sure the OP won't mind as soon as they've got the codez:

Can u pls put down the query for me ? — user7083133 9 mins ago

Put down the query without table definitions, How? — Tom V 21 secs ago

@TomV You forgot to reference the asker.

As indeed had I :)

@AndriyM The asker is notified for all comments.

@ypercubeᵀᴹ On their question, but not on the answers, I think.

12:34 PM

Thnx, I thought they were.

hello guys

14:33
i just wanted to clear something in my head....i'm building a project and i have 3 main things users events (as some big event like a wedding or so) and offers....soo what's boggling me is how to make table connections with these statements
a user has many events
event belongs to user
user has many offers
offer belongs to user

user one to many events

is that ok

@lewis4u Ask a question on the site. Be sure to include what you have tried to model so far

1:11 PM

@lewis4u What Phil said ^^^. And try - before posting - to replace the verbs in your description ("has", "belongs") to more precise ones. (eg "a user creates an event", "a user participates in an event", "an offer is made by a user to another user", etc). It may help you identify relationships better - and help others answer your question.

1:51 PM

1

A: SQL Server - Cardinality Estimate for LIKE operator (Local Variables)

I tested on SQL Server 2014 with the legacy CE and did not get 9% as a cardinality estimate either. I couldn't find anything accurate online so I did some testing and I found a model that fits all of the test cases that I tried, but I can't be sure that it's complete. In the model that I found, ...

0

Q: Error Generating Estimated Execution plan

In reviewing the estimated execution plan creation process, I came across this section in SQL Server Execution plans by Grant Fritchey, He mentions: The optimizer, which is what generates estimated execution plans, doesn't execute T-SQL. It does run the statements through the algebrizer.....

sql-server execution-plan

What's the score with including copyrighted book excerpts? ^^^

@Philᵀᴹ We can ask the author: dba.stackexchange.com/users/6597/grant-fritchey

The question makes little sense anyway

They have probably omitted important details.

@ypercubeᵀᴹ Seems fine to me. Although I don't know the answer, I'm guessing there's a difference in how non-existent temporary tables are treated when generating estimated plans. Perhaps some default assumptions are used.

@ypercubeᵀᴹ I've tweeted him with a link to it

2:06 PM

@Philᵀᴹ he seems scary

It's like when creating stored procedures too. You can create a stored procedure referencing a non-existent #table but not one referencing a non-existent OrdinaryTable.

@AndriyM That's what I thought might be missing. That the code was part of a procedure.

@ypercubeᵀᴹ I don't think so. The issue is reproducible with the code already posted.

I got an error with the first snippet and an estimated plan with the second.

ok, thnx

2:41 PM

when doing a restore to another server as a means to copy a database... the folder structures may not be the same. so it is required to use MOVE as I understand it. this doesn't actually "move" the source DB files, right?

basically i took a full copy_only backup on the source server. i manually copied over that .bak file to the destination server. i then created a blank DB and started a restore using this .bak file on the empty db.

i also did REPLACE and changed to filename to match the empty db's name

@JzInqXc9Dg Restoring a .bak on your destination server will not alter anything on your source server

why?

ConcernedOfTunbridgeWells

Adam Zane Campbell born around 10am this morning. Mother and baby are fine and doing well.

14

@JzInqXc9Dg It's not linked psychically or anything. Not even psychotically

@ConcernedOfTunbridgeWells Awesome!

ConcernedOfTunbridgeWells

Thanks.,

2:55 PM

@Philᵀᴹ LOL

nuke please: dba.stackexchange.com/questions/153611/…

@ConcernedOfTunbridgeWells congrats!!

ConcernedOfTunbridgeWells

Thank you

3:15 PM

@ConcernedOfTunbridgeWells yey!

ConcernedOfTunbridgeWells

Thank you

3:38 PM

Were the names intentionally chosen to start with A and Z? or accidental?

ConcernedOfTunbridgeWells

The names were chosen so that they were easy to pronounce by native speakers of several different languages. Adam is also a reasonably common name in Indonesia.

4:26 PM

@ConcernedOfTunbridgeWells you're filling us with lots of good news lately, eh? :)

well done sir, well done!

@ConcernedOfTunbridgeWells all the health to the lady and the tiny Cotw

ConcernedOfTunbridgeWells

Thank you.

you good?

ConcernedOfTunbridgeWells

Yes.

nice then, hope your house is full with flowers and pampers :)

ConcernedOfTunbridgeWells

@Marian Yes. We have many nappies. She's still at the midwife clinic but will go home soon.

4:31 PM

@ConcernedOfTunbridgeWells normal or ceasar?

I suppose the first from the "midwife"

@ConcernedOfTunbridgeWells great, hope you also have a great couch :P

ConcernedOfTunbridgeWells

@ypercubeᵀᴹ Normal

4:51 PM

Congratulations COTW.

ConcernedOfTunbridgeWells

5:30 PM

Thank you

5:50 PM

COUNT(1) also counts rows. COUNT(*) did something dumb in old SQL Server so don't be surprised to see lots of COUNT(1) in old code. From what it did dumb, I suspect the rule was once count all rows that had at least one non-null column. — Joshua 1 hour ago

@Joshua when you say old SQL Server, what do you mean? Version 6, 7? I haven't seen anything like that but I hadn't used so old versions. I'd be interested to know where/when that happened. — ypercubeᵀᴹ 57 mins ago

I don't know what version had the crazy behavior, but as far as SQL 2005 it was still reading in the table rows to perform the now unused check. SQL 2008 learned to omit the table join from its index in that case. — Joshua 33 mins ago

Anyone cares to throw some light into this? Was SQL Server counting this way in some old version?

6:04 PM

@ypercubeᵀᴹ Maybe there was something in some pre-7 version? Who can remember. I certainly don't have it installed anywhere to check.

@ConcernedOfTunbridgeWells Oh congrats!

ConcernedOfTunbridgeWells

Thanks all.

@PaulWhite But are you aware of any "now unused checks" that COUNT(*) might have been performing in 2005?

@AndriyM No, certainly not. COUNT(1) shows as COUNT(*) in execution plans as far back as I can remember.

@AndriyM ~~Apparently there was something in Oracle 8i~~ NOPE

@PaulWhite I was prepared to learn otherwise, but as it is, I'm not surprised at all.

@AndriyM One of those urban myths I guess.

SQL Server 2000 evidence

Hard to search for really old stuff these days it seems.

6:24 PM

Who was it that has in his profile that worked with version 4.1 ?

We shooudl ask him ;)

@PaulWhite Thanks. So if he remembers correctly, then it must have been a really old version indeed. I'm not arguing with someone that many years my senior.

Dan Guzman, United States

4.4k 1 5 15

sql-server sql sql-server-2008-r2 sql-server-2012 partitioning performance database-design

Yes!

I just realized that my flag might be processed by a different mod. I hope I don't get any bans ;)

@ypercubeᵀᴹ Well, you certainly won't get any buns :)

2

@ypercubeᵀᴹ Done. Moving messages between chat rooms is clunky.

7:05 PM

@ypercubeᵀᴹ Oh and btw dba.stackexchange.com/a/153618

@PaulWhite Nice! I'll have to read this carefully

@ypercubeᵀᴹ I felt a bit heartless given the effort that went into the other answer, but hey.

@PaulWhite is the other answer correct or wrong?

@ypercubeᵀᴹ It's not "correct" though the curve fits the data points, if you see what I mean.

The functions look similar, changing only in the constants

but yours "constants" are really variables

7:17 PM

@ypercubeᵀᴹ Perhaps from a certain point of view, but the other is a curve-fitting equation to a set of empirical data points. Mine is a formula built from the executed code. Note also LOG<> LOG10.

@PaulWhite yes, I assumed that was the case

your LOG is the natural log but that's not a big difference. Their formula could use natural log, too, just changing the external constant.

And the question is how the estimate is derived, not what formula could be used to get close to the final numbers. But hey, perhaps I am splitting hairs. I'm not sure.

The difference is that you base it on the actual code.

At least they have in the start that they found a model that fits their tests, they don't claim it's complete.

@ypercubeᵀᴹ Indeed. Hence no downvote and my struggle to answer your question about whether it is right or wrong. It's sort of both.

It almost makes me feel bad for hitting the reputation roof with a silly, basic answer, when both answers there show serious effort.

7:29 PM

@ypercubeᵀᴹ Rep is weird. I answered one recently with one of my shortest ever that happened to hit HNQ and +16 or something daft.

2 hours later…

9:42 PM

This looks like spam to me:

-1

A: SQL Availability Groups: Can clients use cluster name instead of listener name(s)?

Multiple availability group and listener are now possible in Alwayson AG setup on Azure IaaS https://www.linkedin.com/pulse/multiple-sql-server-availability-group-azure-vms-joffin-mathew?trk=prof-post

But I haven't yet flagged it as I'm not 156% sure.

Thoughts?

« first day (2124 days earlier) ← previous day next day → last day (2731 days later) »

Transcript for

Oct '1628

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