Michael J Swart

@Lamak As long as you can handle the sparkling vampires. (I'm sorry, I'll stop now)

@Lamak Go at Twilight then?

@ypercubeᵀᴹ Isn't this a joke? How could humanity live on the Sun? You just have to go there at night.

@AndriyM No it's super rare. I try not to touch prod sites if I can help it.

@AndriyM I get that sinking feeling all the time. When something goes down moments after I touched it. I get worried that I did something. Luckily, it's not my site :-)

Right, the question's first revision:

So that's the average score for posts whose initial titles contain "mssql" vs "sqlserver"

how do we post an image here?

@AndriyM Mostly I wonder about the actual quality of the question asked by people who use either term. I'm not too curious about whether the term influences voting. So in fact if the term was corrected, it measures a little more accurately the quality of the question.

It would also be interesting to do the same query against stackoverflow as well as dba.se

Right :-) First things first.

Question about the term "MSSQL" vs. "SQL Server". To me the term MSSQL is used by rookies, or people who don't work much with the product. It would be an interesting study to measure average vote count (up or down) on questions that initially used "MSSQL" vs questions that initially used "SQL Server"

OT: Does anyone know why there's a math.stackexchange.com and a mathoverflow.net? They both seem to be stackexchange communities, but I can't tell what the difference is or why we need both?

This is fun... What game are we playing?

grasshoppers

This question (and accepted answer) hurt my eyes. I don't know where to start. stackoverflow.com/questions/8602395/…

If job requirements include a lot of specific stuff like that, chances are that the job doesn't have a lot of autonomy and that's a red flag.

But having said that, I'd half expect a recruiter to say "nope, we're still looking for a shrinkfile guru". Then that's a nope

@KrisGruttemeyer This means some practice at managing up. Getting people to state their intent: (i.e. "efficient storage administration" rather than "shrinkfile knowledge")

@KrisGruttemeyer Every now and then I like to look at these descriptions and think to myself "I could totally clean that place up. So many easy wins".

I would take Mmm Mmm Mmm Mmm over the Humpty Dance any time.

Columns with table aliases. I'm 100% on that bandwagon.

*schemas

prefixing table identifiers with prefixes probably

hey

what?

Counterexample: Rob Ford

I never minded Wesley or Riker

@ypercube There's a TNG episode featuring Lwaxana Troi and Worf's kid Alexander. Ugh! Everyone is allowed to skip that one.

@billinkc @billinkc I knew there was a joke in there somewhere. Glad you found it.

ಠ_ಠ

My first question was "what kind of restaurants?"

anyone see the latest #sqlhelp question? a screen shot for some mysql insert?

@ypercube The MySQL docs totally do describe how to use the WHERE condition. It's an expression. It points directly to the expression page dev.mysql.com/doc/refman/5.6/en/expressions.html which includes the IN clause he was curious about. I'm surprised he missed it, or like Aaron suggested, because lazy

I was teasing here :-)

@swasheck :-)

I believe you just called my stuff common :-)

query hashes are super useful

@swasheck I made use of hashes in my top 20 resource hogs: michaeljswart.com/go/top20

@MaxVernon They can be reused if the plan is the same. But aside from that I think the plan handle is based on some sort of hash function. I've always counted on a plan handle uniquely identifying a plan and I've never had trouble.

@Lamak Any kid (like yours truly) who played lightsabers with sticks as a kid got to realize the need for a lightsaber cross guard to avoid "ha ha I just sliced off your hand". My question would be why don't all other lightsabers have crossguards. My guess when I was a kid is that when lightsabers clash, they're sticky and can't slide over eachother.

Just a few non-Americans

Wow, tumbleweeds around here.

@Lamak He helped by agreeing with you. "Lamak is correct on all accounts." You can't object to that :-)

@billinkc Hey Bill, I've managed an answer. Thanks for your help

Okay, thanks guys (over and out)

Okay, I see. we adjust these precendent constraints as an expression rather than success/completion/failure