according to Microsoft, if you use a SAN you need some different counters

Thanks for sharing. One more reason not to use select *

first make copy (try to name the fields instead of using select *)

SELECT * INTO Table2

FROM Table1

WHERE Finished='Yes'

afterwards cleaning out table1

the inner joins verifies you are only deleting "copied" records...

1) the query has extra subselects in the select clause, move them where possible in the from or where clause.

Have a look at

http://www.sql-server-performance.com/sql_server_performance_audit10.asp

and

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

to analyze query...

make sure you join with the new table then in order not to delete fresh finished records.

1) cursors are mostly used as last resorts (because they are such a performance drain on the server) to implement complex logic. Beginners tend to use them also because it...

1) is there any firewall in between?

2) What is the OS of your sql server and is sql server patched up to at least SP3+hotfix or SP4?

Can you trace the sql statements sent to sql server using sql profiler?

You can then analyze the query plans in the query analyzer (display estimated query plan)

Possible causes:

a query is...

1)Haven't really got that situation myself, but it can be because connections aren't closed as quickly as possible after their use.

http://www.15seconds.com/issue/040830.htm

3) It all depends wath the server will do,...

You don't need to take a database offline to back it up.

Attaching/detaching: allows to copy the mdf/ldf files.

does the sql agent account has the rights to start the reindexing?

* are your insert and update 2 different actions/inserts. Could it be that one connections uses the default dateformat (us_english m/d/y)

the only things that really helps is having the client updating...

I would start with backup/restore

Than security

Then see other topics above.

I didn't have the need yet to use DTS packages or SQLMail.

*misread*

Excuse me, my mind is a bit troubled.

The scripts was well done

Can you post an example of wanted output? Do you mean like a roster?

Squadrons

        list of divisions

                   list of...

This is because the order of execution. JOINS before where, where before having...

select Label,Color,SampleLabel

from TblSample

LEFT OUTER JOIN VWClosedSampleQuotaView X

 ON TblSample.Label = X.SampleLabel

gives

Label Color SampleLabel

Alice Red Alice

Bob Red Bob

Cathy Red Cathy

David Blue David

Ellen Blue Ellen

Fred Blue Fred

Gale Yellow Gale

Harold Yellow Harold

Irene Yellow Irene

Apply where clause SampleLabel-> no records...