I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

January 2009 Blog Posts

The day Google “died” and I used Live search for an hour

On Saturday 31st January 2009 at around 14:40 UTC something “historical” happened. Google virtually stopped working. It might as well died. Every single search result was marked with “This site may harm your computer.”. And it redirected you to a warning page. Of course this was probably because of some bug in their harmful content detection software or a failed upgrade or something similar. I doubt it was a virus. It doesn’t really matter why but for an hour I was forced to use Live search. Yahoo was just too much typing in the address bar. :) ...

posted @ Saturday, January 31, 2009 5:40 PM | Feedback (6) |

The simplest way to delete duplicates and compare two result sets in SQL Server

Comparing result sets There are times, although not often that you have to compare 2 result sets. This usually happens when you're analyzing data for whatever reason or unit testing a database. Usual methods include - using the UNION of both queries because it filters duplicate data and checking if the row counts are the same - using the EXCEPT if you have SQL Server 2005+ - using NOT EXISTS which is very ugly and not worth it - using a FULL OUTER JOIN and looking at nulls or some other method I haven't mentioned - returning result sets to client and comparing...

posted @ Monday, January 05, 2009 2:50 PM | Feedback (7) | Filed Under [ SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET