I for one can not understand why people want to differentiate between tables and views using prefixes. They are not different! For instance, consider this common scenario:

You have a table...

If you look downt the FIX list for SQL2000 SP4 + the AWE cockup hot fix you will see that a number of fixes are for improving slow running queries.

I...

Because allowing dirty reads means the data integrity might be compromised. What if someone makes a decision based on incorrect data? Databases are used not for performance, but for protecting...

BOL does refer to "some exceptions", so it is not quite contradictory. I had not heard specifically that NOLOCK would need to be specified using WITH, just that table hints...

I have also heard that, or at least something similar. However in September CTP it is possible to specify NOLOCK without WITH, although you must use parentheses. Like so:

SELECT foo,...

You are mostly right. Page sizes cannot be changed, and cache size cannot be changed directly (though indirectly by modifying the entire amount of memory available to SQL Server). The...

The answer to all these questions: CTP Madness

But you cannot trigger for reads. You will need to trace with Profiler or similar for this information.

What do you mean by used? There is no information created automatically about when the data in a table was read and/or modified.

It was the awe setting that took you from 1.8 to 5.1 GB ram. That is for sure. Now, here is a guess: the /3GB switch might be a problem...

Have you checked the -e startup parameter that SQL Server is started with? Maybe you are not looking at the path that SQL Server uses for it's error logs.

There was some Latin signatures earlier, so I guess I'll chip in with my favorite:

Quid quid latine dictum sit, altum viditur

And the one I live by:

Docendo discimus

There is no such thing as a specific order in a set of tuples (which is more or less what a table represents). If you need the data to be...

Just to clear myself: I am not saying you should never store files inside the database. Neither am I saying you should. It dpends.

The max size for blob data is 2GB. Whether you should store files that big or not is a different question.