SQL Server word-level bigram function

I work for an online auction website, Trade Me, and as such collect quite a large quantity of search data (i.e. full text searches that people perform).  Over the years I’ve been involved in various aspects of our search; from tweaking the nuts and bolts of the full-text search itself …

Tech Ed done, bring on PASS Summit!

I’m feeling somewhat human again after having caught up on some sleep back at home after 4 days in Auckland at Tech Ed New Zealand. Thanks again to those who came to our session (DBI207 – Trade Me: 0-70 million pages in 0.34 Gigaseconds) – and specially to those who …

Getting ready for Tech Ed New Zealand

Tech·Ed NZ kicks off the day after tomorrow at the Auckland SkyCity convention centre.  I’ve been to a few in the past, so nothing new there – but what makes this year different is that myself and a colleague will be presenting a session: DBI207 – Trade Me: 0-70 million …

T-SQL Tuesday #21 – Temporarily permanent hacks

This month’s T-SQL Tuesday Wednesday is hosted by Adam Machanic (blog|twitter) – who in fact started the T-SQL Tuesday concept himself back in 2009 (read more about the genesis here). This month’s it’s about “crap code”. We’ve all seen it, and we’ve all written our fair share of it.  I’m not going …

Multiple CTE gotcha

This is probably one of those things you’ll read and think “What a dumbass, I’d never make that mistake!” – which is fine, but I thought I’d post about it nevertheless since it managed to trip me up twice in the space of a week. I’ve got a script which …

Benchmarking I/O: The test rig

Work has been a little crazy lately, but I’ve still been wanting to do some I/O performance testing since we’re due to get some new servers in soon and I wanted to be able to compare apples with oranges. So this past weekend I decided to combine something I’ve been …