Don't bite my head off Gail, just wanted to make the point that it is logged "differently" without typing out a lot of detail.

It's a holiday week - need to...

You may be able to get away with disabling a processor in the server BIOS rather than removing it...

MS allows for a virtualization layer to allocate resources. If you...

The answer is no, you cannot use processor affinity to try to avoid the licensing cost. You have to physically remove the processor from the server.

I am not sure...

If you are interested in the internals of what is happening that is different than:

DELETE [TableName]

I recommend you read the TRUNCATE and DELETE topics in books online.

TRUNCATE TABLE [TableName]

This will remove all rows from the table. TRUNCATE is a non-logged operation, so if you are using log shipping or have regular log backups running, it...

TRUNCATE is a way of removing all data from a table.

What are you trying to do?

Perhaps it would be better for you to describe what you are trying to do.

Do you mean TRUNCATE?

You should use the new join syntax. The old syntax is only really being supported for backwards compatibility and the *= syntax for outer joins is already unsupported.

As far...

Again, the only way you can use any additional memory would be to enable AWE. This may help alleviate the problem, but it is pretty likely that the 3rd...

Analysis Services will cache data automatically in most cases. If you are having performance issues with just one tool, it is most likely that the tool is generating inefficient...

Without AWE enabled, adding memory will do nothing.

My first suggestion would be to move the SQL servers to another machine and make it a 64 bit machine. You are...

That checkbox will not work either. MS documented it in books online. Use package configurations or dynamically set it with a variable in the package.

You did not note if this was a 32bit or 64bit machine.

Unless your applications are AWE-aware, adding memory is only going to help SQL - and it will only help...

The answer is that you cannot do this. If you need to index the view, you must remove the hint.

I would go back and question the use of NOLOCK....