Will this work on 64 bit Sql Server?

Paul

That's a lot cheaper than it used to be. My last customer had a quad processor server and was charged £2000 ($4000) + £500 pa support.

Thanks for the info.

Paul

What are the costs of the various products these days? The last time I was involved with Litespeed it was very negotiable. I got the feeling the price was highly...

The TOP on deletes and updates is so useful.

It's easy to forget that SET ROWCOUNT will affect triggers. ie You can end up with orphaned rows.

Coalesce can be so usefull and easy to read.

Inheritence is a good example

eg select 'EmailAddress' = coalesce(UserEmail, OfficeManagerEmail, DivisionManagerEmail)

The two the most common bugs that I have had to deal with are:

where a nullable column is tested for <>

eg If there is a Status column and one tests

Select/Update/Delete TableName Where...

I'd be interested to know how you configured your memory. I too have 4Gb ram and I have not been that successful using it.

In my boot.ini I've tried /3GB. SQL...