Solution for constipated mathematicians, work it out with paper and pencil, if that doesn't work use LOGs

Consuming XML isn't hard, it's digesting it and it makes my eyes water to parse it.

I've used it for what it is supposed to be used for. Separating content...

If I ever get to the States it will be beers all round.

I don't have many ambitions in life but I would really LOVE to have a game of baseball...

In my first job we had a guy ring up the IT department and ask

You know these computer viruses? Can humans catch them?

This from a guy who forgot his...

In nearly 20 years I've always been fortunate in that I have worked for companies where extra hours over those in the contract were recognised. Not always in financial...

If I remember correctly Lotus Approach relies on the old DBF format.

You could use a DTS package to export the data you want into suitable DBF files to use for...

A primary key is a special sort of unique index.

The difference between an primary key and a unique index is

• A primary key cannot contain a NULL value
• A primary key is...

I'm wondering if it has something to do with caching.

QA will be running this query from scratch. Perhaps the SQLSERVERAGENT has an execution plan cached in some way.

If you...

If I understand you correctly you have a primary key with two columns in it.

A search using the two columns within the primary key should use an index seek, or...

Are you talking about SQL 7.5/2000?

I used to do something similar using a Data Transformation Services (DTS) package within SQL Server.

Transfering the queries is a little more involved.

SELECT, INSERT and...

I am guessing that dope24_sa was an attempt to create a sysadmin role that wasn't the SA login.

Prior to SQL2005 NOT having objects owned by the dbo was always ended...

If you are using SQL2000 there are stored procedures that let you use ActiveX controls.

sp_oaCreate etc.

You can instantiate a copy of word then call methods from the Word object model.

I...

It is to do with the way in which EM makes its connections. You should try the new Management Studio if you have a timeout fetish. ...

Best practice would be to

• Be explicit in your field names
• qualify your object with its owner

If you truly need dynamic SQL look at sp_executesql rather than exec. sp_executesql will...

Hope the article on Symetric Keys and Certificates comes soon!