It sounds like you have an indexing issue.

Could you post the DDL of your tables, views and indexes for that query?

Also don't forget UNION is doing a distinct sort while...

There is a possibility which is not very accurate because of the nature of how SQLServer is maintaining those statistical informations but anyway...

You can check the rowcnt columns of the...

Subban,

It is quite normal, that your query is taking as much time:

you have 426520 pages (3,5GB) with an average page density of 95.86 and an overal scan density of 99,98% which...

Why not to use the scope_identity right after the insert?

CREATE PROCEDURE Archive

(   @ CurrentRecordID int,

     @ArchiveRecordID int OUTPUT

) 

AS

SET NOCOUNT ON

INSERT INTO tblRecordsArchive

(column 1, column 2, column3)

SELECT @ArchiveRecordID = scope_identity()

As Frank told you, it is impossible to pass a table as a parameter to a stored proc.

I personnally would use in your place a global temporary table (##Temp) which...

There is an another quick and dirty check about the most used tables:

You can check the rowmodctr columns in the sysindexes tables. This counts the total number of inserted, deleted,...

Also do not forget the order of precedence.

The having clause is done after the join and the where clause are "executed", the dataset is available and just after the filter...

No. This is not what I meant.

If there is no clustered index on the table, you are NOT ABLE to defragment that table, even if the table is heavyly fragmented.

Only...

I wouldn't say so quickly that every table should have a clustered index.

In fact having a clusterd index on a table where you have a very large amount of insert...

You can also use MS Visio

Target Server Memory(KB) and Total Server Memory (KB) values in the master..sysperfinfo table?

As Jeff just told you, at the really first step you have to check the indexes.

Use the Profiler to check which are the statements using the most of the ressources...

Or you can  use the SQLServer specific notation (which is not encouraged any more because MS could discontinue to use it in the future version).

The MS specific notation looks like...

MS SQLServer is only available on Windows platform.

On Unix you have onother SQL RDBMS like Oracle, DB2, Sybase, Informix or even PostgreSQL, MySQL etc.

Use this to insert the data into your workfile:

The -t switch supposes that you have comma (,) as field separator Of cours you have to change all the My... data...