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...

Full backups don't truncate the log and hence don't break the log chain. In your example, it's possible to take the previous day's full backup and restore all the logs...

You can, but you'll have to check every single input box and every query string. It's probably better to look at the code of the app and see how it's...

The problem with this is that the repeated (Column = Variable or variable = constant) expressions confuse the optimiser's estimations of rows affected (on 2005 definitly, not sure about 2008)

It's...

Table variables are always added to the TempDB system tables and are allocated space within TempDB. They won't actually be written to disk unless there's memory pressure, but the framework...