If you have not turned on AWE, then regardless of the amount of memory you allocate to SQL Server, it will not use anything above the 4GB line.

If you have...

When we were looking at how to provision the storage we wanted, we looked at SAN, NAS and DAS.  NAS got rejected quickly due to performance issues.  The cost for...

Any request such as you have received has to be subject to a cost / risk analysis.  You should also verify with the auditors and your mangement that any solution...

Colin,

You will need to talk to your choice of SAN vendors concerning the serialisation of replicated data.  With HDS and asynchronous replication, we have an assurance that replicated data is...

The active/active applications update the databases in GB and US independantly.  There is no replication or other link between them.  We have a reconciliation process that periodically checks the two...

We use SAN replication for SQL between our GB and US data centers.  We use HDS 9900 series SANS at both sites.  Our applications are classed as active/active or active/pasive,...

One problem may be network connectivity.  We had a similar issue, but our network support people would not accept it was a network problem.

Eventually one of our guys wrote a...

I think when you look at the stats, the world's most popular sport by a very long way is fishing.  But maybe a database for fishing is not such a...

It is not the complexity of the sport that drives the database needs.  The complexity of the media operation around the sport requires complexity a few orders of magnitude greater...

There are a few issues with SP4, listed below.  All of them have fixes or workarounds except d) which you have to live with.  I would recommend applying the latest...

Logging in Tempdb is done in exactly the same way as for any other DB in Simple recovery mode.  i.e. everything gets logged, so that anything can be backed out. ...

So, you had a steam locomotive and have just purchased a diesel and want to know where to put the coal in so it works?

AWE is not relevant with 64-bit. ...

I have had situations where the Exchange account name is case sensitive.  Normally this case is not an issue, but for some of our mail profiles they only work if...

Most of your time will be spent in I-O, so your 8 processors will not get overworked.

The time will depend on the I-O rate of your disk system, and how...

SQL2005 skills are still a bit hard to find this year.  By next year it will become hard to find people willing to work on SQL2000.  Likewise with VS2005 and...