The Heap™ – Consultancy ©®

« first day (1831 days earlier) ← previous day next day → last day (3030 days later) »

Paul White

12:00 AM

Really?

Max Vernon

wow dude. you're just a serial voter. ;-)

Paul White

I do vote a lot.

Max Vernon

I ran into that a few times a long time ago, but never recently. what is the limit?

ahhh, 30, +10 times on questions only

seems like that limit should be higher for highly trusted users.

Paul White

12:17 AM

@MaxVernon I think so too, but apparently the consensus is otherwise.

Max Vernon

I was just searching meta.se but I cannot find a good question about it.

Paul White

A: Increase Edit Votes for 10k+ Users

We already increased the # of suggested edit votes from 30 to 40 (on Stack Overflow only) but I don't want to go any higher. The point of the limit is to get vote diversity; the same 2 or 3 people approving all suggested edits is insufficiently distributed.

Max Vernon

lots of close-vote questions, etc.

Paul White

-8

Q: Increase vote limit for moderators

Being an active moderator on SharePoint.SE I find myself stuck with the limit of 30 votes a day. When I'm active I can spend hours on the site trying to make it more useful and interesting, which for one thing is to show appreciation by voting. On our site there are a lot of fly-byes who come in...

etc.

Oh sorry that first one is about edit votes.

Max Vernon

interesting how everything gets looked at through the Stack Overflow looking glass. I'm fairly certain that community is very different from many other StackExchange communities.

Max Vernon

12:35 AM

hmmm -25°C tonight

wish it was +25 lol

EBrown

@MaxVernon Oh god. I hate that crap.

Max Vernon

@EBrown no doubt.

that's the actual temperature. with the windchill they are saying it feels like -34°C

its a bit brisk

EBrown

A bit?

That's horrendously cold.

Paul White

1:07 AM

@MaxVernon Weight of numbers, no doubt. Also, some problems are only problems under very high usage.

Max Vernon

@PaulWhite exactly. I could see wanting to prevent many of the 20k+ users on Stack Overflow from voting too much.

just because you have 150k rep on Stack Overflow doesn't necessarily mean you're brilliant.

Paul White

@MaxVernon The user changed the name of the table in this question

Max Vernon

1:22 AM

@PaulWhite cheers

Paul White

1:57 AM

@MaxVernon I could edit your TS15 answer if you like.

Max Vernon

either way. You likely have a far more sane answer than I could provide!

I'm just trying to learn while I sit here waiting. thanks for pointing out the details.

I made a slight change to my answer, @PaulWhite - I don't have any idea if that makes it sane or not. It seems to me the plan has no sort now, although I don't have the table partitioned.

Paul White

That looks good - so long as he can change the query, and only ever searches for whole 15 minute periods (likely, but we don't know).

Max Vernon

@PaulWhite yah, it's hard to say what his real requirements are.

thanks again for the heads up. I hate looking stupid. :-)

Paul White

Team effort.

He could always add covering TS15 conditions as extra predicates (calculated from the parameters) and include [Timestamp] in the index if the parameters aren't always full dates or aligned on 15-minute boundaries.

@MaxVernon I would also mention that adding the (non-persisted) computed column is an instant metadata-only operation.

And perhaps give him the ALTER TABLE syntax.

Max Vernon

2:14 AM

@PaulWhite true dat. good point.

Paul White

Ha. He tagged it 2014 but it was 2008. No biggie though.

Gee it's hard to ask a question isn't it? ;)

Finally remembered to up vote.

Max Vernon

@PaulWhite it's surprising how much faster that query is with the correct index.

well, not surprising. but still fun.

@PaulWhite dammit.

Hi @Max, I already thought about this. But I want a solution where I can flexible change the interval. 10, 15 o6 minute for example. Sorry I made it more clear in my question. — Steffen Mangold 31 secs ago

Paul White

Four forks ache.

Max Vernon

No more Inverter questions for me!

Paul White

That's just wasted an hour between us I'd reckon.

Max Vernon

2:25 AM

yup

Paul White

We should bill him.

Max Vernon

and not mates rates either!

Paul White

Nope.

Max Vernon

still, I learned some stuff. thanks very much!

I suppose I should leave the answer there so no one else goes there?

Paul White

Yes it's still useful.

Max Vernon

2:28 AM

cool. I'm off home - catch you soon!

Paul White

@MaxVernon Ok, I made a minor edit about locks and persistence. Also, if he has a small number of possible intervals, the answer could still be the answer, just with multiple columns and indexes.

1 hour later…

Max Vernon

3:44 AM

Thanks, @PaulWhite those modifications are very welcome. I knew table lock didn't sound right. I never think of schema because of the other sense of the word.

8 hours later…

Michael Green

11:32 AM

@MaxVernon The week before Christmas was quite warm here. We had an overnight low of +26C then.

4 hours later…

Aaron Bertrand

3:18 PM

I'm not sure I understand "can't afford" - are you answering questions in every single tag? Surely there are tags and entire tag families you ignore? Given our question volume in comparison to, say, SO, I'm not sure how this is a problem. I also don't understand what negative effect it has whether a question about a specific SQL Server script is tagged with the name of the script or not. The question is still going to exist, the tag there doesn't have any downside to me, but there is tremendous upside to Brent and to others with the same or similar questions about the script. — Aaron Bertrand ♦ 6 mins ago

@swasheck I have seen this once or twice. Would need an actual example to help troubleshoot, there's no magic "don't make it do this" button. :-)

4 hours later…

YperSillyCubeᵀᴹ

7:02 PM

I mean I didnt actually directly code anything, just clicked here and there? — Jerry West 19 secs ago

I want to slap my head sometimes, reading these replies.

and some great adivce:

Then try again (clicking here and there.) But click only on the 2 HID columns. Not in the RoomNum column. Oh, you already have, nice ;) — YperSillyCubeᵀᴹ 53 secs ago

I figured it out! — Jerry West 1 min ago

And of course, it was cross-posted: stackoverflow.com/questions/34696912/…

Tom V

8:12 PM

@YperSillyCubeᵀᴹ at least he figured it out

"in the diagrame place"

Lucas

9:07 PM

having troubles with pg_basebackup from a slave on PostgreSQL 9.2...

is here the right place to ask for some useful help? Working on this problem for 20h =\
http://dba.stackexchange.com/questions/125709/recovery-from-live-to-a-new-slave-server-postgresql-error#comment231865_125709

2 hours later…

dezso

10:57 PM

I don't know if this actually solved the problem -- the company that I was working with went bankrupt shortly after this answer was submitted. But it's the only one with upvotes, so it gets the check. — jcollum 3 hours ago

^^ never underestimate the significance of database problems

« first day (1831 days earlier) ← previous day next day → last day (3030 days later) »

all rooms