-
Full-Text Search Operators – Part 2: Replacing alternate operators
In this post I’m going to deal with another piece of the puzzle that I described in part 1. Now, after re-reading that post it became obvious that I probably need to outline what the end result is meant to… continue reading…
-
Removing accented and illegal characters from a string
This post isn’t related to the series I’m currently writing on Full-Text search operators, but it is in the same ball-park so I thought I’d throw it up here. Today I was working on our search term auto-suggest system (i.e.… continue reading…
-
Full-Text Search Operators – Part 1: Cleaning up parentheses in a string
Part 1: Cleaning up parentheses in a string Part 2: Replacing alternate operators Part 3: Splitting the search string Part 4: Wrapping it up A few years ago I wanted to have a crack at improving one of our websites’… continue reading…
-
Generate scripts to detach/attach all databases
I haven’t had time to do any Denali testing since my last post, so instead I thought I’d share a script I wrote a while ago which simply generates a script to attach one or more databases using their current… continue reading…
-
Do you want a job? Then don’t do this…
We’re always looking for good “database folk” (i.e. DBA’s or database developers). Its fair to say that the pickings have been pretty slim for some time now, but we still get a constant trickle of applications that make me want… continue reading…
-
Identifying unique indexes that aren’t defined as unique
Confused? So am I, but after changing the title of this post about a dozen times this is what we’re left with… 🙂 I was in the process of examining some indexes on our test Denali server (see previous posts)… continue reading…