I fundamentally don’t understand SQL JOIN clauses. That’s not to say I can’t read and parse them, I just don’t understand them well enough to be able to write them and be confident of exactly what’s happening. In my brain, this means I fail some kind of test. I think that being able to naturally understand and write JOIN clauses is pr...

read more

You can’t use an ALTER statement in SQL Server 2000 to convert a text field to a ntext field, but you can use Enterprise Manager to do the same thing. Warning, your data may be at risk if you do not keep up payments. Terms and Conditions apply.

read more

SQL Mail only supports extended MAPI. What’s wrong with SMTP? I hate SQL Server.

read more

I don’t pretend to be a DBA but currently at work that’s part of my role (what was that sa password again?). Anyway, the Java Performance Tuning website has a recent Question of the Month which just happens to deal with primary key efficiency in SQL Server – well wort...

read more

Well, having avoided it for as long as possible, preferring to use the Jena API, I now find myself having to know how to form RDQL queries. RDQL is an implementation of an SQL-like query language for RDF., and it’s also not actually that easy, especially if you’ve heard people say thing...

read more