-
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… continue reading…
-
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… continue reading…
-
Full-Text Search Operators – Part 4: Wrapping it up
Part 1: Cleaning up parentheses in a stringPart 2: Replacing alternate operatorsPart 3: Splitting the search string Gee, it’s been over a month since my last post already! Since then we’ve been crazy-busy at work, but the good news is… continue reading…
-
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… continue reading…
-
Full-Text Search Operators – Part 3: Splitting the search string
Part 1: Cleaning up parentheses in a string Part 2: Replacing alternate operators We’ve now got to the point where we have a “clean” search string. The next step is to split the string into rows which we can then… continue reading…
-
Look where you want to go
I ride a motorbike to and from work every day. I thoroughly enjoy getting out on my Suzuki whenever possible – in fact I no longer even own a car. So obviously it was only a matter of time before… continue reading…