The Heap™ – Consultancy ©® - 2014-09-24 (page 2 of 2)

« first day (1359 days earlier) ← previous day next day → last day (3503 days later) »

6:00 PM

erm ... what? estimated rows 2218. actual rows. 0

WHERE
CASE
WHEN DATEPART(DAY,FDFundingDate) > DATEPART(DAY,pl.Userdate)
THEN DATEDIFF(MONTH,FDFundingDate,pl.Userdate) - 1
ELSE DATEDIFF(MONTH,FDFundingDate,pl.Userdate)
END < 37

??

@PaulWhite Am not. Well, the OUTPUT is valid, just they need to be inserting the stuff elsewhere. Fiddle incoming

Or not

gist.github.com/anonymous/78c9724d6e8cdb3397eb

@billinkc Not you, the guy that posted an answer. Composable DML is very limited in SQL Server.

@Zane They are fuckt tables.

His "answer" basically shows where an OUTPUT clause would go, if the syntax were valid, which it is not. Lazy-ass answer I down-voted and closed the tab.

6:05 PM

@PaulWhite @AaronBertrand dont think i've ever seen a plan with so many rows estimated, yet actual rows were 0

@swasheck What plan are you talking about?

this feels off-topic for SO.. migrate to Database Administrators ?

Hey Kermit, this question is asking for help with a strategy on the search for the right database. It is not asking for specific recommendations. For example, what key terms should I be searching for? Are there classes of databases that fit this use case to a greater or lesser degree? I am familiar with the term "low-latency" but I'm not sure what term applies to a database that is delete tolerant. — Chris Dutrow 22 mins ago

@PaulWhite drive.google.com/file/d/0BzWvqYLYojJeVDhNeVQyOGhjWEE/…

@PaulWhite related to this question:

1

Q: SQL Server: High Logical Reads for Worktable

I have a very complex logic SQL Query which has many case statement. It is running very slow. It has 7 Left Join tables. Updated Execution Plan Link Below Statistics of sample query. what could be the possible reason for high worktable logical read? It takes a lot of time to execute. Neithe...

sql-server sql query-performance

"Sorry, you can't view or download this file at this time.

Too many users have viewed or downloaded this file recently. Please try accessing the file again later. If the file you are trying to access is particularly large or is shared with many people, it may take up to 24 hours to be able to view or download the file. If you still can't access a file after 24 hours, contact your domain administrator."

Never seen that from Google Drive before.

@PaulWhite it's a 45mb plan

dropbox.com/s/ydgucnbxbe0m9jr/Execution_plan.xml?dl=0

6:09 PM

@swasheck Downloaded, thanks.

Join all the tables!

RID lookups galore

That isn't a question, it's a consultancy gig. Long term.

@billinkc now can you wrap that in a cross apply?

@swasheck No.

@PaulWhite i know. i was wanting him to give it a run and report back on his findings

6:16 PM

@swasheck Ah ok.

@PaulWhite so tip of the iceberg?

Totally.

@PaulWhite Nor I, weird

@AaronBertrand Must be part of the new "more beautiful interface" work :-/

Beautiful, but doesn't work. :)

@swasheck Oh, well I learned something. 2 somethings actually. The first was that in the nested construct, I can't just pull back the INSERTED table and then it still won't work with a JOIN or APPLY

6:22 PM

@PaulWhite so anyway ... is that common with a bunch of left joins? estimate is high-ish but 0 actual rows?

@billinkc (me too)

Eep, I don't even know where to start with this one - and not just because the query is so large the showplan XML can't contain the whole thing. Why do you have so many heaps? Kesjer scared you away from clustered indexes? — Aaron Bertrand ♦ 32 secs ago

poking the bear, eh?

@swasheck I've closed the plan now. Estimate quality quickly degrades through many joins, left or otherwise. He has bigger problems though.

Meh, whatever. He's an idiot for making his case so strongly that some people will actually think that heaps are always better than clustered indexes.

@PaulWhite ok thanks. it makes sense that it would degrade

6:26 PM

Why do people think anything can be a MySQL replication slave?

0

A: MySQL Slave has unmanagbly higher IO load than master

Munin's formula for "device utilization" is (milliseconds spent doing I/O)/second, which assumes you can't do any I/O in parallel, so I'm not sure that this is a meaningful metric. However, you do clearly have a genuine performance issue here since replication can't stay caught up. Is there a si...

@AaronBertrand yeah. "look at the monster you've made"

@James Because people.

Indexes don't help all that much if they're not covering. Did you know I counted 55 RID Lookup operations? I'm really not surprised it is slow but this is a whole slew of underlying schema problems that can't be solved here. — Aaron Bertrand ♦ 47 secs ago

VtC as dupe of his question from yesterday?

Instead of duplicating your last question, you should simply edit the original with this new attempt. Here is your original question: dba.stackexchange.com/questions/77398/… — Max Vernon 1 min ago

@PaulWhite I was thinking 7 joins (5040 possible join orders I think) probably isn't too many for the optimizer to consider, but I guess the bigger issue is estimates degrade due to hidden/unknown (to the optimizer) correlations?

6:32 PM

@max Yeah, that's what I did - maybe would have been slightly more kind to go the other way, but shrug

@AaronBertrand yeah, I'm thinking it makes no difference in this case. :-)

@Lamak planning on applying? :)

@James Are you talking about the 45MB plan? Many more than 7 joins there.

Yeah he described 7 left joins in the question but either he was conveniently leaving out a bunch of inner/right/cross joins or these are joins to views that themselves contain a boatload of joins.

@James it's just 7 outer joins (or so he said)

6:35 PM

@PaulWhite @AaronBertrand @swasheck Oh, duh. I see now. Well that's only like eleventy billion possible join orders to consider then.

@James that's a low estimate

@James 5040 is only the possible orders. Multiply by the ways that a join can be done (merge join, etc.) If every join has 3 options. that 3^7. Now we have 5040*2187 = 11022480

@ypercube Good point, hadn't thought of that

@AmritpalSingh Sorry, but it's just too big and there are far too many problems to make a useful Q & A here. You need a consultant, not an answer. — Aaron Bertrand ♦ 12 secs ago

@bluefeet planning on considering about it

6:40 PM

@Lamak :D

but first I wanted to clarify some issues so I don't waste everyone's time

@ypercube dumb question ... how do you determine that it's 3^7 instead of 7^3

You tried to kill the process? sigh That wasn't a spreadsheet you were trying to recover. Best of luck. Call Microsoft support. — Aaron Bertrand 31 secs ago

@swasheck if we have 2 joins, it's 3*3.

@ypercube dur. thanks.

6:44 PM

@AaronBertrand Well it does at least sound like they were working on a local copy of the database. Or their production database is on the developer machine, but...I don't even want to think about that. :P

@AaronBertrand I was going to tell him to have some patience, and wait for SQL Server to run recovery; but then I thought "clearly this guy has no patience".

@MaxVernon can't hurt - maybe tell him to wait more than an hour this time.

@AaronBertrand yeah, I guess he could use the DAC to connect to check status, too.

Ugh this alienware guy - two closed questions here and I think this is his second on SO. All the same. This one M.Ali answered

0

Q: I'm trying to make a stored procedure to verify a input integer

I'm trying to make a stored procedure to verify a input INT have maxim 15 digits and the first digit is not 0. And now I have this: CREATE PROCEDURE usp_verify_phone_numbers (@phone_number INT) AS IF @phone_number > 15 BEGIN PRINT 'Not ok' END ELSE PRINT 'OK' DECLARE @...

sql sql-server tsql stored-procedures

@swasheck But that's a high estimate. Because not all orders are valid. Anyway, for 7 joins it might be feasible. For 10+, I doubt it.

6:49 PM

@ypercube sure - but i was stumped at the basic theory, so thanks :)

Hey didn't aptem change his username to yuck? Did he change it again?

Yuck, Beverly Hills, CA

7.3k 106 337 606

sql c# sql-server vba vb.net sql-server-2008 ms-access

ah, still yuck

Weird, he must not show up here because he has negative rep this week???

Does this answer make sense?

1

A: SQL Server will not respond, even after restart

When you restart SQL Server, it will run the "recovery" process on all databases configured to load at startup. You need to wait for recovery to complete; at which point the rows will likely still be in the database. A word of advice, wait for SQL Server to do it's thing; NEVER kill the sqlse...

6:56 PM

user image

it appears to be the first one there?

Gotta love immediate upvote-and-accept. Some people just don't get the point of "Accept", do they?

@Lamak oh maybe, I was somehow expecting rep to match and badges to show.

Another insomnia-induced brain fart

@AaronBertrand yeah, I think that rep is the week rep

yep makes sense (now)

6:59 PM

you want to re-flag him as a favorite user?

@AaronBertrand Not really. It's weird that badges show up only when in the "all" tab but not in the others (week, etc.)

I stopped using that thing, because it wasn't smart enough to use userid. I favorited a Joe then half of SO was lit up in red.

@AaronBertrand ah, yeah, sounds very limited

@AaronBertrand baby induced insomnia?

@bluefeet 2-year old, mostly

She was better last night but still a royal PITA

So, I'm lost. The table definition for PurchaseReturn already has a foreign key constraint to PurchaseOrder set to cascade. Are you trying to add another one? Why? Are you trying to change it? It seems to be named incorrectly (it has VEN in the name). Drop it before you try to fix it or add different constraints that will currently point to the same table... — Aaron Bertrand 1 min ago

7:10 PM

@AaronBertrand makes me glad I have 4-legged kids

even though they can be PITA when they are puppies

@bluefeet my dogs are 7 and 8 and they are more a PITA now than when they were puppies

I don't understand people

@AaronBertrand Those cases will be very rare, if not zero, in this dataset. Having said that, I would like to be able to handle .net and .info if possible. — zgall1 36 secs ago

So it's not important, but give me a solution for it

@AaronBertrand I've got 3 dogs - 13, 7, and 2 - they can for sure be pains. But they are kenneled at night. little dogs have the tendency to be incredibly active in the wee hours

Dude, read your own freaking question!

@AaronBertrand, first foreign key is created on Column 'VendorId'. But I want to add another FK on column 'PurchaseorderId' that is refrenced to Purchaseorder(purchaseOrderId) — Khan 1 min ago

I'm done, SO idiot:not-idiot ratio is just getting way too high for me

So the PASS election thing seems to be going smoothly.

LOL PASS is having a Roger Goodell week

7:18 PM

Isn't it.

It's not quite as bad but it's certainly similar in a lot of respects.

Our name change? Let me spell it out, but slower

Some users are experiencing difficulties with voting. PASS IT is currently looking into it & we'll have an update ASAP. #sqlpass #passvotes

Tweeted by sqlpass on September 24, 2014 at 7:15 PM

Probably hosted on an azure ssd

Ha!

7:28 PM

It's actually Access

I mean, why not? They still use Excel for session selection

but wur profeshunals

Do I want Shane Vereen or do I hold out that Darren Sproles might play up to potential this week?

We're professionals, but the guys at PASS HQ are most definitely not. I believe they're just IT generalist guys doing web design stuff.

Yeah pretty much. I actually don't know of any SQL Server person on staff.

(That doesn't mean nobody on staff can spell SQL Server, but...)

To be fair, voting online is a whole new concept. PASS are breaking new ground here so it's no wonder there are teething troubles. Ahem.

7:32 PM

bwahahaha

@AaronBertrand I pulled Vareen he hasn't done anything for me. I took a chance on him a few weeks in a row.

They could save themselves a lot of embarrassment by just hiring SurveyMonkey or someone to facilitate this.

Exactly.

OMG

> Due to poor regular expression support in SQL Server, these situations are unavoidable. You update those records manually.

Also he's playing with an injury this week.

7:34 PM

1

A: Update column in SQL Server to delete all text after a specific delimiter

UPDATE MyTable SET website = LEFT(website, CHARINDEX('.com',website)+4) Note that this won't work if you have anything other than .com in the first domain name. Edit: A comment mentions it won't work with domain names that has .com in the middle like www.COMputers.com or www.COMmander.com. ...

Manually, like what, in Edit Top 200 Rows?

(I know, I was supposed to log off, got the stupid ping from my comment on the question.)

Do an UPDATE for each, replace the .com with .net, .org, etc. SQL Server has very poor Regex support so you can't do it in a single statement. This filtering best happens at the application logic level, before it enters SQL Server. — Zoff Dino 34 secs ago

@AaronBertrand And he misunderstood my "won't work". I should have said "it will fuck up your data".

@MikeFal how does one become an "eligible voter"

That is just absurd - how are you going to get the list of PK values to put in all of those manual update statements? How are you going to fill in the ...? Again, you are suggesting that you manually and visually inspect every row. Absurd. — Aaron Bertrand 1 min ago

@swasheck Register on the website, I believe

7:39 PM

Yeah you had to have updated your profile before June 1 IIRC

@AaronBertrand which profile? :)

(I guess it took them 4 months to extract the data into a voters table)

wait. whoops.

@swasheck all 17 of them

Really miffed that I had misunderstood that to eligble to vote in the BoD election I was *required to update my PASS profile #passvotes 1/2

Tweeted by Neil_Hambly on September 24, 2014 at 12:26 PM

I had nothing to update @ the time, so didn't and this means I'm not able to VOTE and that is IMHO just stupid *end of rant #passvotes 2/2

Tweeted by Neil_Hambly on September 24, 2014 at 12:27 PM

I wonder how many people had that happen

7:41 PM

@mmarie yeah. me too.

Well I got a link to vote but it didn't work. Maybe I'll face the same problem when it actually lands me in the right place.

One way to control an election, I guess

Huh, that would explain why I have no link

I was too lazy to update my other N accounts so I only get one vote this year

eventually consistent. but i'm not miffed. based on brent o and bobby seahawks' comments on tom's post, it's like any other election. you vote for someone who's not going to do anything that they said they were going to do in the first place

What is ROAR?

@AaronBertrand manually mean ROAR: UPDATE SET website = ... WHERE PK = ... — Zoff Dino 5 mins ago

7:42 PM

a katy perry song?

Did he mean RBAR?

@AaronBertrand RBAR?

@swasheck Wendy P sung that at karaoke.

@AaronBertrand What a tiger says.

Brent is on a roll this week

So how about instead of building a BA conference, we take care of our existing members well? #passvotes #sqlpass #fixthesite

Tweeted by BrentO on September 24, 2014 at 7:35 PM

7:44 PM

@MikeFal she was so cool. we'd never met. i insulted her by asking her where she was from but after that, she talked to me like we'd been friends forever. she still never got my name (which i'm sure she's better off)

@ZoffDino Roar! I'm an update! — Zane 13 secs ago

@swasheck Wendy is awesome and one of the most friendly people you'll ever meet.

@AaronBertrand yeah he is

@AaronBertrand Yeah, well they keep serving him softballs

@AaronBertrand it's safe to say that no one is going to accuse him of being a patsy for Microsoft or PASS.

7:45 PM

@swasheck Why is that an insult?

He's pissing a lot of people off but he hasn't said a single thing I disagree with (and more importantly it's making them listen)

@Zane that's for sure

Well sometimes people need to be pissed off

And yeah he's not being unreasonable

@AaronBertrand what i think is funny is how much the board seems to want to cater to the rockstars (ahem) ... and one of the biggest personalities in the cult is turning it back on them

@AaronBertrand That's kind of my thought. Brent grandstands a lot, but he usually says stuff that I agree with. I may not agree with his approach, but he has an effect.

7:46 PM

@AaronBertrand It did seem like he purposefully misconstrued Chris Webb's comments to be more dramatic, but other than that I can't say that I disagree.

I loved Jorge last night saying that instead of blogging/tweeting about these issues he should have a one-on-one conversation with the board. sigh

@MikeFal really enjoyed sitting next to her. her personality put me at ease just before my presentation

@ypercube dunno. i asked and she looked at me like i lived under a rock

@mmarie exaggeration to make a point? Meh, I'm ok with that. I wouldn't be doing it in his style but it bolsters his point.

@AaronBertrand @mmarie hyperbole

@swasheck people in Chicago assume everyone knows they live in Chicago

7:47 PM

twitter.com/schmarsten/status/514730841441067010/photo/1

@AaronBertrand Nothing gets change going faster than keeping things to yourself.

Well, not only that, but (a) how do you get the whole board on the phone? (b) do we all need to do that?

"The main limitation of PASS BAC is that it's a Microsoft-centric conference on data analysis. That's like having a World Cup with only the U.S., Canada, and Belize."

@James that actually wasn't even Brent's quote.

we just start our own ... U-ASS ... Unprofessionall Association Sql Server

2

@AaronBertrand like a midnight cowboy. also, i have no mvp or any accolades or recognition to lose ;) ... just my dignity and @billinkc has already taken most of that from me

7:49 PM

@AaronBertrand Nope, just something he linked to. I thought it was funny (and pretty accurate).

I can only stand tall if I kneecap those about me

rise above it, or cut others down to below your level

@MikeFal If she told you something different, I'd love to hear the alternate story.

(I'm going to clean up this conversation shortly just so all are aware.)

ohhhhhhhhhhh

The Seaward?

7:53 PM

@AaronBertrand according to former literary-scholar/cu president, betsy hoffman it used to be a term of endearment

@AaronBertrand I don't think it's all that different. Sounds like the central point was the same.

@MikeFal so what was different?

user image

Are you sure she didn't lose it by have such a butt ugly website?

@AaronBertrand Let's switch to a private room, I'm not trying to spread around other folks laundry.

7:55 PM

@Zane that was only criteria for a couple of seasons

Vote now button is showing

So do I vote, or have I already voted?

I finally got to use SQL sentry today at work. It was horrifying.

Never mind I'm an idiot

Your voting URL pass.simplyvoting.com/…

I do wonder what the mac value decodes to.

8:01 PM

user image

That's a little big there Seth...

@Zane TWSS?

I had a feeling a dong joke would follow that.

"wow ... now there's a mouthful"

@AaronBertrand I swear I read that as #fixtheSHite .. staying all day long next to a Brit doesn't do good to my vocabulary :)

8:06 PM

(ornithologist)

There aren't any dim keys in this fact table at all...

Then you don't have a fact, do ya?

Oh nevermind.

I see this is their query to load the fact table.

They're all clever keys

> Nobody could ever find out what a particular voter has voted as the results are stored anonymously.

yet

Nobody could ever find out what a particular voter has voted as the results are stored anonymously.

Voting Receipt - PASS Board of Directors Election 2014
Receipt code: T342
PASS Board of Directors Election:	Kang; Kodos

8:19 PM

@Zane search your feelings. you know it's true.

Whoa

Time for some afternoon delight....

Tweeted by wendy_dance on September 24, 2014 at 7:27 PM

@AaronBertrand and that's the person for whom i voted

@wendy_dance you do know what that normally refers to right?

Tweeted by mrdenny on September 24, 2014 at 8:16 PM in reply to wendy_dance

@billinkc yeah I don't buy that either.

Turkish delight

Turkish delight or lokum (Turkish: Türk lokumu) is a family of confections based on a gel of starch and sugar. Premium varieties consist largely of chopped dates, pistachios, and hazelnuts or walnuts bound by the gel; traditional varieties are mostly gel, generally flavored with rosewater, mastic, Bergamot orange, or lemon. The confection is often packaged and eaten in small cubes dusted with icing sugar, copra, or powdered cream of tartar, to prevent clinging. Other common flavors include cinnamon and mint. In the production process, soapwort may be used as an emulsifying additive. == History... ==

@billinkc ... is not particularly delightful

8:20 PM

yeah that stuff is nasty

No, it's gawdawful stuff

Glad we are all in agreement. That, aero and ... some other English sweet were things that I'd rather gargle with a beehive than ever put in my mouth again

@billinkc I voted for Kang and Kodos too, but my receipt code was different.

Oh Aero is awesome but maybe the Brits do it differently than Canada

Crunchie, that's was the worst of the lot

Crunchie is a brand of English chocolate bar with a honeycomb toffee sugar centre. It is made by Cadbury and was originally launched by J. S. Fry & Sons in 1929. Fry had merged with Cadbury in 1919 and Crunchie later became a Cadbury bar. A similar chocolate bar called the Violet Crumble competes in Australia manufactured by Nestlé. == Size and variations == The Crunchie is sold in several sizes, ranging from "snack size" – a small rectangle – through to "king size". The most common portion is a single-serve bar, about 1 inch wide by about 7 inches long, and about 3/4 of an inch deep. In the late...

Yeah like biting into a crusty sponge

8:27 PM

Flake isn't much better

Haven't tried it on ice cream where it's supposed to be good but by itself, I'd rather lick asphalt

@swasheck Have you tried it?

@ypercube many times

Penguin or a Lion bar, now that's nomz

Quite partial to a:

Wispa is a brand of chocolate bar manufactured by Cadbury UK. The bar was launched in 1981 as a trial version in North East England and with its success it was introduced nationally in 1983. It was seen as a competitor to Rowntree's Aero (now owned by Nestlé). In 2003, as part of a relaunch of the Cadbury Dairy Milk brand, the Wispa brand was discontinued and the product relaunched as "Dairy Milk Bubbly". As part of the relaunch, the product was reshaped as a standard moulded bar (similar to other 'Dairy Milk' products) instead of a whole-bar count-line. However, in 2007, helped by an internet...

@ypercube i wouldnt categorize it as "godawful" or "nasty" ... but it's never failed to disappoint me

8:32 PM

@PaulWhite Those too but I didn't want to induce a diabetic coma

> Dairy Milk Bubbly

hmmmmmm ... not sure what to make of that

Your mind is clearly still in Afternoon Delight country.

So that's why he's been sending me those snapchats

@PaulWhite more like "yeah. lot's of people get the bubblies when drinking dairy milk"

@swasheck I have literally no idea what you're talking about now.

8:35 PM

@PaulWhite allow me to explicate: milk allergies

gas.

diarrhea

Gotcha. All of those words I recognise.

"the runs"

Incorrect syntax near the keyword 'bubblies'.

actually there'd be a parse error at "lot's"

i've got all kinds of typos today. too much work from home

8:49 PM

So where's this vote button?

user image

sqlpass.org/MyPASS.aspx

YEah, I don't have it

have you receive the email directing you to vote?

Nope

DEN YOU CAINT VOTES

8:54 PM

@MikeFal DM @sqlpass. They'll let you know if it's something they can fix or you're just not eligible to vote.

Can't DM, Twitter says I look like spam

I suspect he's just in a later tier of communication

Wait, there it goes.

Well, I hadn't update my profile

But didn't think that was important.

@MikeFal probably because you included a URL. Twitter is stupid.

Post all the spam URLs you want to thousands of followers. Dare to send a URL to one single person who lets you DM them because they trust you? Hell noes.

@AaronBertrand Yeah, I took all the symbols out of my account name

8:58 PM

m1k3.f@7?

I've been asked to help with an indexing strategy for this Fact Table load.

However the volume is 34 Million rows. That's probably more of your problem.

@AaronBertrand Not quite. :)

It always strikes me as weird when an SSIS answer gets upvotes. 3 today on this question (not begging for more)

18

A: Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

With all due respect to Kishore's answer, that approach is valid if you're modifying the packages. Since you're using the import/export wizard, the more straight forward approach would be to check the Enable Identity Insert box on the Column Mappings tab. In the Import Export Wizard, after selec...

@Zane truncate

Do people really run into this often enough? I mean, it's got to be hitting plenty of people for it to be one of my higher rated answers but it seems so basic

9:07 PM

Heh, even Paul Randal has the voting problem.

@sqlpass Why wouldn't I be eligible if I've been in PASS for years?

Tweeted by PaulRandal on September 24, 2014 at 9:07 PM in reply to sqlpass

I expect he's going to hit the Neil Hambly issue. Getting the popcorn ready

Yeah, that's what I hit

prolly. PASS may as well have renamed themselves the NFL this week.

at least they aren't in the business of manufacturing phones (yet)

I'll be honest, I'm of two minds of voting. With all the stuff around the name change, I wonder if my vote will even make a difference in how I want PASS to develop

9:12 PM

@sqlpass That's retarded. So if I didn't see your blog post or get any emails, I don't get a vote?

Tweeted by PaulRandal on September 24, 2014 at 9:11 PM in reply to sqlpass

LOL]

Oops.

@billinkc do tell, please

sqlpass.org/Community/PASSBlog/tabid/1476/entryid/582/…

Regarding English candy, I recommend Uncle Joe's Mint Balls

user image

@swasheck He didn't update his profile. Neither did I. Wasn't aware that this was necessary, even though I log into my account frequently.

9:14 PM

They're pure, good, and keep you all aglow.

Crikey. That's a real thing?

@PaulRandal Perhaps you’d be interested in a lightly used BA Conference ticket.

Tweeted by BrentO on September 24, 2014 at 9:15 PM in reply to PaulRandal

Snigger.

@PaulWhite Yes. Though i don't think they make them in the can anymore.

I think the problem is that they think people use their sqlpass accounts

@James Make them in the can?!

One would hope not. Especially for American consumers.

That and that more than 1% of the user base actually cares about all the little turf wars and fiefdoms

9:17 PM

Pretty vocal 1% though...

@PaulWhite Erm, sell them in the can. OK I guess that doesn't sound better...

@MikeFal A big banner every time you log in saying "You haven't updated your profile! ZOMG DO YOU NOT WANT TO VOTEZ!?!?!" would probably have helped.

Ok, break out the popcorn.

@sqlpass I'm confused by this. I don't get a message so I don't get to vote? But you're happy that I come and present at PASS, and at 1/2

Tweeted by PaulRandal on September 24, 2014 at 9:17 PM

Or by virtue of actually logging in maybe that indicates the account is active

@AaronBertrand Even so, I log into my account 4-5 times a month for Denver stuff.

9:18 PM

@billinkc Radical idea.

@billinkc CRAAAAAAZY

@MikeFal I know. I'm saying (a) it's stupid that an active update was required and (b) that they didn't make that requirement more prominent to you on your profile page.

We showed those people with duplicate accounts that vote fraud will not be tolerated by disenfranchising all the other people

Having dropped the meaning of SS in PASS, it seems the P is next.

As I just said on twitter, this is PASS-backwards

9:21 PM

Ha ha

I like it

@SQL_Kiwi what do you mean dropped the SQL Server?

Tweeted by PaulRandal on September 24, 2014 at 9:22 PM in reply to SQL_Kiwi

Oh snap

@billinkc It's like God woke up and said "They did what to my son?"

Isn't it Professional Association for SQL-Server?

There will now be a short, but intense, period of non-public communication.

9:28 PM

We shall rename today to "@PaulRandal catches up with @sqlpass" :)

Tweeted by DBArgenis on September 24, 2014 at 9:23 PM

@ypercube sqlpass.org/Community/PASSBlog/tabid/1476/entryid/647/…

I'm still holding off on how I've spent ~$10000 of my own money over the past 3 years to attend the summit and don't get to vote.

I'm sure they will fix it. They have to.

They never seem to entirely think these things through.

partially would fit there too.

It's like Yosemite Sam shooting from the hip, every time

Ready! Fire! Aim!

2

9:34 PM

Ha, yes.

I need to go bake salmon, ciao folks, and @MikeFal I hope you ultimately get to vote. Until you do, keep pouring it on.

Ohhhh, I hates that rabbit

Keep seeing answers like this from 1-rep users:

0

A: How to repair, or drop/create a corrupted table in mysql?

Check with these options: - Username and password information in your wp-config.php file is incorrect. Please check with PHPMyAdmin and correct it or reset it. Also make necessary changes in wp-config.php file. - Make sure that you have typed correct host name in wp-config.php file. - Your hostin...

Tempted to flag as spam. Justified?

Yes

The final link has featured in spam posts on this site before.

9:39 PM

Look at all their other answers

all the same spammy answer. Release the hounds

Hounds released.

brent's really firing away now

@PaulRandal @anotarian Agreed - none of us have higher priority. Unless of course we’re on the Board. ;-)

Tweeted by BrentO on September 24, 2014 at 9:18 PM in reply to PaulRandal

If they do drop the 'P' we'll all be members of ASS.

@swasheck I'm fully behind him right now.

@Paul sorry jumping back in for a minute - do you have a PASS Summit speaker contract handy?

9:50 PM

Have the lightning speaker from 2012 in my first gmail hit

But the BI makes all the work for you

@AaronBertrand Searched. Did not find.

true.

@sqlpass this is not cool - @KimberlyLTripp doesn't have a vote either. Can you fix this please?

Tweeted by PaulRandal on September 24, 2014 at 9:52 PM

someone needs to make a mongo joke ... then we can call it a day

@MikeFal what was the comment about Hambly to mean?

@MikeFal cccccccombo breaker

@swasheck Scroll up, but he tweeted about not getting to vote because he didn't update his profile.

9:58 PM

yeah ... i just dont know what bill meant ... but if that's what he meant then ok

50 mins ago, by billinkc

I expect he's going to hit the Neil Hambly issue. Getting the popcorn ready

Any issues with #passvotes Please email governance@sqlpass.org #sqlpass

Tweeted by wendy_dance on September 24, 2014 at 9:55 PM

Does that mean shut up and stop discussing this in public?

@PaulWhite I'm not. I'm going to continue talking about it until I get a good answer.

could be. attempting to squelch civil disobedience should be really fun to watch

Wendy has been DMing with me, she's talking with the board. It's sounding like they're taking the line "if you're not validated, you can't vote"

That ought to go down well.

10:03 PM

The Professional Association for MongoDB would never treat people this way.

4

Yeah, especially if the likes of Randall and Tripp are left out.

PASS --- Professional Association of SQL Skills|SQL Sentry ;) i like the ring of that

Nice

PABST Professional Association of Brent's SQL Team

2

Context

1 hour later…

11:09 PM

@PaulWhite thanks, I found

sqlpass.org/summit/2014/Speakers/CallforSpeakers/…

@AaronBertrand Curious. That page says I have successfully signed the Speaker Contract. Not speaking this year of course. Ha.

@PaulWhite I don't think it's tied to your login context.

Probably why you can't get to it from the nav

11:57 PM

wow, I missed a lot. There are far too many removed items in this transcript

« first day (1359 days earlier) ← previous day next day → last day (3503 days later) »

Transcript for

Sep '1424

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