Task manager's a bad way to see SQL server's memory. Use perfmon rather and look at the total server memory and target server memory (under SQL server:Memory manager) and the...

I've already put in my 2 cents on nolock... I'll...

The databases are marked suspect and are not accessible? Do you have up-to-date backups?

Just to confirm, you are using SQL 2005?

You should be able to restore it.

Primary key:

SELECT name from sys.tables where objectproperty(object_id,'TableHasPrimaryKey') = 0

Clustered index:

SELECT name from sys.tables where objectproperty(object_id,'TableHasClustIndex') = 0

Just bear in mind that NOLOCK...

Lock pages is ignored by standard edition.

What's your SQL service's max and min memory set to?

Also, check the disk performance. Run perfmon for a while (24 hours or so) preferably...

http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/

http://sqlinthewild.co.za/index.php/2008/08/28/an-example-exec-plan/

In essence, it's a single row seek to either the clustered index or the heap to get columns that are needed, but not present in the nonclustered index that was...

Rather don't run the profiler GUI on the server. That's one of the highest-impact ways to run profiler. If the server is busy, or you're tracing frequent events, rather use...

OLAP/OLTP isn't a database type distinction. It referes to how the DB is used.

OLTP - Online transaction processing. So if the DB is constantly getting small requests from a time-critical...

Rather ensure that your web app is using only stored procedures, calls them using parameters and that the web user has no rights to any of the base tables. That...

Just bear in mind that currently SQL 2005 is not completely supported on any form of virtual machine and that SQL 2008 is only currently completely supported on Hyper-V

http://support.microsoft.com/kb/956262

Jeff Moden (9/3/2008)

---

If the MDF or LDF is physically fragmented, it'll affect SQL just as it would any program in the form of non contiguous files and excessive read head...

First thing is that there's absolutely no need for the temp table. Just do the select straight with the order by included.

Which tables is it scanning and what do the...

Then implement some backup jobs. Next time it could be you getting the written warning, or fired. You won't be able to say 'I didn't know there weren't backups'

If the...