Twitter Weekly Updates for 2010-02-28

By pcurd

• I really want NHibernate support in TweetSharp – so I'm going to build it in – should be easy, just an interface I think. #
• Worst part of Sunday – moving the alarm back 2 hours and knowing I might actually happen to get up when it goes off. #
• Actually worst part of this Sunday is being on the last episode in the season of Criminal Minds and knowing it might be a two parter. #
• RT @PatParslow: Any clever Ruby ppl out there?Gem loads in console, but not found when mongrel starts (feed_tools) what's wrong? @fringley #
• RT @fringley: http://twitpic.com/14wwau – The face of someone whos colleague won't make the tea (@looseend) <- #world #039;s smallest violin# #
• After @chris_alexander's Steel Panther suggestion I'm now onto Motley Crue.. is this good? You decide. #
• RT @MariaLKanellis Words for the day, "I am a wolf in sheep's clothing. Kind and fluffy on the outside. Mean and hungry on the inside." #
• On Her Majesty's Secret Service : System.ServiceProcess.ServiceBase #FilmsAboutSoftware #
• The List<List<T>>
  Or The System.Drawing.Drawing2D.Matrix #FilmsAboutSoftware #
• I have a really bad twinge in my lower back today, off to both sides but not in the middle. Any stretching advice to clear it? #
• RT @emmaguy: @plip really tempted to do a: RT @Plip: I am having a WANK #chineseretweet <- #epic #
• RT @amykate: @pcurd I like this one of you, and the previous one http://flic.kr/p/7Fspmk <- It's a good picture Thank you! #
• RT @talldavek: @PCurd: Not quite the same software movie title but: http://www.snorgtees.com/snakesonaplane-p-1036.html <- That's AWESOME! #
• RT @amykate: Evil Amy is Evil http://flic.kr/p/7Fwk9j <- this is Amy trying to "GRRRRRAWR" #
• RT @virginmedia: NEWS:: Virgin Media to launch flagship 100Mb broadband – http://bit.ly/8YZnEt .AA <- I wants it nao #
• Yay my @NovatechLtd pen arrived Thank you! http://twitpic.com/158r8z #
• Just wrote my first CTE and it's like coding in access all over again #
• Awesome, @giraffetweet on @vouchercloud http://bit.ly/bnbjYj #
• Mmm late night coding feels good. But ask me how it feels in the morning #
• I just got a tweet from a random user in Ghana asking for help with a Windows 7 key… I can be famouz? #
• Just found out that a friend from college died last week – he was 26. RIP Jon. #
• RT @blowdart: @chris_alexander OK then, what's with the miami vice profile pic. Blazer and t-shirt? But with a bowl haircut too? <- #haha #
• Could @Choosy_Cat help me choose between a cup of tea or a mug of coffee? in reply to Choosy_Cat #
• RT @Choosy_Cat: @PCurd Mug of tea. <- That wasn't one of the options! You're getting too big for your furry boots! #
• Peeps of #rdg – we need to convince #TheForster to come out tonight. Go! @TheForster #
• I just found a select * in production SQL ! Time to play slap a dev. #
• RT @craigyd: How's this for a NUS card pic? http://tweetphoto.com/12578147 Yes/No? <- That's just freaky! #
• Odd – historical me used select top 100 percent a lot.. I wonder why #
• Still at work – terminal server down, licensing server acting up and the team needs me. Le sigh. #
• Just got home after the longest half day I've ever worked. Annoying thing is I doubt I'll even get paid for it. missed out on pizza too! #
• In an effort to reset my sleep patterns ahead of a week of early starts beginning in 5 days, I have stayed up all night. Now – what to do? #
• RT @wilw: @BrentSpiner She said you'd think that song was about you. <- well that proves it, it must be true! #
• Debating breakfast. Carluccio's… @giraffetweet … Not so fun on my own though. #
• Morning coffee! (@ Starbucks – Butter Market) http://4sq.com/88DRu5 #
• I'm at Giraffe Reading w/ @amykate. http://4sq.com/5OfoyL #

Powered by Twitter Tools

Twitter Weekly Updates for 2010-02-21

By pcurd

• My car failed the MOT badly so I think it's time to retire the old girl and get a new one. Anyone know any being sold? #
• #RATM #fail I can't even get @seetickets website up – this is 2010 – never heard of cloud computing?!? Plus it's a stupid lottery. #
• I got #RATM tickets after 1 hour, 45 minutes @seetickets #fail #
• Anyone trying to get #RATM tickets try this link – it bypasses the first "click on what ticket type you want" http://bit.ly/9nCUS6 #
• New Photoblog: My new finger mouse http://photos.pcurd.co.uk/index.php/2010/02/17/my-new-finger-mouse/ #
• RT @PCurd: @PatParslow it takes some practice but you can do it if you hold your hand just right <- #TWSS #
• RT @NovatechLtd: still giving away window stickers… just got another 100, so if you want one DM us!! <- I got one! #
• Who was it that told me that the female Holly was dead – she's not! Neither is Norman Lovett! #
• Just spoke to @NovatechLtd corporate, sound like a nice bunch of people. #noIwasn #039;tpaidforthistweet #
• I just used an emoticon in an email to the FD – let's see if I'm still employed tomorrow \O/ #
• HUZZAH! Just received the confirmation of my #RATM ticket! #
• FD made a joke back! I think I'm safe! #
• For pre #rdgtweetup food! (@ Burger King) http://4sq.com/cYHkXn #
• RT @deepwire: @PCurd We're watching you! <- my paranoia is right, they ARE after me #
• Today @exceptioneer let me be notified about, diagnose and fix a SQL permissions problem from one email. Very pleased! #
• RT @craigyd: @timmorgan LOL brilliant bluewaffle.net definition of foulness there <- that's one for the scrapbook! #nsfw #
• One of the more technical users here has picked up a virus and it's a nasty one. #
• RT @gazimoff: Go to http://panopticlick.eff.org/ and see why Google don't need to track you via cookies any more (via @Maxicom )<-I'm unique #
• RT @NovatechLtd: @PCurd okay okay…. we will send you one ) <- \O/ #
• Agravated with Reading Buses – the stupid new timetable on the number 9 means I have an hour wait for a bus after work and the bus driver #
• Of the number 6 saw me running for the bus and just drove past the stop. And he was 2 minutes early. Now have stood in the cold for 55 mins. #
• RT @Choosy_Cat: @PCurd Coosy cat points his face at a White Russian. Damn honky. <- Choosy Cat has spoken http://twitpic.com/147g5d #
• I really should play Dragon Age Origins today but loafing watching a film is so much more loafing. #
• I'm so pretentious that even my rubbish is in John Lewis carrier bags http://twitpic.com/14dpv1 #

Powered by Twitter Tools

Twitter Weekly Updates for 2010-02-14

By pcurd

• RT @RdgGeek: Another talk lined up for tomorrow nights #rdggeek night. Luke Smith will be demoing Linq2JS http://is.gd/7VGKg <- awesome #
• I have #epic #cakefail today. May have to get cake and take lunch today. #
• I woke up at 7:15. I'm still in bed at 9:50. #gettingupfail #
• why is there an advert for "colonic irrigation" on my blog?! Is it because my subline includes the words "inner rumblings"?! #
• To paraphrase Douglas Adams "I love Todo lists, I like the whooshing noise they make as they fly past" #
• Freebie on boffer and megadeals on bigoffers, http://tinyurl.com/ycueq9t http://tinyurl.com/ydjdxoj #
• #uksnow RG40 4/10 but not settling – going more sideways than down #
• Word of the day: Saxomophone #
• RT @jackschofield: 10 Fake Simpsons Words that Belong in the Dictionary http://bit.ly/a9HJsX #
• RT @StarCraft: #StarCraft2 beta will be released later this month! #SCUpdate <- squeeeee! #
• What does Twitter think – buy Unreal Tournament from @gogcom, Steam or Impulse.. @timmorgan @nicktelford @jamesbmarshall #
• RT @cyberdoguk: We're all in shock after finding out that Alexander McQueen was found dead today. <- tragic #
• Somehow I managed to buy the wrong RAM for my netbook – my history shows 20 sites visited for prices and only one is wrong. Stupid me. #
• RT @amykate: @PCurd btw the new profile puc looks great cute AND representituve xxx <- taken by the talented @RobAshton #
• Right, bedtime for me pre worktime. Here's hoping for a shorter day tomorrow! #

Powered by Twitter Tools

Twitter Weekly Updates for 2010-02-14

By pcurd

• RT @RdgGeek: Another talk lined up for tomorrow nights #rdggeek night. Luke Smith will be demoing Linq2JS http://is.gd/7VGKg <- awesome #
• I have #epic #cakefail today. May have to get cake and take lunch today. #
• I woke up at 7:15. I'm still in bed at 9:50. #gettingupfail #
• why is there an advert for "colonic irrigation" on my blog?! Is it because my subline includes the words "inner rumblings"?! #
• To paraphrase Douglas Adams "I love Todo lists, I like the whooshing noise they make as they fly past" #
• Freebie on boffer and megadeals on bigoffers, http://tinyurl.com/ycueq9t http://tinyurl.com/ydjdxoj #
• #uksnow RG40 4/10 but not settling – going more sideways than down #
• Word of the day: Saxomophone #
• RT @jackschofield: 10 Fake Simpsons Words that Belong in the Dictionary http://bit.ly/a9HJsX #
• RT @StarCraft: #StarCraft2 beta will be released later this month! #SCUpdate <- squeeeee! #
• What does Twitter think – buy Unreal Tournament from @gogcom, Steam or Impulse.. @timmorgan @nicktelford @jamesbmarshall #
• RT @cyberdoguk: We're all in shock after finding out that Alexander McQueen was found dead today. <- tragic #
• Somehow I managed to buy the wrong RAM for my netbook – my history shows 20 sites visited for prices and only one is wrong. Stupid me. #
• RT @amykate: @PCurd btw the new profile puc looks great cute AND representituve xxx <- taken by the talented @RobAshton #
• Right, bedtime for me pre worktime. Here's hoping for a shorter day tomorrow! #

Powered by Twitter Tools

Using IN on concatenated keys in Microsoft SQL Server 2008 is very slow

By pcurd

During the migration of T-SQL code from Microsoft SQL Server 2000 to Microsoft SQL Server 2008 I found a few procedures that were running very slow. They all used the IN keyword to filter records based on the content of a concatenated key (i.e. a key using two or more fields added to each other).

I have written a quick script to test the performance of three different ways to do this (IN, EXISTS and LEFT JOIN) and the difference is staggering.

Using IN on a concatenated key for this test is in the order of 200 times slower.

The basic summary is that the technique:

select * from #performancetesttable tt
where
tt.field1 + tt.field2 not in (select tt2.field1 + tt2.field2 from #performancetesttable2 tt2)

is much much slower on Microsoft SQL Server 2008 than:

select * from #performancetesttable tt
left join #performancetesttable2 tt2 on tt.field1 + tt.field2 = tt2.field1 + tt2.field2
where tt2.field1 is null

even though in Microsoft SQL Server 2000 the performance is about the same.

The hardware difference on the two machines is greatly in the Microsoft SQL Server 2008 favour – being a dual six core machine with 32GB RAM as opposed to dual dual core machine with 4GB of RAM (only 2GB used by Microsoft SQL Server 2000)

Using IN – Microsoft SQL Server 2008 takes 20250 ms.
Using IN – Microsoft SQL Server 2000 takes 106 ms.

Using EXISTS – Microsoft SQL Server 2008 takes 103 ms.
Using EXISTS – Microsoft SQL Server 2000 takes 46 ms.

Using LEFT JOIN – Microsoft SQL Server 2008 takes 23 ms.
Using LEFT JOIN – Microsoft SQL Server 2000 takes 33 ms.

Read more for the SQL script to test this for yourself

Twitter Weekly Updates for 2010-02-07

By pcurd

• I thank the health gods that they gave me an OK weekend – Thurs/Friday I felt bad and today I have a cold. I can live with that. **cough** #
• For pre #rdgtweetup food, feel free to join me! (@ Burger King) http://4sq.com/cYHkXn #
• I haven't been this happy to see Friday since.. At least last week. I wonder if I can crunch through my todo list today. #
• Listening to an album on Spotify that I bought and have on my laptop… purchase #fail ? #
• Syncing my iPhone.. wish me luck! #
• RT @fringley: "I'm a complete moron" #chineseretweet #
• Somehow the passenger side wing mirror has been ripped off my car I can't find it either #
• Now @TheForster is trying to kill me. He made me run for the bus! I think I left my lungs behind. #
• RT @chris_alexander: @PCurd people are short <- true dat #

Powered by Twitter Tools