XP is designed to be a desktop OS.  W2003 is designed to be a Server OS.

Using XP for application development is fine, but the servers used for system testing upwards...

If you are using different character set code pages, then you should be OK.  If you use different collation sets then ther aer a few things to look out for.

If...

Our standard for all applications is to install them to a E: drive, leaving C: for the OS.  We found that the initial install of SQL 2005 used about the...

Colin is right (as normal...)  If your vendor insists on showing their ignorance in this way, ask them to give you some benchmark statistics to prove what they are saying...

The only functionality in the whole of the SQL2000 and SQL2005 32-bit product set that is AWE-aware is the database buffer pool.  All other storage in the 32-bit versions of both...

It has taken Microsoft so long to upgrade SQL Server that we have mostly grown used to making do with what we have got.  Or is it that even with...

SQL Agent is not AWE-aware, so it cannot use any memory above the 4GB line.  The memory value it reports will depend on the API call it made to Windows. ...

With most DBMSs, a low cardinality index very seldom gives a performance advantage. 

When a DBMS is deciding to use an index, it will first calculate the I-O 'cost' of...

The reason master and msdb are different databases is that they came into the SQL Server product at different times.  Once the decision had been made to have separate databases,...

Companies expect a lot more time from their employees than in years past.  There is pressure to have a cell phone with you 24x7, and have it switched on...!  Just...

In 1984 I visited the US from England, arriving at JFK with hand baggage only.  Time taken from leaving the plane to leaving the terminal was about 15 minutes, most...

The issue is not with the AWE memory allocation, it is to do with the normal memory allocations SQL makes below the 4GB line.  The argument I was given by...

Yes, you need to do both.  Use /PAE in boot.ini to enable extended adressing support in Windows, then enable AWE in SQL to allow SQL to use the enabled support.

My...

The /3GB switch is in BOOT.INI and therefore refers to the operating system, not SQL Server. 

With 32-bit addressing, you can access 4GB of memory.  This is normally divided by...

Let's go back to Service Management (as per ITIL) and Audit (as per COBIT) best practice. 

The job of Service Management professionals is to 'pull' the framework of corporate IT so that it:

a) Is...