Any fool can build something complicated and the telecoms industry has some of the smartest fools in existence.

In the UK we have "Vodaphone Simple" which is just a phone and...

Thanks but in the proc I my paramter is an XML type writing to a field of an XML type.

When I am declaring the SqlParameter in .NET what type should...

You have to be very careful with these surveys and look at who is sponsoring them.

For example, directors of UK companies hire an independent wage consultant to set their salaries....

My mum used to do an annual collection of charity boxes for the NSPCC and had to tot up and log the amounts by hand.

I wrote a program on the...

SQL Server does not have a separate time field.

SMALLDATETIME contains dates and times accurate to the minute

DATETIME contains dates and times accurate to 3 milliseconds.

If you want to change the...

Some life's observations from an old fart

• No organisation shrinks to greatness!
• But it doesn't stop them trying
• Layoffs get exponentially scarier when you breach 40
• Pay peanuts, get monkeys
• If you work for a...

After a stiff expresso I sorted it.

Table structure was loosely

• ProductId
• DateFrom
• DateTo
• Price

Ages were produced by a table function returning a single column of ages.

What I wanted was to bring back all products...

If you have 6 instances spread across 2 nodes (making 6 virtual and 12 real) then you need to apply the service pack to your 6 instances.

SP4 is cluster aware...

My experience of training has been varied.

The best one was when the official trainer had called in sick and a emergency contractor had to be called in. He taught...

A person who does a good job makes it look easy. If it looks easy then it looks as if anyone could do it.

Do you have AWE enabled?

If so then you need to install the 2040 hot fix as well as SP4 (build 2039).

Each instance needs a separate install of the service pack.

SP4...

I have a friend who was slightly worried about where we left our cars when we went to a rock concert.

You don't have your works lap top in the boot...

As far as I can tell the advantages of XML are:

• It can get through port 80 in a firewall without scaring network admins
• It is geek readable so where the originator...

I don't believe that it is possible directly.

I have used an INSTEAD OF trigger on a view to achieve something similar but to be honest the simplest way is with...

So Job has a dependency on the Person existing before it can be entered?

Wrap it up in a transaction and have separate INSERT statements.