February 2010 Blog Posts

My Firefox Tab Scope Add-On Wish List

Tab Scope is a very handy Firefox add-on that shows a pop-up preview of a tab's contents when hovering over a non-selected tab...oh, a picture probably will say it better: The developers have clearly put a huge amount of work into Tab Scope over the years and have largely got it right, and in addition to a preview image, there's a couple of controls like back, forward, refresh in the pop-up itself. After using Tab Scope version 0.3 with the fx4 theme for a couple of weeks, there's a few things on my wish list, however: Left-clicking on the actual preview image...

SQL Error: Cannot resolve collation conflict for DISTINCT operation

I'd never run into this one before and am not likely to again, but the fix is pretty simple and worth posting for my own reference (and I hope it helps anyone googling for it too). The problem occurs in SQL Server 2005 or SQL Server 2008 when you try and select a DISTINCT range of values from a sub-query that uses a UNION or UNION ALL to union two columns with different collations. The problem may occur if the collations are set differently at a database level while unioning two tables from different databases, and also at the column level...

«February»
SunMonTueWedThuFriSat
31123456
78910111213
14151617181920
21222324252627
28123456
78910111213