Last week I upgraded my windows mobile phone from WM 5.0 to the new (mmm not that new) WM 6.0. I have been searching for the upgrade for quite a long time now. HTC announced free upgrade to all its customers’ couple of months back. But I bought my HTC TyTyn through T mobile (renamed as T-mobile Vario II), so I cannot use the HTC upgrade. I called up the T mobile customer centre couple of time, but they gave all weird answer, once I was told that I have upgrade the phone to get the software upgrade. Then I found out it’s not worth wasting time on educating them about WM, and went to T mobile high street shops, they also had no clue. Finally I managed to find it online in T mobile website.

I couldn’t find my difference between windows mobile 5 and 6, except that they included the must have feature of adding a dialled number (or received phone number) to an existing contact. I still cannot receive contacts sent from Nokia or other phones unless they are outlook contacts L. That’s another must have feature isn’t it, not everyone has WM, and the features should be compatible isn’t it? Hope they will give some option in the next version.

The free upgrade to WM 6.0 for all T-mobile Windows mobile phones can be downloaded from here. You have to give your handset serial number, which can be found if you remove your battery.

-Rujith

Semi Join in SQL server

It’s an interesting fact that we never tend to use semi joins in SQL server, and instead we tend to use the more easy (or rather lazy) way of using an ‘IN’, which obviously takes huge amount of time (again depends !). I was writing a query to search from multiple tables (having millions of records) and don’t have much option of change, and it was taking lot of time (again depends!) to fetch the result set. That’s when I remembered about semi-join, replaced all lazy ‘IN’s with semi joins and I got alteast 40% performance improvement.

Now how to use semi joins

Semi Join

DELETE @AvalableOrgIdList FROM @AvalableOrgIdList AVL

                                    WHERE EXISTS (SELECT  OrgId FROM @TmpSrchResult RSLT WHERE RSLT.OrgId = AVL.OrgId)

Anti Semi join

DELETE @AvalableOrgIdList FROM @AvalableOrgIdList AVL

                                    WHERE NOT EXISTS (SELECT  OrgId FROM @TmpSrchResult RSLT WHERE RSLT.OrgId = AVL.OrgId)

Want more explanation and more in depth into SQL joins etc , check this blog.

http://blogs.msdn.com/craigfr/Default.aspx

-Rujith

After long days of being lazy, I finally managed to bring my blog up and running... This has been kind of dreem project for me, which was running for past few years now... :(, yes I am bit ashamed of myself. And I know this is not the way to put your first blog on ur new blog site, but thats the TRUTH...

Watch out for more stuffs in the space soon.......

-Rujith

Starting .msc files from .net application.

When writing code, lot of times we have come across situation where we want to start event viewer or any other application which uses management console . The code below shows how to start event viewer from .net application. This can be used to start services.msc or any other similar files.

Process traceFileViewerProcess = new Process(); 

string executable = Environment.ExpandEnvironmentVariables(@"%SystemRoot%\system32\eventvwr.msc"); 

traceFileViewerProcess.StartInfo.FileName = executable; 
 

traceFileViewerProcess.StartInfo.Arguments = "/s"; 

traceFileViewerProcess.Start();