« first day (1354 days earlier)      last day (3513 days later) » 
00:00 - 19:0019:00 - 00:00

7:00 PM
Seriously, every ad is slander.
 
I always wondered about that. Isn't the US famously litigious?
I would have thought the ads would be squeaky clean for that reason.
 
JNK
@PaulWhite yes but not when it comes to "speech"
 
I clearly understand nothing.
 
It is but these politicians have spent all their money on hookers and blow so lawsuits won't get anyone much
4
 
JNK
In the US Money = speech
 
7:01 PM
If I had 10 stars to give...
Oh for goodness' sake!
 
JNK
There ya go
After the NZD::USD exchange and import dues it comes out to 1 star
2
sorry
 
Thanks :)
 
bookmark this: theuselessweb.com
 
blocked
 
blocked
 
7:15 PM
nice
 
@swasheck no AZ
 
WTH? No RI?
 
i'm sure it's just places that have an open crime api or something
oddly enough, i found the site while looking up a florida football recruit
 
7:53 PM
@swasheck I'm surprised how many people are smiling for their mugshots. I guess they just do it reflexively. npr.org/2012/10/22/163410175/…
 
This police attitude is a little too common lately
> We may lose in some civil suit down the road somewhere, but for the moment, we're gonna win, because we run the place
I'm thinking about Ferguson but even more so about that asshole who was texting and ran over the biker and killed him, and is getting off because he's allowed to text on duty
 
The really infuriating thing wrt to the cyclist was his attempt to cover it up first
The whole "professional courtesy" concept drives me mad. PC is where an officer flashes their badge and gets out of minor infractions because they do the same job
 
@billinkc It applies to family members too. A police association sticker on a car is basically a license to speed.
 
@James not for me, nor fire department
In the northeast and in Ontario, at least, you have to be lucky enough to be pulled over by the person that actually recognizes you or your name, the stickers don't mean shit anymore
 
@AaronBertrand Maybe it varies regionally. I know they're often very reluctant to ticket family of police where I've lived in TX. (Not suggesting this is a good idea, btw.)
 
8:09 PM
@James the south plays by its own set of rules
 
Oh I'm sure it does, I'm sure even here there are different cops with different opinions about that.
(I just don't ever happen to come across the ones with favorable opinions.)
 
i am so glad to be away from the south.
 
I'm glad to be in the south... of England
 
Only 628 more signatures needed
 
8:24 PM
@AaronBertrand i see you're as frustrated with goodell as most
espn running the players' tweet responses was awesome
@mmarie are you in denver?
 
@swasheck yes
 
@mmarie cool. can i have your drink tickets?
 
@swasheck can a commissioner be impeached?
He is such a dick
 
@swasheck huh?
oh. speaker dinner?
 
@AaronBertrand such a smug bastard. totally avoided the hard questions - especially the saints/payton question ... the demographic question ... the "external law firm" question
@mmarie :)
 
8:30 PM
So I suggested to this guy that he look at my split strings post so he can see why he shouldn't be doing this in a multi-statement TVF with a while loop. TVPs are out because it's crystal reports not C#, ok. But he can't use any of my other functions because he doesn't have time to understand them. I thought that was kind of ironic, so:
You mean like how you understand the function you're using now and can debug it when needed? Posting the function on Stack Overflow and saying "why isn't this working" is not exactly what I would call debugging something you understand. — Aaron Bertrand 6 mins ago
(I deleted my comments that posted links to the articles I thought might benefit him.)
 
Nope. I've in Denver for 18 hours and have yet to consume a beer. This must be remedied tonight
 
@swasheck yeah "ignorance is not an excuse" unless you're me then it's ok
 
360° stupidity today
@mmarie psh. slacker
@aaron this is my favorite tweet, so far
What Roger just said is the exact same thing that players say when they make a mistake and plead their case
@AaronBertrand this was also a delicious soundbyte
> Well, Rachel, let me say the same thing but slower.
nice. patronizing Rachel Nichols. the misogyny goes straight to the top
 
@swasheck Are you going to SQL Saturday tomorrow?
 
@James not only am i going ...
nvm
yes. i'm going
 
8:38 PM
@swasheck Oh I forgot. You're presenting about maintaining stats?
 
Can't talk, new phone is here
 
@James yep
@AaronBertrand dont drop it
@James why do you ask?
@RLF what's up?
 
@swasheck Just curious. I'm in Dublin for the one there right now and noticed that there is one in Denver at the same time.
 
nice
 
RLF
Just dropped in to see what is going on.
 
8:44 PM
cool. not much.
 
RLF
I was about to bow back out when I saw your "what's up".
And, if fact, I must do so since I have a little more work to do.
 
@swasheck Well good luck with your presentation. It seems like a worthwhile topic and you have a good timeslot, so I expect it will be well-attended.
 
@James well thanks. this is the one with which i'm most comfortable so i'm pretty interested to see how it goes
 
9:09 PM
@swasheck I thought you were good last time I saw you speak. So I'm sure you will do well with a comfortable topic
 
@mmarie thanks. that was my first time evar
 
Many never even get up to speak so even if you think, "oh my god, I suck. I'm losing them. They know more than me" you've got a bigger set of stones just for getting up there
At least, that's what I tell myself
 
sure. i'm not concerned about my stones. i'm more concerned with being helpful :)
 
@billinkc How's it going with stubborn teenager? Is he relishing his quality time with you? :-P
Oooh, I got a new error message in OneNote. It says my OneNote that syncs to SharePointOnline ran out of room so it can't sync.
 
9:31 PM
@mmarie No idea. He's at home, probably sulking. I am back at the client
 
@billinkc Oh. I assumed you were home watching them. Who takes care of the little one?
 
Joys of being an older brother
And having a television
 
heh
grrrr... SSDT doesn't play well with running VS as a user on another network. It won't open my script from my SSIS script task.
 
They have VPN here but as I have not been instructed in the ways, I assume that's nothing they're interested in me doing.
 
Am I the only person that ever has to do that? I'm constantly going to client sites and using batch files to run Excel, Visual Studio, and SSMS as a user on the client's network. And it's clunky at best.
 
9:37 PM
runas is the bomb, yo
That, or it set us up the bomb
 
@billinkc Says the guy who used to get locked out of his account at the last client site :-)
 
nice
 
@mmarie That was before I figured out the shenanigans involved. Like if I even think I mistyped my password, kill it and start over. Or SSMS is going to make at least 3 attempts when I connect so 1 connect = locked out
The one thing I wish I had figured out was how to automate the entry of my password
I saw assorted posts on using sendkeys and what not but could never get it to work
 
 
1 hour later…
10:52 PM
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. — Colin 't Hart 2 days ago
Alright. Which mod declined my obsolete flag on that ^^^
It was a comment to an answer that was converted to a comment.
It now appears on the question, which makes no sense at all.
 
@PaulWhite not me, but I just flagged it :)
 
Thanks!
 
11:42 PM
@PaulWhite whoops, I dismissed it (had no idea who flagged it) and here's why - when I clicked the link in the flag UI, it took me to that comment on the answer:
So I thought maybe the flag was put in before the answer was deleted and, well, caching
This kind of thing will happen from time to time :-)
 
Is this suggestion good?
0
A: Tsql Query speed slow due to Or within where clause, causing index scan instead of seek

Pieter GeerkensLearn to push evaluations out of the interpreter and into the compiled code like this: SELECT ID, PERSON_ID, ISNULL(ITEM_VERSION, 1) AS ITEM_VERSION, ISNULL(ITEM_SUB_NAME, '') AS 'ITEM_SUB_NAME', ISNULL(ITEM_SUB_SUB_NAME, '') AS 'ITEM_SUB_SUB_NAME', ISNULL(ITEM_DATE,...

 
mmmm... I don't think so. Using OR, or ISNULL, or COALESCE there will all result in the same problem.
That guy is often confused
e.g.
@Pieter interesting suggestion, given this answer. In what scenario do you expect TOP 1 ... ORDER BY to outperform MIN? — Aaron Bertrand yesterday
In one answer he says that you should replace TOP 1 with MIN, in another he suggests you should replace MIN with TOP 1, and in neither case does he explain why he thinks one is better than the other
What evidence do you have that ISNULL/NULLIF will be more efficient here than the OR conditional that exists, or COALESCE, etc.? Do you really think ISNULL handles this better? Why? What is this "compiled code" you are talking about? — Aaron Bertrand ♦ 10 secs ago
 
00:00 - 19:0019:00 - 00:00

« first day (1354 days earlier)      last day (3513 days later) »